RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJNA889065" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA889065 · 20 ✖

analysis 1

  • blastn · 20 ✖
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
863348 863348 PRJNA889065_S_NODE_21521_length_210_cov_1.377246_g21283_i0 PRJNA889065 21521 210 1.377246 2.8922166 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.018   NTclustered gi|2912992646|dbj|AP039597.1| 145626 g21283 i0 100 0.133333333333333 28 0 13 0 107 134 36324034 36324007 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
863363 863363 PRJNA889065_S_NODE_23661_length_200_cov_1.464968_g23423_i0 PRJNA889065 23661 200 1.464968 2.929936 Anadara broughtonii 148819 Mollusca Mollusca 52.8 0.017   NTclustered gi|2170965484|dbj|LC593126.1| 148819 g23423 i0 100 0.14 28 0 14 0 1 28 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
2517772 2517772 PRJNA889065_S_NODE_25962_length_190_cov_4.476190_g25724_i0 PRJNA889065 25962 190 4.47619 8.504761 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 58.4 3.51e-4   NTclustered gi|2912987826|dbj|AP039592.1| 145626 g25724 i0 100 5.68421052631579 31 0 16 0 111 141 28635091 28635061 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence blastn 1080 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
2517776 2517776 PRJNA889065_S_NODE_28062_length_183_cov_0.985714_g27824_i0 PRJNA889065 28062 183 0.985714 1.80385662 root 1 Root_unresolved Root_unresolved 54.7 0.004   NTclustered gi|2170965484|dbj|LC593126.1| 148819 g27824 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
4691717 4691717 PRJNA889065_S_NODE_17604_length_232_cov_1.396825_g17366_i0 PRJNA889065 17604 232 1.396825 3.240634 Bradybaena similaris 145626 Mollusca Mollusca 108 4.37e-19   NTclustered gi|2912993551|dbj|AP039598.1| 145626 g17366 i0 76.961 0.879310344827586 204 37 85 9 7 203 11800561 11800361 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence blastn 204 108 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
5966663 5966663 PRJNA889065_S_NODE_29405_length_178_cov_1.362963_g29167_i0 PRJNA889065 29405 178 1.362963 2.42607414 Physella acuta 109671 Mollusca Mollusca 134 5.23e-27   NTclustered gi|2572397869|ref|XM_059316507.1| 109671 g29167 i0 81.065 9.03370786516854 169 30 94 2 9 176 2066 1899 PREDICTED: Physella acuta ATP-dependent RNA helicase DHX8-like (LOC131953352), mRNA blastn 1608 134 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
7241473 7241473 PRJNA889065_S_NODE_24706_length_195_cov_2.842105_g24468_i0 PRJNA889065 24706 195 2.842105 5.54210475 Bradybaena similaris 145626 Mollusca Mollusca 56.5 0.001   NTclustered gi|2912984370|dbj|AP039589.1| 145626 g24468 i0 100 0.153846153846154 30 0 15 0 129 158 22176582 22176553 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
8516276 8516276 PRJNA889065_S_NODE_32307_length_169_cov_1.404762_g32069_i0 PRJNA889065 32307 169 1.404762 2.37404778 Bradybaena similaris 145626 Mollusca Mollusca 71.3 3.9e-8   NTclustered gi|2912995509|dbj|AP039600.1| 145626 g32069 i0 95.455 0.72189349112426 44 2 33 0 114 157 14470258 14470301 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence blastn 122 71.3 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
10170771 10170771 PRJNA889065_S_NODE_3548_length_480_cov_77.608696_g3319_i0 PRJNA889065 3548 480 77.608696 372.5217408 root 1 Root_unresolved Root_unresolved 54.7 0.013   NTclustered gi|2170965484|dbj|LC593126.1| 148819 g3319 i0 100 0.2375 29 0 6 0 1 29 29 57 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
11066915 11066915 PRJNA889065_S_NODE_35149_length_161_cov_1.559322_g34911_i0 PRJNA889065 35149 161 1.559322 2.51050842 Mytilus trossulus 6551 Mollusca Mollusca 52.8 0.013   NTclustered gi|2694124346|ref|XM_063539854.1| 6551 g34911 i0 100 0.347826086956522 28 0 17 0 130 157 1635 1608 PREDICTED: Mytilus trossulus uncharacterized LOC134680694 (LOC134680694), transcript variant X1, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus trossulus
13617044 13617044 PRJNA889065_S_NODE_2931_length_515_cov_66.466102_g2707_i0 PRJNA889065 2931 515 66.466102 342.3004253 Idiosepius paradoxus 294707 Mollusca Mollusca 54.7 0.014   NTclustered gi|325504932|dbj|AB586703.1| 294707 g2707 i0 96.875 0.0621359223300971 32 1 6 0 484 515 39 8 Idiosepius paradoxus cenG mRNA for centaurin gamma homolog, complete cds blastn 32 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda   Idiosepiidae Idiosepius Idiosepius paradoxus
16166160 16166160 PRJNA889065_S_NODE_8373_length_329_cov_2.444056_g8135_i0 PRJNA889065 8373 329 2.444056 8.04094424 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.031   NTclustered gi|2912984370|dbj|AP039589.1| 145626 g8135 i0 100 0.0851063829787234 28 0 9 0 143 170 19741449 19741422 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
17441548 17441548 PRJNA889065_S_NODE_23134_length_202_cov_2.176101_g22896_i0 PRJNA889065 23134 202 2.176101 4.39572402 Anadara broughtonii 148819 Mollusca Mollusca 56.5 0.001   NTclustered gi|2170965484|dbj|LC593126.1| 148819 g22896 i0 100 0.569306930693069 30 0 15 0 173 202 58 29 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
17441569 17441569 PRJNA889065_S_NODE_27274_length_185_cov_3.077465_g27036_i0 PRJNA889065 27274 185 3.077465 5.69331025 Bradybaena similaris 145626 Mollusca Mollusca 56.5 0.001   NTclustered gi|2912999747|dbj|AP039606.1| 145626 g27036 i0 100 1.25405405405405 30 0 16 0 1 30 54991156 54991185 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence blastn 232 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
18714729 18714729 PRJNA889065_S_NODE_27335_length_185_cov_2.267606_g27097_i0 PRJNA889065 27335 185 2.267606 4.1950711 Bradybaena similaris 145626 Mollusca Mollusca 60.2 9.44e-5   NTclustered gi|2912995509|dbj|AP039600.1| 145626 g27097 i0 91.304 0.497297297297297 46 1 23 3 70 112 25722114 25722069 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence blastn 92 60.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
21265344 21265344 PRJNA889065_S_NODE_30817_length_173_cov_2.123077_g30579_i0 PRJNA889065 30817 173 2.123077 3.67292321 Bradybaena similaris 145626 Mollusca Mollusca 56.5 0.001   NTclustered gi|2912985489|dbj|AP039590.1| 145626 g30579 i0 100 0.341040462427746 30 0 17 0 134 163 49670064 49670035 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 9, sequence blastn 59 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
21265367 21265367 PRJNA889065_S_NODE_377_length_1043_cov_49.839000_g309_i0 PRJNA889065 377 1043 49.839 519.82077 Mytilus californianus 6549 Mollusca Mollusca 616 2.989999999999999e-171   NTclustered gi|2334668042|ref|XM_052234512.1| 6549 g309 i0 78.801 89.2176414189837 934 185 89 11 7 934 285 1211 PREDICTED: Mytilus californianus actin-2 (LOC127727100), mRNA blastn 93054 616 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus californianus
21644405 21644405 PRJNA889065_S_NODE_7657_length_343_cov_1.473333_g7419_i0 PRJNA889065 7657 343 1.473333 5.05353219 root 1 Root_unresolved Root_unresolved 54.7 0.009   NTclustered gi|2170965484|dbj|LC593126.1| 148819 g7419 i0 100 0.332361516034985 29 0 8 0 1 29 29 57 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
22919755 22919755 PRJNA889065_S_NODE_1078_length_747_cov_5.080966_g931_i0 PRJNA889065 1078 747 5.080966 37.95481602 root 1 Root_unresolved Root_unresolved 54.7 0.021   NTclustered gi|2170965484|dbj|LC593126.1| 148819 g931 i0 100 0.0776439089692102 29 0 4 0 719 747 57 29 Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Arcoida Arcidae Anadara Anadara broughtonii
25089463 25089463 PRJNA889065_S_NODE_39800_length_150_cov_1.719626_g39562_i0 PRJNA889065 39800 150 1.719626 2.579439 Saccostrea echinata 191078 Mollusca Mollusca 58.4 2.63e-4   NTclustered gi|2628378382|ref|XM_061339954.1| 191078 g39562 i0 94.595 0.246666666666667 37 2 25 0 93 129 1048 1012 PREDICTED: Saccostrea echinata cilia- and flagella-associated protein 251-like (LOC133204205), mRNA blastn 37 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Saccostrea Saccostrea echinata

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;