RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA774958" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA774958 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
752510 752510 PRJNA774958_P_NODE_13481_length_443_cov_98.286486_g13234_i0 PRJNA774958 13481 443 98.286486 435.40913298 Haliotis asinina 109174 Mollusca Mollusca 209 2.4e-49   NTclustered gi|2793421121|ref|XM_067823659.1| 109174 g13234 i0 80.515 7.73814898419865 272 53 61 0 111 382 332 61 PREDICTED: Haliotis asinina histone H2A-like (LOC137292118), mRNA blastn 3428 209 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis asinina
5856194 5856194 PRJNA774958_P_NODE_25665_length_304_cov_2.653680_g25418_i0 PRJNA774958 25665 304 2.65368 8.0671872 Octopus bimaculoides 37653 Mollusca Mollusca 75 6.05e-9   NTclustered gi|2427275966|ref|XM_014916214.2| 37653 g25418 i0 94 0.164473684210526 50 1 16 2 151 199 198 246 PREDICTED: Octopus bimaculoides U6 snRNA-associated Sm-like protein LSm3 (LOC106870208), mRNA blastn 50 75 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus bimaculoides
5856281 5856281 PRJNA774958_P_NODE_32805_length_253_cov_1.400000_g32558_i0 PRJNA774958 32805 253 1.4 3.542 Lottia gigantea 225164 Mollusca Mollusca 226 1.2799999999999999e-54   NTclustered gi|676445935|ref|XM_009052667.1| 225164 g32558 i0 85.135 62.6758893280632 222 32 88 1 2 223 1821 2041 Lottia gigantea hypothetical protein mRNA blastn 15857 226 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
8405882 8405882 PRJNA774958_P_NODE_35967_length_246_cov_1.335260_g35720_i0 PRJNA774958 35967 246 1.33526 3.2847396 Crassostrea virginica 6565 Mollusca Mollusca 56.5 0.002   NTclustered gi|1242838289|ref|XM_022444580.1| 6565 g35720 i0 100 1.53658536585366 30 0 12 0 134 163 863 892 PREDICTED: Crassostrea virginica uncharacterized LOC111108597 (LOC111108597), mRNA blastn 378 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Crassostrea Crassostrea virginica
17331013 17331013 PRJNA774958_P_NODE_36014_length_246_cov_0.982659_g35767_i0 PRJNA774958 36014 246 0.982659 2.41734114 Mercenaria mercenaria 6596 Mollusca Mollusca 52.8 0.022   NTclustered gi|2442006050|ref|XM_045353140.2| 6596 g35767 i0 100 0.227642276422764 28 0 11 0 168 195 1522 1495 PREDICTED: Mercenaria mercenaria plasminogen-like (LOC123560988), mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Veneridae Mercenaria Mercenaria mercenaria
19879324 19879324 PRJNA774958_P_NODE_14096_length_434_cov_0.914127_g13849_i0 PRJNA774958 14096 434 0.914127 3.96731118 Lottia gigantea 225164 Mollusca Mollusca 219 3.9e-52   NTclustered gi|676472934|ref|XM_009061404.1| 225164 g13849 i0 79.141 3.40092165898618 326 60 75 5 110 434 795 477 Lottia gigantea hypothetical protein partial mRNA blastn 1476 219 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
21155364 21155364 PRJNA774958_P_NODE_37377_length_244_cov_0.900585_g37130_i0 PRJNA774958 37377 244 0.900585 2.1974274 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.022   NTclustered gi|2912991694|dbj|AP039596.1| 145626 g37130 i0 100 0.114754098360656 28 0 11 0 132 159 68578496 68578523 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris

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