contig_metadata
11 rows where bioproject = "PRJNA663960", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4456560 | 4456560 | PRJNA663960_S_NODE_23144_length_250_cov_1.004926_g22908_i0 | PRJNA663960 | 23144 | 250 | 1.004926 | 2.512315 | Idiosepius paradoxus | 294707 | Mollusca | Mollusca | 58.4 | 4.87e-4 | NTclustered | gi|325504932|dbj|AB586703.1| | 294707 | g22908 | i0 | 100 | 0.84 | 31 | 0 | 12 | 0 | 220 | 250 | 38 | 8 | Idiosepius paradoxus cenG mRNA for centaurin gamma homolog, complete cds | blastn | 210 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Idiosepiidae | Idiosepius | Idiosepius paradoxus | ||
| 7007526 | 7007526 | PRJNA663960_S_NODE_58606_length_161_cov_0.894737_g58370_i0 | PRJNA663960 | 58606 | 161 | 0.894737 | 1.44052657 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 54.7 | 0.004 | NTclustered | gi|2616508032|ref|XM_060706385.1| | 129788 | g58370 | i0 | 100 | 0.180124223602484 | 29 | 0 | 18 | 0 | 10 | 38 | 2627 | 2655 | PREDICTED: Ruditapes philippinarum uncharacterized LOC132721992 (LOC132721992), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 10832877 | 10832877 | PRJNA663960_S_NODE_39549_length_194_cov_0.993197_g39313_i0 | PRJNA663960 | 39549 | 194 | 0.993197 | 1.92680218 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 60.2 | 1e-4 | NTclustered | gi|2502134919|ref|XM_056013775.1| | 6526 | g39313 | i0 | 100 | 0.948453608247423 | 32 | 0 | 16 | 0 | 80 | 111 | 233 | 264 | PREDICTED: Biomphalaria glabrata guanine nucleotide-binding protein-like 3 homolog (LOC106077405), transcript variant X5, mRNA | blastn | 184 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 14657638 | 14657638 | PRJNA663960_S_NODE_27332_length_232_cov_1.027027_g27096_i0 | PRJNA663960 | 27332 | 232 | 1.027027 | 2.38270264 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g27096 | i0 | 100 | 0.495689655172414 | 30 | 0 | 13 | 0 | 3 | 32 | 29 | 58 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 115 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 19755614 | 19755614 | PRJNA663960_S_NODE_25056_length_241_cov_1.711340_g24820_i0 | PRJNA663960 | 25056 | 241 | 1.71134 | 4.1243294 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2442008155|ref|XM_045335680.2| | 6596 | g24820 | i0 | 100 | 0.232365145228216 | 28 | 0 | 12 | 0 | 185 | 212 | 229 | 256 | PREDICTED: Mercenaria mercenaria tetratricopeptide repeat protein 28-like (LOC123548423), transcript variant X1, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 19755762 | 19755762 | PRJNA663960_S_NODE_47696_length_176_cov_1.007752_g47460_i0 | PRJNA663960 | 47696 | 176 | 1.007752 | 1.77364352 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 52.8 | 0.015 | NTclustered | gi|2868637591|ref|XM_070350399.1| | 31220 | g47460 | i0 | 100 | 0.159090909090909 | 28 | 0 | 16 | 0 | 15 | 42 | 284 | 257 | PREDICTED: Littorina saxatilis ribosome-binding protein 1-like (LOC138977794), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 20288463 | 20288463 | PRJNA663960_S_NODE_43936_length_183_cov_6.183824_g43700_i0 | PRJNA663960 | 43936 | 183 | 6.183824 | 11.31639792 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.004 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g43700 | i0 | 100 | 0.622950819672131 | 29 | 0 | 16 | 0 | 155 | 183 | 57 | 29 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 114 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 22306248 | 22306248 | PRJNA663960_S_NODE_64278_length_151_cov_2.740385_g64042_i0 | PRJNA663960 | 64278 | 151 | 2.740385 | 4.13798135 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.012 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g64042 | i0 | 100 | 0.185430463576159 | 28 | 0 | 19 | 0 | 83 | 110 | 2800684 | 2800657 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 27429359 | 27429359 | PRJNA663960_S_NODE_27943_length_229_cov_2.241758_g27707_i0 | PRJNA663960 | 27943 | 229 | 2.241758 | 5.13362582 | Littorina littorea | 31216 | Mollusca | Mollusca | 42.4 | 0.0429 | NR | QNL15284.1 | 31216 | g27707 | i0 | 39.2 | 0.668122270742358 | 51 | 31 | 66.8 | 0 | 72 | 224 | 653 | 703 | QNL15284.1 mitogen-activated protein kinase kinase kinase 8 [Littorina littorea] | diamond | 153 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina littorea | |
| 29986684 | 29986684 | PRJNA663960_S_NODE_42131_length_187_cov_5.878571_g41895_i0 | PRJNA663960 | 42131 | 187 | 5.878571 | 10.99292777 | Mytilus edulis | 6550 | Mollusca | Mollusca | 42 | 0.0328 | NR | CAG2187267.1 | 6550 | g41895 | i0 | 47.6 | 0.67379679144385 | 42 | 21 | 65.8 | 1 | 65 | 187 | 192 | 233 | CAG2187267.1 unnamed protein product [Mytilus edulis] | diamond | 126 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 30492265 | 30492265 | PRJNA663960_S_NODE_47073_length_177_cov_1.176923_g46837_i0 | PRJNA663960 | 47073 | 177 | 1.176923 | 2.08315371 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 40.8 | 0.0476 | NR | CAC5360502.1 | 42192 | g46837 | i0 | 34 | 0.796610169491525 | 47 | 31 | 79.7 | 0 | 160 | 20 | 111 | 157 | CAC5360502.1 unnamed protein product [Mytilus coruscus] | diamond | 141 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus |
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);;