RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA752572" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA752572 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
2004597 2004597 PRJNA752572_P_NODE_100102_length_270_cov_1.774468_g99595_i0 PRJNA752572 100102 270 1.774468 4.7910636 Mya arenaria 6604 Mollusca Mollusca 324 4.75e-84   NTclustered gi|2427436396|ref|XM_052934117.1| 6604 g99595 i0 88.476 98.0814814814815 269 29 99 2 1 268 594 861 PREDICTED: Mya arenaria actin, adductor muscle-like (LOC128224306), mRNA blastn 26482 324 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
4557014 4557014 PRJNA752572_P_NODE_244344_length_170_cov_1.481481_g243837_i0 PRJNA752572 244344 170 1.481481 2.5185177 Haliotis rubra 36100 Mollusca Mollusca 78.7 2.35e-10   NTclustered gi|2194101406|ref|XM_046706881.1| 36100 g243837 i0 89.231 0.776470588235294 65 3 39 4 59 121 111 173 PREDICTED: Haliotis rubra transcription initiation factor TFIID subunit 11-like (LOC124271720), partial mRNA blastn 132 78.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rubra
10932592 10932592 PRJNA752572_P_NODE_193409_length_191_cov_3.128205_g192902_i0 PRJNA752572 193409 191 3.128205 5.97487155 Biomphalaria glabrata 6526 Mollusca Mollusca 148 2.04e-31   NTclustered gi|2502141946|ref|XM_013238701.2| 6526 g192902 i0 89.076 44.4921465968586 119 13 62 0 4 122 590 472 PREDICTED: Biomphalaria glabrata ras-related protein rab-11.1-like (LOC106077987), mRNA blastn 8498 148 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Planorbidae Biomphalaria Biomphalaria glabrata
13955336 13955336 PRJNA752572_P_NODE_107871_length_259_cov_16.535714_g107364_i0 PRJNA752572 107871 259 16.535714 42.82749926 root 1 Root_unresolved Root_unresolved 54.7 0.007   NTclustered gi|2170965484|dbj|LC593126.1| 148819 g107364 i0 100 0.44015444015444 29 0 11 0 231 259 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
16031177 16031177 PRJNA752572_P_NODE_180033_length_199_cov_1.213415_g179526_i0 PRJNA752572 180033 199 1.213415 2.41469585 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.005   NTclustered gi|2912991694|dbj|AP039596.1| 145626 g179526 i0 100 0.14572864321608 29 0 15 0 72 100 3305221 3305193 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
19855685 19855685 PRJNA752572_P_NODE_216836_length_180_cov_1.710345_g216329_i0 PRJNA752572 216836 180 1.710345 3.078621 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.004   NTclustered gi|2912997258|dbj|AP039602.1| 145626 g216329 i0 100 0.161111111111111 29 0 16 0 12 40 34723407 34723435 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence blastn 29 54.7 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);;