contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA975724" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 945365 | 945365 | PRJNA975724_S_NODE_10581_length_445_cov_3.884409_g10400_i0 | PRJNA975724 | 10581 | 445 | 3.884409 | 17.28562005 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 69.4 | 4.28e-7 | NTclustered | gi|2912983111|dbj|AP039588.1| | 145626 | g10400 | i0 | 95.455 | 1.1438202247191 | 44 | 1 | 10 | 1 | 301 | 343 | 40479944 | 40479987 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence | blastn | 509 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 945710 | 945710 | PRJNA975724_S_NODE_24661_length_367_cov_1.571429_g24480_i0 | PRJNA975724 | 24661 | 367 | 1.571429 | 5.76714443 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 65.8 | 4.48e-6 | NTclustered | gi|1397691689|ref|XM_025239392.1| | 400727 | g24480 | i0 | 97.368 | 2.01634877384196 | 38 | 1 | 10 | 0 | 224 | 261 | 944 | 907 | PREDICTED: Pomacea canaliculata negative elongation factor A-like (LOC112564527), mRNA | blastn | 740 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 947509 | 947509 | PRJNA975724_S_NODE_91281_length_241_cov_0.916667_g91100_i0 | PRJNA975724 | 91281 | 241 | 0.916667 | 2.20916747 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g91100 | i0 | 100 | 0.477178423236515 | 30 | 0 | 12 | 0 | 1 | 30 | 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 | |
| 3496252 | 3496252 | PRJNA975724_S_NODE_20443_length_384_cov_5.398714_g20262_i0 | PRJNA975724 | 20443 | 384 | 5.398714 | 20.73106176 | Pecten maximus | 6579 | Mollusca | Mollusca | 54.7 | 0.01 | NTclustered | gi|1835477357|ref|XM_033870308.1| | 6579 | g20262 | i0 | 100 | 0.520833333333333 | 29 | 0 | 8 | 0 | 256 | 284 | 212 | 184 | PREDICTED: Pecten maximus RNA-binding protein 25-like (LOC117315893), mRNA | blastn | 200 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 4775331 | 4775331 | PRJNA975724_S_NODE_75544_length_255_cov_1.131868_g75363_i0 | PRJNA975724 | 75544 | 255 | 1.131868 | 2.8862634 | Sinonovacula constricta | 98310 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|937961735|gb|KR534869.1| | 98310 | g75363 | i0 | 100 | 0.109803921568627 | 28 | 0 | 11 | 0 | 228 | 255 | 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 | |
| 4775590 | 4775590 | PRJNA975724_S_NODE_84584_length_246_cov_1.335260_g84403_i0 | PRJNA975724 | 84584 | 246 | 1.33526 | 3.2847396 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 69.4 | 2.21e-7 | NTclustered | gi|2592059344|ref|XM_060209046.1| | 509963 | g84403 | i0 | 91.837 | 0.394308943089431 | 49 | 4 | 20 | 0 | 196 | 244 | 367 | 319 | PREDICTED: Ylistrum balloti dynein light chain 2, cytoplasmic (LOC132545366), mRNA | blastn | 97 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 6049948 | 6049948 | PRJNA975724_S_NODE_63405_length_273_cov_1.400000_g63224_i0 | PRJNA975724 | 63405 | 273 | 1.4 | 3.822 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.025 | NTclustered | gi|2912981848|dbj|AP039587.1| | 145626 | g63224 | i0 | 100 | 0.102564102564103 | 28 | 0 | 10 | 0 | 170 | 197 | 65128267 | 65128240 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 7323611 | 7323611 | PRJNA975724_S_NODE_22426_length_375_cov_5.016556_g22245_i0 | PRJNA975724 | 22426 | 375 | 5.016556 | 18.812085 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 52.8 | 0.036 | NTclustered | gi|2442044715|ref|XM_045303535.2| | 6596 | g22245 | i0 | 100 | 0.522666666666667 | 28 | 0 | 7 | 0 | 24 | 51 | 7634 | 7661 | PREDICTED: Mercenaria mercenaria glucose dehydrogenase [FAD, quinone]-like (LOC123524919), transcript variant X2, mRNA | blastn | 196 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 7324438 | 7324438 | PRJNA975724_S_NODE_55406_length_287_cov_1.341121_g55225_i0 | PRJNA975724 | 55406 | 287 | 1.341121 | 3.84901727 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 87.9 | 7.27e-13 | NTclustered | gi|2912998015|dbj|AP039603.1| | 145626 | g55225 | i0 | 94.643 | 10.0627177700348 | 56 | 3 | 20 | 0 | 226 | 281 | 19826872 | 19826927 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 22, sequence | blastn | 2888 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 8598385 | 8598385 | PRJNA975724_S_NODE_13907_length_420_cov_1.296830_g13726_i0 | PRJNA975724 | 13907 | 420 | 1.29683 | 5.446686 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 58.4 | 8.69e-4 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g13726 | i0 | 100 | 0.276190476190476 | 31 | 0 | 7 | 0 | 390 | 420 | 59 | 29 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 116 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 10195407 | 10195407 | PRJNA975724_S_NODE_19008_length_391_cov_2.654088_g18827_i0 | PRJNA975724 | 19008 | 391 | 2.654088 | 10.37748408 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.01 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g18827 | i0 | 100 | 0.29156010230179 | 29 | 0 | 7 | 0 | 363 | 391 | 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 | |
| 11149813 | 11149813 | PRJNA975724_S_NODE_44249_length_310_cov_0.869198_g44068_i0 | PRJNA975724 | 44249 | 310 | 0.869198 | 2.6945138 | Sinonovacula constricta | 98310 | Mollusca | Mollusca | 52.8 | 0.029 | NTclustered | gi|937961735|gb|KR534869.1| | 98310 | g44068 | i0 | 100 | 0.0903225806451613 | 28 | 0 | 9 | 0 | 11 | 38 | 1 | 28 | Sinonovacula constricta insulin-like peptide 1 mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Solecurtidae | Sinonovacula | Sinonovacula constricta | |
| 12425569 | 12425569 | PRJNA975724_S_NODE_50370_length_296_cov_2.910314_g50189_i0 | PRJNA975724 | 50370 | 296 | 2.910314 | 8.61452944 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 54.7 | 0.008 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g50189 | i0 | 100 | 0.192567567567568 | 29 | 0 | 10 | 0 | 1 | 29 | 30 | 58 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 57 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 13699302 | 13699302 | PRJNA975724_S_NODE_20971_length_382_cov_2.058252_g20790_i0 | PRJNA975724 | 20971 | 382 | 2.058252 | 7.86252264 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.01 | NTclustered | gi|2912998575|dbj|AP039604.1| | 145626 | g20790 | i0 | 100 | 0.0759162303664921 | 29 | 0 | 8 | 0 | 174 | 202 | 4800878 | 4800850 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 16569335 | 16569335 | PRJNA975724_S_NODE_66173_length_268_cov_2.789744_g65992_i0 | PRJNA975724 | 66173 | 268 | 2.789744 | 7.47651392 | Magallana | 147004 | Mollusca | Mollusca | 67.6 | 8.76e-7 | NTclustered | gi|2751314142|ref|XM_011439070.4| | 29159 | g65992 | i0 | 93.333 | 0.466417910447761 | 45 | 3 | 17 | 0 | 169 | 213 | 499 | 455 | PREDICTED: Magallana gigas U4/U6.U5 small nuclear ribonucleoprotein 27 kDa protein (LOC105335261), mRNA | blastn | 125 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 20072613 | 20072613 | PRJNA975724_S_NODE_34556_length_334_cov_1.475096_g34375_i0 | PRJNA975724 | 34556 | 334 | 1.475096 | 4.92682064 | Pecten maximus | 6579 | Mollusca | Mollusca | 52.8 | 0.031 | NTclustered | gi|1835482055|ref|XM_033898399.1| | 6579 | g34375 | i0 | 100 | 0.335329341317365 | 28 | 0 | 8 | 0 | 1 | 28 | 1578 | 1605 | PREDICTED: Pecten maximus uncharacterized LOC117337419 (LOC117337419), transcript variant X2, mRNA | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 23897898 | 23897898 | PRJNA975724_S_NODE_14259_length_417_cov_6.802326_g14078_i0 | PRJNA975724 | 14259 | 417 | 6.802326 | 28.36569942 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 63.9 | 1.85e-5 | NTclustered | gi|2616566078|ref|XM_060716489.1| | 129788 | g14078 | i0 | 95 | 0.0959232613908873 | 40 | 2 | 10 | 0 | 331 | 370 | 566 | 527 | PREDICTED: Ruditapes philippinarum uncharacterized LOC132730535 (LOC132730535), mRNA | blastn | 40 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 23898226 | 23898226 | PRJNA975724_S_NODE_26859_length_359_cov_1.076923_g26678_i0 | PRJNA975724 | 26859 | 359 | 1.076923 | 3.86615357 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 80.5 | 1.56e-10 | NTclustered | gi|1207980031|ref|XM_021483861.1| | 6573 | g26678 | i0 | 94.34 | 0.147632311977716 | 53 | 1 | 14 | 2 | 2 | 53 | 558 | 609 | PREDICTED: Mizuhopecten yessoensis 40S ribosomal protein S5 (LOC110440710), mRNA | blastn | 53 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 23899163 | 23899163 | PRJNA975724_S_NODE_62619_length_274_cov_1.860697_g62438_i0 | PRJNA975724 | 62619 | 274 | 1.860697 | 5.09830978 | Idiosepius paradoxus | 294707 | Mollusca | Mollusca | 58.4 | 5.41e-4 | NTclustered | gi|325504932|dbj|AB586703.1| | 294707 | g62438 | i0 | 100 | 0.740875912408759 | 31 | 0 | 11 | 0 | 244 | 274 | 38 | 8 | Idiosepius paradoxus cenG mRNA for centaurin gamma homolog, complete cds | blastn | 203 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Idiosepiidae | Idiosepius | Idiosepius paradoxus | ||
| 25171528 | 25171528 | PRJNA975724_S_NODE_13140_length_425_cov_2.747159_g12959_i0 | PRJNA975724 | 13140 | 425 | 2.747159 | 11.67542575 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 69.4 | 4.07e-7 | NTclustered | gi|2912998015|dbj|AP039603.1| | 145626 | g12959 | i0 | 95.455 | 7.72235294117647 | 44 | 1 | 10 | 1 | 382 | 425 | 22407037 | 22407079 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 22, sequence | blastn | 3282 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris |
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);;