RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA801875" 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

  • PRJNA801875 · 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
18652540 18652540 PRJNA801875_P_NODE_2475_length_219_cov_2.076087_g2372_i0 PRJNA801875 2475 219 2.076087 4.54663053 Lepadella patella 231622 Rotifera other_Eukaryota 309 1.04e-79   NTclustered gi|83285192|gb|DQ297739.1| 231622 g2372 i0 92.558 82.7260273972603 215 16 98 0 4 218 6 220 Lepadella patella 28S ribosomal RNA gene, partial sequence blastn 18117 309 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Lepadellidae Lepadella Lepadella patella
22478113 22478113 PRJNA801875_P_NODE_2698_length_206_cov_2.555556_g2595_i0 PRJNA801875 2698 206 2.555556 5.26444536 Encentrum astridae 360661 Rotifera other_Eukaryota 167 6.159999999999999e-37   NTclustered gi|124388846|gb|EF151006.1| 360661 g2595 i0 93.043 24.3009708737864 115 6 55 2 88 201 1907 1794 Encentrum astridae 28S ribosomal RNA gene, partial sequence blastn 5006 167 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Dicranophoridae Encentrum Encentrum astridae
23753763 23753763 PRJNA801875_P_NODE_4259_length_158_cov_2.926829_g4156_i0 PRJNA801875 4259 158 2.926829 4.62438982 Adineta vaga 104782 Rotifera other_Eukaryota 270 3.3099999999999996e-68   NTclustered gi|259129963|gb|GQ398061.1| 104782 g4156 i0 97.468 3.00632911392405 158 4 100 0 1 158 10369 10212 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 475 270 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta vaga

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