contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA924320" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1252173 | 1252173 | PRJNA924320_S_NODE_27921_length_204_cov_2.180645_g27779_i0 | PRJNA924320 | 27921 | 204 | 2.180645 | 4.4485158 | Metazoa | 33208 | Mollusca | Mollusca | 377 | 2.59e-100 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g27779 | i0 | 100 | 100 | 204 | 0 | 100 | 0 | 1 | 204 | 1287 | 1084 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 20400 | 377 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 3804234 | 3804234 | PRJNA924320_S_NODE_38083_length_181_cov_1.159091_g37941_i0 | PRJNA924320 | 38083 | 181 | 1.159091 | 2.09795471 | Metazoa | 33208 | Mollusca | Mollusca | 165 | 1.89e-36 | NTclustered | gi|676453046|ref|XM_009054981.1| | 225164 | g37941 | i0 | 89.844 | 27.060773480663 | 128 | 13 | 71 | 0 | 7 | 134 | 251 | 124 | Lottia gigantea hypothetical protein mRNA | blastn | 4898 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 6002592 | 6002592 | PRJNA924320_S_NODE_9865_length_312_cov_1.479087_g9723_i0 | PRJNA924320 | 9865 | 312 | 1.479087 | 4.61475144 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.029 | NTclustered | gi|2912983111|dbj|AP039588.1| | 145626 | g9723 | i0 | 94.286 | 0.112179487179487 | 35 | 1 | 11 | 1 | 1 | 34 | 19213725 | 19213691 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence | blastn | 35 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 8552327 | 8552327 | PRJNA924320_S_NODE_52367_length_164_cov_0.886957_g52225_i0 | PRJNA924320 | 52367 | 164 | 0.886957 | 1.45460948 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 62.1 | 2.27e-5 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g52225 | i0 | 95 | 4.21951219512195 | 40 | 0 | 23 | 2 | 107 | 144 | 23997909 | 23997870 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 692 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 12378188 | 12378188 | PRJNA924320_S_NODE_20810_length_228_cov_1.424581_g20668_i0 | PRJNA924320 | 20810 | 228 | 1.424581 | 3.24804468 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2913001038|dbj|AP039608.1| | 145626 | g20668 | i0 | 100 | 0.12719298245614 | 29 | 0 | 13 | 0 | 106 | 134 | 9147465 | 9147493 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 12378380 | 12378380 | PRJNA924320_S_NODE_42190_length_173_cov_1.637097_g42048_i0 | PRJNA924320 | 42190 | 173 | 1.637097 | 2.83217781 | Mya arenaria | 6604 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2427417697|ref|XM_052927014.1| | 6604 | g42048 | i0 | 100 | 0.173410404624277 | 30 | 0 | 17 | 0 | 106 | 135 | 1659 | 1688 | PREDICTED: Mya arenaria DNA-directed RNA polymerase II subunit RPB1-like (LOC128219202), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 12378526 | 12378526 | PRJNA924320_S_NODE_58050_length_160_cov_5.342342_g57908_i0 | PRJNA924320 | 58050 | 160 | 5.342342 | 8.5477472 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 54.7 | 0.004 | NTclustered | gi|2034283022|ref|XM_041515763.1| | 1735272 | g57908 | i0 | 96.875 | 0.725 | 32 | 1 | 20 | 0 | 129 | 160 | 1747 | 1778 | PREDICTED: Gigantopelta aegis uncharacterized LOC121385196 (LOC121385196), mRNA | blastn | 116 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 18750678 | 18750678 | PRJNA924320_S_NODE_16295_length_251_cov_3.282178_g16153_i0 | PRJNA924320 | 16295 | 251 | 3.282178 | 8.23826678 | Patella vulgata | 6465 | Mollusca | Mollusca | 213 | 9.86e-51 | NTclustered | gi|2296443952|ref|XM_050562746.1| | 6465 | g16153 | i0 | 82 | 71.2709163346614 | 250 | 45 | 99 | 0 | 1 | 250 | 304 | 55 | PREDICTED: Patella vulgata tubulin beta chain-like (LOC126832052), mRNA | blastn | 17889 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 18750815 | 18750815 | PRJNA924320_S_NODE_33475_length_190_cov_41.531915_g33333_i0 | PRJNA924320 | 33475 | 190 | 41.531915 | 78.9106385 | Mya arenaria | 6604 | Mollusca | Mollusca | 193 | 9.22e-45 | NTclustered | gi|2427407524|ref|XM_052923669.1| | 6604 | g33333 | i0 | 86.034 | 88.2736842105263 | 179 | 25 | 94 | 0 | 5 | 183 | 155 | 333 | PREDICTED: Mya arenaria tubulin alpha-1A chain-like (LOC128216942), mRNA | blastn | 16772 | 193 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 21301386 | 21301386 | PRJNA924320_S_NODE_52337_length_164_cov_0.886957_g52195_i0 | PRJNA924320 | 52337 | 164 | 0.886957 | 1.45460948 | Liolophura japonica | 13599 | Mollusca | Mollusca | 78.7 | 2.26e-10 | NTclustered | gi|2724233349|ref|XM_064741741.1| | 13599 | g52195 | i0 | 78.947 | 5.35365853658537 | 114 | 24 | 70 | 0 | 24 | 137 | 806 | 693 | PREDICTED: Liolophura japonica mitogen-activated protein kinase 1-like (LOC135464236), mRNA | blastn | 878 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 23851704 | 23851704 | PRJNA924320_S_NODE_8439_length_334_cov_1.950877_g8297_i0 | PRJNA924320 | 8439 | 334 | 1.950877 | 6.51592918 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 115 | 3.96e-21 | NTclustered | gi|2868639095|ref|XM_070351151.1| | 31220 | g8297 | i0 | 83.077 | 17.6047904191617 | 130 | 18 | 38 | 4 | 176 | 303 | 1101 | 1228 | PREDICTED: Littorina saxatilis enolase-like (LOC138978413), transcript variant X1, mRNA | blastn | 5880 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 24203767 | 24203767 | PRJNA924320_S_NODE_46579_length_167_cov_0.864407_g46437_i0 | PRJNA924320 | 46579 | 167 | 0.864407 | 1.44355969 | Metazoa | 33208 | Mollusca | Mollusca | 54.7 | 0.004 | NTclustered | gi|871260641|ref|XM_005107622.2| | 6500 | g46437 | i0 | 100 | 3.06586826347305 | 29 | 0 | 17 | 0 | 32 | 60 | 1349 | 1321 | PREDICTED: Aplysia californica protein sine oculis (LOC101864327), mRNA | blastn | 512 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 25125186 | 25125186 | PRJNA924320_S_NODE_26260_length_209_cov_1.700000_g26118_i0 | PRJNA924320 | 26260 | 209 | 1.7 | 3.553 | Mytilus californianus | 6549 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2334608986|ref|XM_052206883.1| | 6549 | g26118 | i0 | 94.444 | 0.172248803827751 | 36 | 2 | 17 | 0 | 96 | 131 | 2645 | 2610 | PREDICTED: Mytilus californianus RING finger protein 11-like (LOC127702581), mRNA | blastn | 36 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 25478757 | 25478757 | PRJNA924320_S_NODE_1460_length_745_cov_1.913793_g1353_i0 | PRJNA924320 | 1460 | 745 | 1.913793 | 14.25775785 | Metazoa | 33208 | Mollusca | Mollusca | 56.5 | 0.006 | NTclustered | gi|2245666867|ref|XM_046470698.2| | 6454 | g1353 | i0 | 100 | 0.216107382550336 | 30 | 0 | 4 | 0 | 624 | 653 | 170 | 199 | PREDICTED: Haliotis rufescens PITH domain-containing protein 1-like (LOC124111107), mRNA | blastn | 161 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens |
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);;