contig_metadata
7 rows where bioproject = "PRJNA1227535", tax_kingdom = "Metazoa" and tax_phylum = "Mollusca"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5438651 | 5438651 | PRJNA1227535_P_NODE_29145_length_244_cov_0.912281_g29021_i0 | PRJNA1227535 | 29145 | 244 | 0.912281 | 2.22596564 | Haliotis rubra | 36100 | Mollusca | Mollusca | 89.8 | 1.68e-13 | NTclustered | gi|2194096104|ref|XM_046704254.1| | 36100 | g29021 | i0 | 96.296 | 0.442622950819672 | 54 | 2 | 22 | 0 | 23 | 76 | 1301 | 1248 | PREDICTED: Haliotis rubra uncharacterized LOC124269236 (LOC124269236), transcript variant X1, mRNA | blastn | 108 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 7988707 | 7988707 | PRJNA1227535_P_NODE_21107_length_255_cov_1.714286_g20983_i0 | PRJNA1227535 | 21107 | 255 | 1.714286 | 4.3714293 | Pecten maximus | 6579 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|1835463220|ref|XM_033887903.1| | 6579 | g20983 | i0 | 100 | 0.109803921568627 | 28 | 0 | 11 | 0 | 58 | 85 | 1198 | 1171 | PREDICTED: Pecten maximus uncharacterized LOC117329773 (LOC117329773), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 11813953 | 11813953 | PRJNA1227535_P_NODE_24710_length_249_cov_1.772727_g24586_i0 | PRJNA1227535 | 24710 | 249 | 1.772727 | 4.41409023 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|1397709880|ref|XM_025246319.1| | 400727 | g24586 | i0 | 96.875 | 0.257028112449799 | 32 | 0 | 13 | 1 | 74 | 105 | 705 | 675 | PREDICTED: Pomacea canaliculata uncharacterized LOC112568822 (LOC112568822), mRNA | blastn | 64 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 15074549 | 15074549 | PRJNA1227535_P_NODE_2112_length_462_cov_1.393316_g1990_i0 | PRJNA1227535 | 2112 | 462 | 1.393316 | 6.43711992 | Metazoa | 33208 | Mollusca | Mollusca | 854 | 0 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g1990 | i0 | 100 | 100 | 462 | 0 | 100 | 0 | 1 | 462 | 1558 | 1097 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 46200 | 854 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 22011937 | 22011937 | PRJNA1227535_P_NODE_18198_length_264_cov_2.324607_g18074_i0 | PRJNA1227535 | 18198 | 264 | 2.324607 | 6.13696248 | Mytilus californianus | 6549 | Mollusca | Mollusca | 156 | 1.7900000000000002e-33 | NTclustered | gi|2334719718|ref|XM_052247310.1| | 6549 | g18074 | i0 | 87.77 | 4.06060606060606 | 139 | 10 | 52 | 4 | 127 | 263 | 6483 | 6350 | PREDICTED: Mytilus californianus uncharacterized LOC127736727 (LOC127736727), mRNA | blastn | 1072 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 27198942 | 27198942 | PRJNA1227535_P_NODE_13622_length_280_cov_1.328502_g13499_i0 | PRJNA1227535 | 13622 | 280 | 1.328502 | 3.7198056 | Mytilus galloprovincialis | 29158 | Mollusca | Mollusca | 49.7 | 1.94e-4 | NR | VDI62983.1 | 29158 | g13499 | i0 | 47.2 | 2.28214285714286 | 36 | 19 | 38.6 | 0 | 139 | 32 | 61 | 96 | VDI62983.1 Hypothetical predicted protein [Mytilus galloprovincialis] | diamond | 639 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis | |
| 28557209 | 28557209 | PRJNA1227535_P_NODE_24967_length_249_cov_0.886364_g24843_i0 | PRJNA1227535 | 24967 | 249 | 0.886364 | 2.20704636 | Bulinus truncatus | 55810 | Mollusca | Mollusca | 43.1 | 0.0288 | NR | KAH9512732.1 | 55810 | g24843 | i0 | 45.2 | 0.506024096385542 | 42 | 23 | 50.6 | 0 | 14 | 139 | 248 | 289 | KAH9512732.1 hypothetical protein Btru_038047 [Bulinus truncatus] | diamond | 126 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus |
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);;