contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA482207" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4274901 | 4274901 | PRJNA482207_P_NODE_1804_length_680_cov_1.708402_g1711_i0 | PRJNA482207 | 1804 | 680 | 1.708402 | 11.6171336 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.005 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g1711 | i0 | 97.059 | 0.05 | 34 | 0 | 5 | 1 | 557 | 589 | 10695198 | 10695165 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 34 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 5551731 | 5551731 | PRJNA482207_P_NODE_28225_length_243_cov_0.905882_g28115_i0 | PRJNA482207 | 28225 | 243 | 0.905882 | 2.20129326 | Mytilus edulis | 6550 | Mollusca | Mollusca | 102 | 2.14e-17 | NTclustered | gi|2912353022|ref|XM_071288351.1| | 6550 | g28115 | i0 | 82.353 | 2.93415637860082 | 119 | 19 | 49 | 2 | 1 | 118 | 682 | 565 | PREDICTED: Mytilus edulis kinesin-like protein KIF13A (LOC139499599), mRNA | blastn | 713 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 5551767 | 5551767 | PRJNA482207_P_NODE_30025_length_241_cov_0.916667_g29915_i0 | PRJNA482207 | 30025 | 241 | 0.916667 | 2.20916747 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 185 | 2.0499999999999998e-42 | NTclustered | gi|2502195816|ref|XM_056039804.1| | 6526 | g29915 | i0 | 85.955 | 1.11618257261411 | 178 | 20 | 73 | 5 | 67 | 241 | 713 | 888 | PREDICTED: Biomphalaria glabrata eukaryotic translation initiation factor 3 subunit G-like (LOC106064139), mRNA | blastn | 269 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 6825600 | 6825600 | PRJNA482207_P_NODE_2466_length_589_cov_1.899225_g2360_i0 | PRJNA482207 | 2466 | 589 | 1.899225 | 11.18643525 | Gigantidas platifrons | 2830794 | Mollusca | Mollusca | 1070 | 0 | NTclustered | gi|1208315051|gb|KY242718.1| | 2830794 | g2360 | i0 | 99.828 | 7.90492359932088 | 582 | 1 | 99 | 0 | 1 | 582 | 4908 | 5489 | Gigantidas platifrons mitochondrion, complete genome | blastn | 4656 | 1070 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Gigantidas | Gigantidas platifrons | |
| 8100912 | 8100912 | PRJNA482207_P_NODE_12627_length_303_cov_1.986957_g12517_i0 | PRJNA482207 | 12627 | 303 | 1.986957 | 6.02047971 | Mytilus californianus | 6549 | Mollusca | Mollusca | 82.4 | 3.6e-11 | NTclustered | gi|2334630686|ref|XR_007989291.1| | 6549 | g12517 | i0 | 74.561 | 0.752475247524752 | 228 | 39 | 72 | 16 | 87 | 303 | 402 | 183 | PREDICTED: Mytilus californianus uncharacterized LOC127717681 (LOC127717681), ncRNA | blastn | 228 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 11926862 | 11926862 | PRJNA482207_P_NODE_750_length_1009_cov_7.276709_g683_i0 | PRJNA482207 | 750 | 1009 | 7.276709 | 73.42199381 | Gigantidas platifrons | 2830794 | Mollusca | Mollusca | 1864 | 0 | NTclustered | gi|1043385544|dbj|AP014561.1| | 2830794 | g683 | i0 | 100 | 101.215064420218 | 1009 | 0 | 100 | 0 | 1 | 1009 | 8099 | 9107 | Gigantidas platifrons mitochondrial DNA, complete sequence | blastn | 102126 | 1864 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Gigantidas | Gigantidas platifrons | |
| 12576217 | 12576217 | PRJNA482207_P_NODE_4110_length_471_cov_1.366834_g4000_i0 | PRJNA482207 | 4110 | 471 | 1.366834 | 6.43778814 | Metazoa | 33208 | Mollusca | Mollusca | 870 | 0 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g4000 | i0 | 100 | 99.8386411889597 | 471 | 0 | 100 | 0 | 1 | 471 | 1151 | 1621 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 47024 | 870 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 17674789 | 17674789 | PRJNA482207_P_NODE_12314_length_306_cov_1.317597_g12204_i0 | PRJNA482207 | 12314 | 306 | 1.317597 | 4.03184682 | Mytilus | 6548 | Mollusca | Mollusca | 351 | 2.51e-92 | NTclustered | gi|2912351232|ref|XM_071287770.1| | 6550 | g12204 | i0 | 87.708 | 69.6830065359477 | 301 | 37 | 98 | 0 | 3 | 303 | 1175 | 1475 | PREDICTED: Mytilus edulis elongation factor 1-alpha (LOC139499093), transcript variant X2, mRNA | blastn | 21323 | 351 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 20223575 | 20223575 | PRJNA482207_P_NODE_28176_length_243_cov_0.905882_g28066_i0 | PRJNA482207 | 28176 | 243 | 0.905882 | 2.20129326 | Mytilus | 6548 | Mollusca | Mollusca | 182 | 2.68e-41 | NTclustered | gi|2912332097|ref|XM_071279386.1| | 6550 | g28066 | i0 | 81.25 | 4.64197530864198 | 240 | 31 | 98 | 6 | 6 | 243 | 878 | 651 | PREDICTED: Mytilus edulis small ribosomal subunit protein eS4-like (LOC139491616), mRNA | blastn | 1128 | 183 | 0.994535519125683 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis |
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);;