contig_metadata
15 rows where bioproject = "PRJNA546018", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 511167 | 511167 | PRJNA546018_S_NODE_47101_length_222_cov_1.304348_g46776_i0 | PRJNA546018 | 47101 | 222 | 1.304348 | 2.89565256 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 52.8 | 0.02 | NTclustered | gi|2693867728|ref|XM_063562824.1| | 6551 | g46776 | i0 | 100 | 0.252252252252252 | 28 | 0 | 13 | 0 | 184 | 211 | 5820 | 5847 | PREDICTED: Mytilus trossulus zinc finger protein 407-like (LOC134701690), transcript variant X2, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 1786856 | 1786856 | PRJNA546018_S_NODE_60562_length_187_cov_6.857143_g60237_i0 | PRJNA546018 | 60562 | 187 | 6.857143 | 12.82285741 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 52.8 | 0.016 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g60237 | i0 | 100 | 0.149732620320856 | 28 | 0 | 15 | 0 | 160 | 187 | 59 | 32 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 2394569 | 2394569 | PRJNA546018_S_NODE_18642_length_377_cov_4.386076_g18317_i0 | PRJNA546018 | 18642 | 377 | 4.386076 | 16.53550652 | Haliotis | 6452 | Mollusca | Mollusca | 67.6 | 1.28e-6 | NTclustered | gi|2245691845|ref|XM_046521204.2| | 6454 | g18317 | i0 | 91.667 | 0.763925729442971 | 48 | 4 | 13 | 0 | 321 | 368 | 3172 | 3125 | PREDICTED: Haliotis rufescens epidermal growth factor receptor-like (LOC124149536), transcript variant X2, mRNA | blastn | 288 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 3061602 | 3061602 | PRJNA546018_S_NODE_17003_length_399_cov_1.730769_g16678_i0 | PRJNA546018 | 17003 | 399 | 1.730769 | 6.90576831 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 54.7 | 0.011 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g16678 | i0 | 100 | 0.0726817042606516 | 29 | 0 | 7 | 0 | 1 | 29 | 31 | 59 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 4947322 | 4947322 | PRJNA546018_S_NODE_24704_length_321_cov_1.853846_g24379_i0 | PRJNA546018 | 24704 | 321 | 1.853846 | 5.95084566 | Metazoa | 33208 | Mollusca | Mollusca | 52.8 | 0.03 | NTclustered | gi|2427390617|ref|XM_052917999.1| | 6604 | g24379 | i0 | 100 | 1.37071651090343 | 28 | 0 | 9 | 0 | 220 | 247 | 5153 | 5126 | PREDICTED: Mya arenaria protein mono-ADP-ribosyltransferase PARP14-like (LOC128212513), mRNA | blastn | 440 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 5614670 | 5614670 | PRJNA546018_S_NODE_26545_length_308_cov_2.809717_g26220_i0 | PRJNA546018 | 26545 | 308 | 2.809717 | 8.65392836 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 52.8 | 0.029 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g26220 | i0 | 100 | 0.0909090909090909 | 28 | 0 | 9 | 0 | 31 | 58 | 31 | 58 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 5614696 | 5614696 | PRJNA546018_S_NODE_28325_length_296_cov_7.514894_g28000_i0 | PRJNA546018 | 28325 | 296 | 7.514894 | 22.24408624 | Sinonovacula constricta | 98310 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|937961735|gb|KR534869.1| | 98310 | g28000 | i0 | 100 | 0.101351351351351 | 30 | 0 | 10 | 0 | 19 | 48 | 1 | 30 | Sinonovacula constricta insulin-like peptide 1 mRNA, complete cds | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Solecurtidae | Sinonovacula | Sinonovacula constricta | |
| 9439010 | 9439010 | PRJNA546018_S_NODE_16608_length_404_cov_3.288630_g16283_i0 | PRJNA546018 | 16608 | 404 | 3.28863 | 13.2860652 | Sinonovacula constricta | 98310 | Mollusca | Mollusca | 52.8 | 0.039 | NTclustered | gi|937961735|gb|KR534869.1| | 98310 | g16283 | i0 | 100 | 0.0693069306930693 | 28 | 0 | 7 | 0 | 373 | 400 | 28 | 1 | Sinonovacula constricta insulin-like peptide 1 mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Solecurtidae | Sinonovacula | Sinonovacula constricta | |
| 18362384 | 18362384 | PRJNA546018_S_NODE_24335_length_324_cov_1.425856_g24010_i0 | PRJNA546018 | 24335 | 324 | 1.425856 | 4.61977344 | Sinonovacula constricta | 98310 | Mollusca | Mollusca | 52.8 | 0.03 | NTclustered | gi|937961735|gb|KR534869.1| | 98310 | g24010 | i0 | 100 | 0.0864197530864197 | 28 | 0 | 9 | 0 | 297 | 324 | 32 | 5 | Sinonovacula constricta insulin-like peptide 1 mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Solecurtidae | Sinonovacula | Sinonovacula constricta | |
| 20245813 | 20245813 | PRJNA546018_S_NODE_56596_length_203_cov_1.669014_g56271_i0 | PRJNA546018 | 56596 | 203 | 1.669014 | 3.38809842 | Metazoa | 33208 | Mollusca | Mollusca | 375 | 9.24e-100 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g56271 | i0 | 100 | 99.9605911330049 | 203 | 0 | 100 | 0 | 1 | 203 | 1410 | 1612 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 20292 | 375 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 24071226 | 24071226 | PRJNA546018_S_NODE_45539_length_226_cov_2.757576_g45214_i0 | PRJNA546018 | 45539 | 226 | 2.757576 | 6.23212176 | Cyclophorus | 75122 | Mollusca | Mollusca | 71.3 | 5.55e-8 | NTclustered | gi|2251842947|dbj|LC658828.1| | 494922 | g45214 | i0 | 85.333 | 32.9690265486726 | 75 | 4 | 31 | 7 | 92 | 162 | 506 | 435 | Cyclophorus formosaensis KC8691 mitochondrial gene for 16S rRNA, partial sequence | blastn | 7451 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Cyclophoridae | Cyclophorus | Cyclophorus formosaensis | |
| 24736633 | 24736633 | PRJNA546018_S_NODE_13960_length_447_cov_9.051813_g13635_i0 | PRJNA546018 | 13960 | 447 | 9.051813 | 40.46160411 | Sinonovacula constricta | 98310 | Mollusca | Mollusca | 52.8 | 0.043 | NTclustered | gi|937961735|gb|KR534869.1| | 98310 | g13635 | i0 | 100 | 0.0626398210290828 | 28 | 0 | 6 | 0 | 1 | 28 | 5 | 32 | Sinonovacula constricta insulin-like peptide 1 mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Solecurtidae | Sinonovacula | Sinonovacula constricta | |
| 27299233 | 27299233 | PRJNA546018_S_NODE_24803_length_320_cov_3.054054_g24478_i0 | PRJNA546018 | 24803 | 320 | 3.054054 | 9.7729728 | Mytilus edulis | 6550 | Mollusca | Mollusca | 48.1 | 0.00109 | NR | CAG2204155.1 | 6550 | g24478 | i0 | 27 | 1.040625 | 111 | 71 | 94.7 | 2 | 320 | 18 | 121 | 231 | CAG2204155.1 unnamed protein product [Mytilus edulis] | diamond | 333 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 27661565 | 27661565 | PRJNA546018_S_NODE_39704_length_244_cov_2.420765_g39379_i0 | PRJNA546018 | 39704 | 244 | 2.420765 | 5.9066666 | Mytilus | 6548 | Mollusca | Mollusca | 44.3 | 0.0104 | NR | CAG2218763.1 | 6550 | g39379 | i0 | 35.5 | 3.73770491803279 | 76 | 37 | 88.5 | 3 | 16 | 231 | 206 | 273 | CAG2218763.1 Tenascin-R,Angiopoietin-related protein 1,Ryncolin-1,Fibrinogen C domain-containing protein 1-A,Fibrinogen C domain-containing protein 1,Fibrinogen C domain-containing protein 1-B,Angiopoietin-2,Fibroleukin,Fibrinogen-like protein 1,Ficolin-2,Tenascin,Ficolin-1,Fibrinogen-like protein A,Microfibril-associated glycoprotein 4,Angiopoietin-related protein 7,Ryncolin-4 [Mytilus edulis] | diamond | 912 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 30472022 | 30472022 | PRJNA546018_S_NODE_1853_length_1361_cov_9.640000_g1707_i0 | PRJNA546018 | 1853 | 1361 | 9.64 | 131.2004 | Opisthokonta | 33154 | Mollusca | Mollusca | 118 | 3.2200000000000004e-27 | NR | XP_053393133.1 | 6596 | g1707 | i0 | 37 | 5.76193975018369 | 184 | 82 | 38.8 | 4 | 629 | 1156 | 1 | 158 | XP_053393133.1 ras-related protein Rac1-like isoform X2 [Mercenaria mercenaria] | diamond | 7842 | 119 | 0.991596638655462 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria |
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);;