RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1101946" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1101946 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
211282 211282 PRJNA1101946_S_NODE_4741_length_315_cov_2.883459_g4642_i0 PRJNA1101946 4741 315 2.883459 9.08289585 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.008   NTclustered gi|2912981848|dbj|AP039587.1| 145626 g4642 i0 96.97 0.104761904761905 33 0 10 1 242 273 24009057 24009089 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence blastn 33 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
4038031 4038031 PRJNA1101946_S_NODE_8464_length_263_cov_5.761682_g8365_i0 PRJNA1101946 8464 263 5.761682 15.15322366 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.024   NTclustered gi|2912997258|dbj|AP039602.1| 145626 g8365 i0 100 0.106463878326996 28 0 11 0 202 229 53560199 53560172 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
11689969 11689969 PRJNA1101946_S_NODE_27030_length_154_cov_4.161905_g26931_i0 PRJNA1101946 27030 154 4.161905 6.4093337 Bradybaena similaris 145626 Mollusca Mollusca 60.2 7.55e-5   NTclustered gi|2912997258|dbj|AP039602.1| 145626 g26931 i0 100 45.5454545454545 32 0 22 0 123 154 5941177 5941208 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence blastn 7014 60.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
23972178 23972178 PRJNA1101946_S_NODE_20919_length_176_cov_2.811024_g20820_i0 PRJNA1101946 20919 176 2.811024 4.94740224 root 1 Root_unresolved Root_unresolved 54.7 0.004   NTclustered gi|2170965484|dbj|LC593126.1| 148819 g20820 i0 100 0.647727272727273 29 0 16 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

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