contig_metadata
8 rows where bioproject = "PRJNA946307" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3477639 | 3477639 | PRJNA946307_P_NODE_2323_length_955_cov_15.764901_g1890_i0 | PRJNA946307 | 2323 | 955 | 15.764901 | 150.55480455 | Suberites sp. RT-2017 | 1973069 | Porifera | other_Eukaryota | 86.1 | 9.53e-12 | NTclustered | gi|1172523174|gb|KX949575.1| | 1973069 | g1890 | i0 | 100 | 7.73926701570681 | 46 | 0 | 5 | 0 | 898 | 943 | 6 | 51 | Suberites sp. RT-2017 18S ribosomal RNA gene, partial sequence | blastn | 7391 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Suberitidae | Suberites | Suberites sp. RT-2017 | |
| 3478286 | 3478286 | PRJNA946307_P_NODE_59623_length_208_cov_1.735849_g58749_i0 | PRJNA946307 | 59623 | 208 | 1.735849 | 3.61056592 | Sycon ciliatum | 27933 | Porifera | other_Eukaryota | 137 | 4.89e-28 | NTclustered | gi|457867026|emb|HF570307.1| | 27933 | g58749 | i0 | 86.4 | 61.5625 | 125 | 17 | 60 | 0 | 62 | 186 | 665 | 541 | Sycon ciliatum mRNA for 60S ribosomal protein L2/L8 (rpl8 gene) | blastn | 12805 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Calcarea | Leucosolenida | Sycettidae | Sycon | Sycon ciliatum | |
| 15288802 | 15288802 | PRJNA946307_P_NODE_73432_length_198_cov_3.335570_g72558_i0 | PRJNA946307 | 73432 | 198 | 3.33557 | 6.6044286 | Amphidiscosida | 269027 | Porifera | other_Eukaryota | 84.2 | 6.09e-12 | NTclustered | gi|222419938|emb|FM946131.1| | 582872 | g72558 | i0 | 82.979 | 38.6262626262626 | 94 | 15 | 47 | 1 | 4 | 96 | 749 | 656 | Hyalonema sp. MD-2008 partial 28S rRNA gene | blastn | 7648 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Hexactinellida | Amphidiscosida | Hyalonematidae | Hyalonema | Hyalonema sp. MD-2008 | |
| 17506340 | 17506340 | PRJNA946307_P_NODE_90194_length_188_cov_4.071942_g89320_i0 | PRJNA946307 | 90194 | 188 | 4.071942 | 7.65525096 | Oscarella pearsei | 1940113 | Porifera | other_Eukaryota | 124 | 3.37e-24 | NTclustered | gi|150024058|gb|EF654519.1| | 1940113 | g89320 | i0 | 95 | 45.686170212766 | 80 | 3 | 43 | 1 | 109 | 188 | 2021 | 2099 | Oscarella pearsei large subunit ribosomal RNA gene, partial sequence | blastn | 8589 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella pearsei | |
| 18778495 | 18778495 | PRJNA946307_P_NODE_170375_length_155_cov_4.500000_g169501_i0 | PRJNA946307 | 170375 | 155 | 4.5 | 6.975 | Prosuberites sp. G306290 | 297729 | Porifera | other_Eukaryota | 163 | 5.6400000000000003e-36 | NTclustered | gi|54639945|gb|AY626319.1| | 297729 | g169501 | i0 | 88.806 | 92.3741935483871 | 134 | 13 | 86 | 1 | 20 | 153 | 1220 | 1351 | Prosuberites sp. G306290 28S ribosomal RNA gene, partial sequence | blastn | 14318 | 163 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Suberitidae | Prosuberites | Prosuberites sp. G306290 | |
| 20052575 | 20052575 | PRJNA946307_P_NODE_126656_length_172_cov_2.162602_g125782_i0 | PRJNA946307 | 126656 | 172 | 2.162602 | 3.71967544 | Oscarella pearsei | 1940113 | Porifera | other_Eukaryota | 106 | 1.09e-18 | NTclustered | gi|150024058|gb|EF654519.1| | 1940113 | g125782 | i0 | 93.151 | 46.3139534883721 | 73 | 4 | 42 | 1 | 1 | 73 | 2092 | 2021 | Oscarella pearsei large subunit ribosomal RNA gene, partial sequence | blastn | 7966 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella pearsei | |
| 30468111 | 30468111 | PRJNA946307_P_NODE_80573_length_193_cov_3.923611_g79699_i0 | PRJNA946307 | 80573 | 193 | 3.923611 | 7.57256923 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 43.5 | 0.00854 | NR | XP_065886670.1 | 196820 | g79699 | i0 | 40 | 1.0880829015544 | 35 | 21 | 54.4 | 0 | 172 | 68 | 146 | 180 | XP_065886670.1 uncharacterized protein [Dysidea avara] | diamond | 210 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 32206775 | 32206775 | PRJNA946307_P_NODE_164218_length_161_cov_2.544643_g163344_i0 | PRJNA946307 | 164218 | 161 | 2.544643 | 4.09687523 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 48.9 | 7.04e-5 | NR | XP_062515108.1 | 121492 | g163344 | i0 | 80 | 0.46583850931677 | 25 | 5 | 46.6 | 0 | 152 | 78 | 102 | 126 | XP_062515108.1 deaminated glutathione amidase-like [Corticium candelabrum] | diamond | 75 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum |
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);;