contig_metadata
20 rows where bioproject = "PRJNA376117" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8053249 | 8053249 | PRJNA376117_P_NODE_37847_length_247_cov_1.511494_g37545_i0 | PRJNA376117 | 37847 | 247 | 1.511494 | 3.73339018 | Suberites domuncula | 55567 | Porifera | other_Eukaryota | 100 | 7.86e-17 | NTclustered | gi|61654673|gb|AY857444.1| | 55567 | g37545 | i0 | 78.808 | 3.08906882591093 | 151 | 30 | 61 | 2 | 15 | 164 | 1 | 150 | Suberites domuncula L29 mRNA, complete cds | blastn | 763 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Suberitidae | Suberites | Suberites domuncula | |
| 9327959 | 9327959 | PRJNA376117_P_NODE_26588_length_277_cov_1.509804_g26286_i0 | PRJNA376117 | 26588 | 277 | 1.509804 | 4.18215708 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 134 | 4.1699999999999996e-38 | NR | XP_065830937.1 | 121494 | g26286 | i0 | 70.3 | 11.6101083032491 | 91 | 27 | 98.6 | 0 | 273 | 1 | 1 | 91 | XP_065830937.1 small ribosomal subunit protein eS24-like [Oscarella lobularis] | diamond | 3216 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 9328272 | 9328272 | PRJNA376117_P_NODE_8088_length_471_cov_1.763819_g7787_i0 | PRJNA376117 | 8088 | 471 | 1.763819 | 8.30758749 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 241 | 6.18e-76 | NR | XP_065841661.1 | 121494 | g7787 | i0 | 76.8 | 8.88535031847134 | 155 | 36 | 98.7 | 0 | 470 | 6 | 45 | 199 | XP_065841661.1 large ribosomal subunit protein uL4A-like [Oscarella lobularis] | diamond | 4185 | 241 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 23351691 | 23351691 | PRJNA376117_P_NODE_18019_length_325_cov_1.920635_g17717_i0 | PRJNA376117 | 18019 | 325 | 1.920635 | 6.24206375 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 182 | 3.73e-41 | NTclustered | gi|2664247974|ref|XM_062664137.1| | 121492 | g17717 | i0 | 89.583 | 41.4430769230769 | 144 | 13 | 44 | 2 | 1 | 143 | 1267 | 1409 | PREDICTED: Corticium candelabrum tubulin beta chain-like (LOC134195127), mRNA | blastn | 13469 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 27074855 | 27074855 | PRJNA376117_P_NODE_12262_length_387_cov_1.226115_g11960_i0 | PRJNA376117 | 12262 | 387 | 1.226115 | 4.74506505 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 98.6 | 5.1800000000000006e-21 | NR | XP_011402819.2 | 400682 | g11960 | i0 | 39.5 | 0.961240310077519 | 124 | 73 | 94.6 | 1 | 374 | 9 | 324 | 447 | XP_011402819.2 PREDICTED: filamin-C-like [Amphimedon queenslandica] | diamond | 372 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 27422780 | 27422780 | PRJNA376117_P_NODE_44043_length_241_cov_0.916667_g43741_i0 | PRJNA376117 | 44043 | 241 | 0.916667 | 2.20916747 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 52.8 | 1.05e-5 | NR | XP_065909172.1 | 196820 | g43741 | i0 | 42.4 | 0.734439834024896 | 59 | 28 | 73.4 | 1 | 48 | 224 | 903 | 955 | XP_065909172.1 diacylglycerol kinase zeta-like isoform X2 [Dysidea avara] | diamond | 177 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 28734232 | 28734232 | PRJNA376117_P_NODE_43027_length_242_cov_0.911243_g42725_i0 | PRJNA376117 | 43027 | 242 | 0.911243 | 2.20520806 | Metazoa | 33208 | Porifera | other_Eukaryota | 43.9 | 0.0148 | NR | XP_064390502.1 | 6063 | g42725 | i0 | 37.3 | 3.02479338842975 | 67 | 41 | 83.1 | 1 | 232 | 32 | 1624 | 1689 | XP_064390502.1 chromodomain-helicase-DNA-binding protein 1-like isoform X2 [Halichondria panicea] | diamond | 732 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 29159293 | 29159293 | PRJNA376117_P_NODE_31069_length_261_cov_1.313830_g30767_i0 | PRJNA376117 | 31069 | 261 | 1.31383 | 3.4290963 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 119 | 4.4000000000000004e-30 | NR | XP_064382536.1 | 6063 | g30767 | i0 | 61.2 | 0.977011494252874 | 85 | 31 | 97.7 | 2 | 256 | 2 | 278 | 360 | XP_064382536.1 beta-1,3-glucan-binding protein-like [Halichondria panicea] | diamond | 255 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 29600842 | 29600842 | PRJNA376117_P_NODE_10530_length_414_cov_2.542522_g10228_i0 | PRJNA376117 | 10530 | 414 | 2.542522 | 10.52604108 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 101 | 1.56e-23 | NR | XP_064389163.1 | 6063 | g10228 | i0 | 39.1 | 1.09420289855072 | 151 | 72 | 94.9 | 1 | 406 | 14 | 5 | 155 | XP_064389163.1 uncharacterized protein LOC135337194 [Halichondria panicea] | diamond | 453 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 30074724 | 30074724 | PRJNA376117_P_NODE_10512_length_415_cov_1.225146_g10210_i0 | PRJNA376117 | 10512 | 415 | 1.225146 | 5.0843559 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 72.4 | 9.83e-12 | NR | XP_065841730.1 | 121494 | g10210 | i0 | 30.5 | 1.69879518072289 | 118 | 81 | 85.3 | 1 | 413 | 60 | 393 | 509 | XP_065841730.1 lysosome membrane protein 2-like [Oscarella lobularis] | diamond | 705 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 30106383 | 30106383 | PRJNA376117_P_NODE_9552_length_435_cov_2.069061_g9250_i0 | PRJNA376117 | 9552 | 435 | 2.069061 | 9.00041535 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 45.1 | 0.0447 | NR | XP_065190713.1 | 27933 | g9250 | i0 | 27.7 | 3.28275862068966 | 119 | 67 | 69.7 | 3 | 120 | 422 | 768 | 885 | XP_065190713.1 uncharacterized protein LOC135821643 [Sycon ciliatum] | diamond | 1428 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 30232837 | 30232837 | PRJNA376117_P_NODE_15752_length_346_cov_1.406593_g15450_i0 | PRJNA376117 | 15752 | 346 | 1.406593 | 4.86681178 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 138 | 4.46e-36 | NR | XP_065178021.1 | 27933 | g15450 | i0 | 56.3 | 4.83815028901734 | 119 | 47 | 98.8 | 3 | 3 | 344 | 8 | 126 | XP_065178021.1 uncharacterized protein LOC135808724 [Sycon ciliatum] | diamond | 1674 | 138 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 30517233 | 30517233 | PRJNA376117_P_NODE_38653_length_247_cov_0.885057_g38351_i0 | PRJNA376117 | 38653 | 247 | 0.885057 | 2.18609079 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 57 | 3.62e-7 | NR | XP_065825987.1 | 121494 | g38351 | i0 | 34.1 | 0.995951417004049 | 82 | 54 | 99.6 | 0 | 2 | 247 | 90 | 171 | XP_065825987.1 E3 ubiquitin ligase Rnf157-like [Oscarella lobularis] | diamond | 246 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 30643447 | 30643447 | PRJNA376117_P_NODE_32593_length_255_cov_1.478022_g32291_i0 | PRJNA376117 | 32593 | 255 | 1.478022 | 3.7689561 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 103 | 5.4499999999999996e-24 | NR | XP_065193880.1 | 27933 | g32291 | i0 | 58.5 | 1.92941176470588 | 82 | 34 | 96.5 | 0 | 253 | 8 | 296 | 377 | XP_065193880.1 long-chain specific acyl-CoA dehydrogenase, mitochondrial-like isoform X2 [Sycon ciliatum] | diamond | 492 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 30959642 | 30959642 | PRJNA376117_P_NODE_44154_length_241_cov_0.916667_g43852_i0 | PRJNA376117 | 44154 | 241 | 0.916667 | 2.20916747 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 69.7 | 1.18e-11 | NR | CAI8039772.1 | 519541 | g43852 | i0 | 42.7 | 2.98755186721992 | 82 | 45 | 99.6 | 1 | 2 | 241 | 513 | 594 | CAI8039772.1 Ubiquitin carboxyl-terminal hydrolase 40 [Geodia barretti] | diamond | 720 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 31180396 | 31180396 | PRJNA376117_P_NODE_45295_length_226_cov_3.575163_g44993_i0 | PRJNA376117 | 45295 | 226 | 3.575163 | 8.07986838 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 53.9 | 1.6e-6 | NR | XP_003385958.1 | 400682 | g44993 | i0 | 45.5 | 0.876106194690266 | 66 | 36 | 87.6 | 0 | 198 | 1 | 56 | 121 | XP_003385958.1 PREDICTED: clathrin light chain A-like [Amphimedon queenslandica] | diamond | 198 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 31402295 | 31402295 | PRJNA376117_P_NODE_40756_length_244_cov_1.801170_g40454_i0 | PRJNA376117 | 40756 | 244 | 1.80117 | 4.3948548 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 42.7 | 0.0387 | NR | XP_065915728.1 | 196820 | g40454 | i0 | 37.3 | 0.627049180327869 | 51 | 31 | 62.7 | 1 | 225 | 73 | 408 | 457 | XP_065915728.1 matrilin-4-like [Dysidea avara] | diamond | 153 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 31988510 | 31988510 | PRJNA376117_P_NODE_16758_length_336_cov_2.003802_g16456_i0 | PRJNA376117 | 16758 | 336 | 2.003802 | 6.73277472 | root | 1 | Root_unresolved | Root_unresolved | 117 | 6.57e-29 | NR | XP_065906177.1 | 196820 | g16456 | i0 | 45.2 | 4.02678571428571 | 115 | 58 | 98.2 | 1 | 5 | 334 | 149 | 263 | XP_065906177.1 epoxide hydrolase 4-like [Dysidea avara] | diamond | 1353 | 118 | 0.991525423728814 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 32477924 | 32477924 | PRJNA376117_P_NODE_23359_length_288_cov_1.432558_g23057_i0 | PRJNA376117 | 23359 | 288 | 1.432558 | 4.12576704 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 50.8 | 4.55e-5 | NR | XP_011407823.2 | 400682 | g23057 | i0 | 49.1 | 0.572916666666667 | 55 | 27 | 56.3 | 1 | 286 | 125 | 79 | 133 | XP_011407823.2 PREDICTED: TBC1 domain family member 2A-like, partial [Amphimedon queenslandica] | diamond | 165 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 32715613 | 32715613 | PRJNA376117_P_NODE_37760_length_247_cov_1.770115_g37458_i0 | PRJNA376117 | 37760 | 247 | 1.770115 | 4.37218405 | Opisthokonta | 33154 | Porifera | other_Eukaryota | 45.4 | 0.0042 | NR | XP_019863083.1 | 400682 | g37458 | i0 | 34.8 | 5.51417004048583 | 69 | 44 | 82.6 | 1 | 43 | 246 | 179 | 247 | XP_019863083.1 PREDICTED: GTPase-activating Rap/Ran-GAP domain-like protein 3, partial [Amphimedon queenslandica] | diamond | 1362 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica |
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);;