contig_metadata
21 rows where bioproject = "PRJNA944406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2200414 | 2200414 | PRJNA944406_P_NODE_91502_length_245_cov_0.895349_g90543_i0 | PRJNA944406 | 91502 | 245 | 0.895349 | 2.19360505 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 55.1 | 1.71e-6 | NR | CAI8042894.1 | 519541 | g90543 | i0 | 43.3 | 1.45714285714286 | 60 | 33 | 73.5 | 1 | 241 | 62 | 655 | 713 | CAI8042894.1 hypothetical protein GBAR_LOCUS23793 [Geodia barretti] | diamond | 357 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 8577503 | 8577503 | PRJNA944406_P_NODE_46107_length_267_cov_1.268041_g45148_i0 | PRJNA944406 | 46107 | 267 | 1.268041 | 3.38566947 | root | 1 | Root_unresolved | Root_unresolved | 138 | 6.61e-38 | NR | XP_065917917.1 | 196820 | g45148 | i0 | 79.1 | 6.7977528089887604 | 86 | 18 | 96.6 | 0 | 263 | 6 | 27 | 112 | XP_065917917.1 large ribosomal subunit protein uL18-like [Dysidea avara] | diamond | 1815 | 139 | 0.992805755395683 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 8912285 | 8912285 | PRJNA944406_P_NODE_4787_length_598_cov_2.053333_g3852_i0 | PRJNA944406 | 4787 | 598 | 2.053333 | 12.27893134 | Tethya | 34493 | Porifera | other_Eukaryota | 161 | 9.419999999999999e-35 | NTclustered | gi|147931666|gb|AY626300.2| | 299121 | g3852 | i0 | 92.793 | 20.8612040133779 | 111 | 8 | 19 | 0 | 59 | 169 | 2392 | 2282 | Tethya sp. UCMPWC957 28S large subunit ribosomal RNA gene, complete sequence | blastn | 12475 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tethyida | Tethyidae | Tethya | Tethya sp. UCMPWC957 | |
| 14952330 | 14952330 | PRJNA944406_P_NODE_28272_length_283_cov_4.323810_g27313_i0 | PRJNA944406 | 28272 | 283 | 4.32381 | 12.2363823 | Topsentia ophiraphidites | 281489 | Porifera | other_Eukaryota | 52.8 | 0.026 | NTclustered | gi|164420995|ref|NC_010204.1| | 281489 | g27313 | i0 | 100 | 0.0989399293286219 | 28 | 0 | 10 | 0 | 118 | 145 | 2418 | 2391 | Topsentia ophiraphidites mitochondrion, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Topsentia | Topsentia ophiraphidites | |
| 17502774 | 17502774 | PRJNA944406_P_NODE_42934_length_270_cov_1.223350_g41975_i0 | PRJNA944406 | 42934 | 270 | 1.22335 | 3.303045 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 165 | 3.05e-36 | NTclustered | gi|2732892859|ref|XM_065341410.1| | 27933 | g41975 | i0 | 80.909 | 88.2148148148148 | 220 | 32 | 80 | 8 | 55 | 269 | 737 | 523 | PREDICTED: Sycon ciliatum ribonucleoside-diphosphate reductase subunit M2 B-like (LOC135828995), transcript variant X1, mRNA | blastn | 23818 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 21327235 | 21327235 | PRJNA944406_P_NODE_9577_length_402_cov_0.881459_g8618_i0 | PRJNA944406 | 9577 | 402 | 0.881459 | 3.54346518 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 149 | 2.81e-42 | NR | XP_065826464.1 | 121494 | g8618 | i0 | 63.9 | 156.238805970149 | 108 | 36 | 80.6 | 1 | 1 | 324 | 108 | 212 | XP_065826464.1 ras-related C3 botulinum toxin substrate 1 isoform X1 [Oscarella lobularis] | diamond | 62808 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 22601317 | 22601317 | PRJNA944406_P_NODE_16338_length_319_cov_3.898374_g15379_i0 | PRJNA944406 | 16338 | 319 | 3.898374 | 12.43581306 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 99 | 3.79e-16 | NTclustered | gi|2664275743|ref|XM_062644631.1| | 121492 | g15379 | i0 | 83.81 | 0.589341692789969 | 105 | 16 | 33 | 1 | 215 | 318 | 169 | 273 | PREDICTED: Corticium candelabrum casein kinase II subunit alpha-like (LOC134177856), mRNA | blastn | 188 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 26898891 | 26898891 | PRJNA944406_P_NODE_88781_length_245_cov_1.790698_g87822_i0 | PRJNA944406 | 88781 | 245 | 1.790698 | 4.3872101 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 43.1 | 0.0287 | NR | XP_065199240.1 | 27933 | g87822 | i0 | 30.1 | 0.893877551020408 | 73 | 51 | 89.4 | 0 | 227 | 9 | 133 | 205 | XP_065199240.1 uncharacterized protein LOC135830944 [Sycon ciliatum] | diamond | 219 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 27467853 | 27467853 | PRJNA944406_P_NODE_42943_length_270_cov_1.213198_g41984_i0 | PRJNA944406 | 42943 | 270 | 1.213198 | 3.2756346 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 62 | 2.49e-9 | NR | XP_062512235.1 | 121492 | g41984 | i0 | 48.1 | 3.47777777777778 | 79 | 38 | 87.8 | 2 | 237 | 1 | 4 | 79 | XP_062512235.1 leucine-rich melanocyte differentiation-associated protein-like [Corticium candelabrum] | diamond | 939 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 27467891 | 27467891 | PRJNA944406_P_NODE_91123_length_245_cov_0.895349_g90164_i0 | PRJNA944406 | 91123 | 245 | 0.895349 | 2.19360505 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 58.2 | 1.38e-7 | NR | XP_065916137.1 | 196820 | g90164 | i0 | 56.8 | 0.869387755102041 | 37 | 16 | 45.3 | 0 | 112 | 2 | 323 | 359 | XP_065916137.1 zonadhesin-like [Dysidea avara] | diamond | 213 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 28383380 | 28383380 | PRJNA944406_P_NODE_73486_length_249_cov_0.875000_g72527_i0 | PRJNA944406 | 73486 | 249 | 0.875 | 2.17875 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 58.5 | 1.1e-7 | NR | XP_064399935.1 | 6063 | g72527 | i0 | 45.3 | 0.903614457831325 | 75 | 38 | 89.2 | 2 | 249 | 28 | 113 | 185 | XP_064399935.1 uncharacterized protein LOC135346290 [Halichondria panicea] | diamond | 225 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 28951926 | 28951926 | PRJNA944406_P_NODE_22788_length_289_cov_1.328704_g21829_i0 | PRJNA944406 | 22788 | 289 | 1.328704 | 3.83995456 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 43.9 | 0.0268 | NR | XP_065899377.1 | 196820 | g21829 | i0 | 29.7 | 0.664359861591695 | 64 | 45 | 66.4 | 0 | 196 | 5 | 2350 | 2413 | XP_065899377.1 uncharacterized protein [Dysidea avara] | diamond | 192 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 29267216 | 29267216 | PRJNA944406_P_NODE_10269_length_389_cov_1.462025_g9310_i0 | PRJNA944406 | 10269 | 389 | 1.462025 | 5.68727725 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 129 | 1.15e-35 | NR | XP_011409557.2 | 400682 | g9310 | i0 | 65.7 | 0.763496143958869 | 99 | 33 | 75.6 | 1 | 374 | 81 | 28 | 126 | XP_011409557.2 PREDICTED: 60S ribosomal protein L44-like [Amphimedon queenslandica] | diamond | 297 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 29621063 | 29621063 | PRJNA944406_P_NODE_45830_length_267_cov_1.489691_g44871_i0 | PRJNA944406 | 45830 | 267 | 1.489691 | 3.97747497 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 139 | 9.96e-38 | NR | CAI8058029.1 | 519541 | g44871 | i0 | 66.3 | 9 | 89 | 30 | 100 | 0 | 1 | 267 | 210 | 298 | CAI8058029.1 Methionine aminopeptidase 1 [Geodia barretti] | diamond | 2403 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 29867382 | 29867382 | PRJNA944406_P_NODE_19411_length_298_cov_3.288889_g18452_i0 | PRJNA944406 | 19411 | 298 | 3.288889 | 9.80088922 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 92 | 6.34e-22 | NR | CAI8058541.1 | 519541 | g18452 | i0 | 74.5 | 4.7013422818792 | 55 | 13 | 54.4 | 1 | 277 | 116 | 26 | 80 | CAI8058541.1 40S ribosomal protein S29 [Geodia barretti] | diamond | 1401 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 29874201 | 29874201 | PRJNA944406_P_NODE_85591_length_246_cov_0.890173_g84632_i0 | PRJNA944406 | 85591 | 246 | 0.890173 | 2.18982558 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 60.5 | 2.26e-8 | NR | XP_065838139.1 | 121494 | g84632 | i0 | 47.2 | 1.29268292682927 | 53 | 28 | 64.6 | 0 | 159 | 1 | 557 | 609 | XP_065838139.1 uncharacterized protein [Oscarella lobularis] | diamond | 318 | 60.8 | 0.995065789473684 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 30720344 | 30720344 | PRJNA944406_P_NODE_70094_length_250_cov_0.870056_g69135_i0 | PRJNA944406 | 70094 | 250 | 0.870056 | 2.17514 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 132 | 1.06e-33 | NR | XP_065829982.1 | 121494 | g69135 | i0 | 72 | 0.984 | 82 | 23 | 98.4 | 0 | 248 | 3 | 535 | 616 | XP_065829982.1 uncharacterized protein [Oscarella lobularis] | diamond | 246 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 30846810 | 30846810 | PRJNA944406_P_NODE_37334_length_275_cov_1.415842_g36375_i0 | PRJNA944406 | 37334 | 275 | 1.415842 | 3.8935655 | Oopsacas minuta | 111878 | Porifera | other_Eukaryota | 79 | 9.75e-15 | NR | KAI6657704.1 | 111878 | g36375 | i0 | 48.7 | 1.63636363636364 | 76 | 39 | 82.9 | 0 | 1 | 228 | 444 | 519 | KAI6657704.1 hypothetical protein LOD99_449 [Oopsacas minuta] | diamond | 450 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Lyssacinosida | Leucopsacidae | Oopsacas | Oopsacas minuta | |
| 30846822 | 30846822 | PRJNA944406_P_NODE_52134_length_261_cov_1.638298_g51175_i0 | PRJNA944406 | 52134 | 261 | 1.638298 | 4.27595778 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 98.6 | 2.4399999999999997e-24 | NR | XP_065916847.1 | 196820 | g51175 | i0 | 68.2 | 3.91954022988506 | 85 | 27 | 97.7 | 0 | 5 | 259 | 3 | 87 | XP_065916847.1 large ribosomal subunit protein uL29-like [Dysidea avara] | diamond | 1023 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 32080033 | 32080033 | PRJNA944406_P_NODE_89158_length_245_cov_1.581395_g88199_i0 | PRJNA944406 | 89158 | 245 | 1.581395 | 3.87441775 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 63.9 | 1.29e-9 | NR | XP_064387077.1 | 6063 | g88199 | i0 | 48.6 | 0.906122448979592 | 74 | 36 | 89.4 | 2 | 220 | 2 | 175 | 247 | XP_064387077.1 uncharacterized protein LOC135335494 [Halichondria panicea] | diamond | 222 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 32712156 | 32712156 | PRJNA944406_P_NODE_86800_length_246_cov_0.890173_g85841_i0 | PRJNA944406 | 86800 | 246 | 0.890173 | 2.18982558 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 77 | 3.27e-14 | NR | XP_065181934.1 | 27933 | g85841 | i0 | 41 | 1.59756097560976 | 78 | 46 | 95.1 | 0 | 5 | 238 | 266 | 343 | XP_065181934.1 uncharacterized protein LOC135812491 [Sycon ciliatum] | diamond | 393 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum |
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);;