RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA340009" and tax_phylum = "Rotifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rotifera · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA340009 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
9320439 9320439 PRJNA340009_P_NODE_61688_length_167_cov_1.618644_g61381_i0 PRJNA340009 61688 167 1.618644 2.70313548 Asplanchna sieboldii 84397 Rotifera other_Eukaryota 222 1.01e-53   NTclustered gi|61200811|gb|AY829085.1| 84397 g61381 i0 93.878 47.9101796407186 147 9 88 0 11 157 1908 2054 Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence blastn 8001 222 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Asplanchnidae Asplanchna Asplanchna sieboldii
14421288 14421288 PRJNA340009_P_NODE_71832_length_163_cov_0.894737_g71525_i0 PRJNA340009 71832 163 0.894737 1.45842131 Adineta vaga 104782 Rotifera other_Eukaryota 278 2.06e-70   NTclustered gi|259129963|gb|GQ398061.1| 104782 g71525 i0 99.346 79.8159509202454 153 1 94 0 1 153 6810 6962 Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 13010 278 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta vaga
18243565 18243565 PRJNA340009_P_NODE_22275_length_258_cov_1.449761_g21968_i0 PRJNA340009 22275 258 1.449761 3.74038338 Keratella quadrata 204742 Rotifera other_Eukaryota 388 1.58e-103   NTclustered gi|83285188|gb|DQ297735.1| 204742 g21968 i0 94.779 5.81782945736434 249 13 97 0 10 258 476 724 Keratella quadrata 28S ribosomal RNA gene, partial sequence blastn 1501 388 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Brachionidae Keratella Keratella quadrata

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