contig_metadata
18 rows where bioproject = "PRJNA976345", tax_kingdom = "Metazoa" and tax_phylum = "Porifera"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9876021 | 9876021 | PRJNA976345_P_NODE_142868_length_169_cov_2.335821_g141260_i0 | PRJNA976345 | 142868 | 169 | 2.335821 | 3.94753749 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 71.3 | 3.9e-8 | NTclustered | gi|2664339161|ref|XM_062649144.1| | 121492 | g141260 | i0 | 88.136 | 0.698224852071006 | 59 | 7 | 35 | 0 | 104 | 162 | 3060 | 3002 | PREDICTED: Corticium candelabrum DNA polymerase epsilon catalytic subunit A-like (LOC134181872), transcript variant X2, mRNA | blastn | 118 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 9876691 | 9876691 | PRJNA976345_P_NODE_45668_length_257_cov_1.945946_g44060_i0 | PRJNA976345 | 45668 | 257 | 1.945946 | 5.00108122 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 134 | 8.12e-27 | NTclustered | gi|2749546253|ref|XM_066040654.1| | 196820 | g44060 | i0 | 79.679 | 1.75486381322957 | 187 | 36 | 72 | 2 | 8 | 193 | 2968 | 2783 | PREDICTED: Dysidea avara ATP-dependent RNA helicase DHX8-like (LOC136248839), mRNA | blastn | 451 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 9876850 | 9876850 | PRJNA976345_P_NODE_62368_length_226_cov_1.994764_g60760_i0 | PRJNA976345 | 62368 | 226 | 1.994764 | 4.50816664 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|1133476141|ref|XM_020001838.1| | 400682 | g60760 | i0 | 100 | 0.132743362831858 | 30 | 0 | 13 | 0 | 151 | 180 | 2084 | 2113 | PREDICTED: Amphimedon queenslandica uncharacterized LOC109585711 (LOC109585711), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 12427273 | 12427273 | PRJNA976345_P_NODE_170090_length_159_cov_1.258065_g168482_i0 | PRJNA976345 | 170090 | 159 | 1.258065 | 2.00032335 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 99 | 1.67e-16 | NTclustered | gi|2719018657|ref|XM_064543019.1| | 6063 | g168482 | i0 | 82.051 | 1 | 117 | 19 | 73 | 2 | 44 | 159 | 4062 | 3947 | PREDICTED: Halichondria panicea dynein axonemal heavy chain 12-like (LOC135345604), mRNA | blastn | 159 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 17526166 | 17526166 | PRJNA976345_P_NODE_180434_length_155_cov_2.283333_g178826_i0 | PRJNA976345 | 180434 | 155 | 2.283333 | 3.53916615 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 65.8 | 1.64e-6 | NTclustered | gi|1133473032|ref|XM_003389002.3| | 400682 | g178826 | i0 | 95.122 | 0.264516129032258 | 41 | 2 | 26 | 0 | 28 | 68 | 1459 | 1419 | PREDICTED: Amphimedon queenslandica tyrosine-protein kinase SRK3-like (LOC100640678), mRNA | blastn | 41 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 26772886 | 26772886 | PRJNA976345_P_NODE_42641_length_264_cov_3.882096_g41033_i0 | PRJNA976345 | 42641 | 264 | 3.882096 | 10.24873344 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 111 | 3.94e-26 | NR | XP_065902360.1 | 196820 | g41033 | i0 | 53.4 | 15.0568181818182 | 88 | 41 | 100 | 0 | 264 | 1 | 541 | 628 | XP_065902360.1 uncharacterized protein [Dysidea avara] | diamond | 3975 | 112 | 0.991071428571429 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 26772903 | 26772903 | PRJNA976345_P_NODE_76241_length_209_cov_4.885057_g74633_i0 | PRJNA976345 | 76241 | 209 | 4.885057 | 10.20976913 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 64.3 | 5.88e-10 | NR | XP_065193161.1 | 27933 | g74633 | i0 | 63.4 | 1.20574162679426 | 41 | 15 | 58.9 | 0 | 209 | 87 | 640 | 680 | XP_065193161.1 uncharacterized protein LOC135824356 [Sycon ciliatum] | diamond | 252 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 27190189 | 27190189 | PRJNA976345_P_NODE_28582_length_315_cov_6.985714_g26978_i0 | PRJNA976345 | 28582 | 315 | 6.985714 | 22.0049991 | Metazoa | 33208 | Porifera | other_Eukaryota | 109 | 1.63e-25 | NR | XP_065195669.1 | 27933 | g26978 | i0 | 46.6 | 5.91428571428571 | 103 | 55 | 98.1 | 0 | 2 | 310 | 16 | 118 | XP_065195669.1 uncharacterized protein LOC135827074 [Sycon ciliatum] | diamond | 1863 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 27253390 | 27253390 | PRJNA976345_P_NODE_126063_length_177_cov_2.288732_g124455_i0 | PRJNA976345 | 126063 | 177 | 2.288732 | 4.05105564 | Metazoa | 33208 | Porifera | other_Eukaryota | 42.4 | 0.0187 | NR | KAI6651033.1 | 111878 | g124455 | i0 | 38.9 | 1.84745762711864 | 54 | 33 | 91.5 | 0 | 10 | 171 | 147 | 200 | KAI6651033.1 hypothetical protein LOD99_5610 [Oopsacas minuta] | diamond | 327 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 27374028 | 27374028 | PRJNA976345_P_NODE_38043_length_278_cov_1.637860_g36436_i0 | PRJNA976345 | 38043 | 278 | 1.63786 | 4.5532508 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 56.2 | 9.8e-7 | NR | XP_065186486.1 | 27933 | g36436 | i0 | 60 | 3.1726618705036 | 50 | 12 | 51.8 | 2 | 147 | 4 | 120 | 163 | XP_065186486.1 cysteine desulfurase, mitochondrial-like [Sycon ciliatum] | diamond | 882 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 27405532 | 27405532 | PRJNA976345_P_NODE_9703_length_558_cov_3.621415_g8198_i0 | PRJNA976345 | 9703 | 558 | 3.621415 | 20.2074957 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 129 | 7.389999999999999e-31 | NR | XP_064403494.1 | 6063 | g8198 | i0 | 36.4 | 5.85483870967742 | 184 | 115 | 98.9 | 1 | 553 | 2 | 544 | 725 | XP_064403494.1 uncharacterized protein K02A2.6-like [Halichondria panicea] | diamond | 3267 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 27506436 | 27506436 | PRJNA976345_P_NODE_4343_length_930_cov_36.731844_g3162_i0 | PRJNA976345 | 4343 | 930 | 36.731844 | 341.6061492 | Metazoa | 33208 | Porifera | other_Eukaryota | 297 | 1.97e-90 | NR | XP_065193161.1 | 27933 | g3162 | i0 | 56.6 | 7.98064516129032 | 251 | 105 | 80.3 | 2 | 122 | 868 | 605 | 853 | XP_065193161.1 uncharacterized protein LOC135824356 [Sycon ciliatum] | diamond | 7422 | 300 | 0.99 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 27531565 | 27531565 | PRJNA976345_P_NODE_147983_length_167_cov_1.803030_g146375_i0 | PRJNA976345 | 147983 | 167 | 1.80303 | 3.0110601 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 60.5 | 7.36e-9 | NR | XP_062504589.1 | 121492 | g146375 | i0 | 53.7 | 1.94011976047904 | 54 | 25 | 97 | 0 | 165 | 4 | 559 | 612 | XP_062504589.1 uncharacterized protein LOC134181343 [Corticium candelabrum] | diamond | 324 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 29363012 | 29363012 | PRJNA976345_P_NODE_69049_length_217_cov_3.203297_g67441_i0 | PRJNA976345 | 69049 | 217 | 3.203297 | 6.95115449 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 59.7 | 2.72e-8 | NR | XP_065193161.1 | 27933 | g67441 | i0 | 52.2 | 3.22119815668203 | 46 | 22 | 63.6 | 0 | 143 | 6 | 618 | 663 | XP_065193161.1 uncharacterized protein LOC135824356 [Sycon ciliatum] | diamond | 699 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 30531483 | 30531483 | PRJNA976345_P_NODE_164773_length_160_cov_3.648000_g163165_i0 | PRJNA976345 | 164773 | 160 | 3.648 | 5.8368 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 71.2 | 1.03e-12 | NR | XP_065193161.1 | 27933 | g163165 | i0 | 66.7 | 0.95625 | 51 | 17 | 95.6 | 0 | 6 | 158 | 732 | 782 | XP_065193161.1 uncharacterized protein LOC135824356 [Sycon ciliatum] | diamond | 153 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 31833707 | 31833707 | PRJNA976345_P_NODE_165257_length_160_cov_2.424000_g163649_i0 | PRJNA976345 | 165257 | 160 | 2.424 | 3.8784 | Metazoa | 33208 | Porifera | other_Eukaryota | 41.2 | 0.0418 | NR | XP_065190411.1 | 27933 | g163649 | i0 | 72.7 | 1.2375 | 22 | 6 | 41.3 | 0 | 68 | 3 | 583 | 604 | XP_065190411.1 A-kinase anchor protein 10, mitochondrial-like [Sycon ciliatum] | diamond | 198 | 41.6 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 32049129 | 32049129 | PRJNA976345_P_NODE_58358_length_232_cov_1.918782_g56750_i0 | PRJNA976345 | 58358 | 232 | 1.918782 | 4.45157424 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 58.5 | 8.52e-8 | NR | XP_065894635.1 | 196820 | g56750 | i0 | 71 | 4.06034482758621 | 31 | 9 | 40.1 | 0 | 94 | 2 | 108 | 138 | XP_065894635.1 uncharacterized protein [Dysidea avara] | diamond | 942 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 32365782 | 32365782 | PRJNA976345_P_NODE_41199_length_268_cov_3.343348_g39591_i0 | PRJNA976345 | 41199 | 268 | 3.343348 | 8.96017264 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 129 | 1.3399999999999998e-32 | NR | XP_065834222.1 | 121494 | g39591 | i0 | 64.4 | 0.973880597014925 | 87 | 31 | 97.4 | 0 | 266 | 6 | 537 | 623 | XP_065834222.1 uncharacterized protein [Oscarella lobularis] | diamond | 261 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;