RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA674048 · 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
3193924 3193924 PRJNA674048_P_NODE_13583_length_245_cov_3.142857_g13380_i0 PRJNA674048 13583 245 3.142857 7.69999965 Adineta vaga complex sp. B JFF-2016 1813165 Rotifera other_Eukaryota 442 1.1199999999999994e-119   NTclustered gi|1005055631|gb|KU860774.1| 1813165 g13380 i0 99.184 26.334693877551 245 2 100 0 1 245 1447 1691 Adineta vaga complex sp. B JFF-2016 isolate H158a 28S ribosomal RNA gene, partial sequence blastn 6452 442 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta vaga complex sp. B JFF-2016
12645264 12645264 PRJNA674048_P_NODE_21530_length_189_cov_3.385714_g21327_i0 PRJNA674048 21530 189 3.385714 6.39899946 Eurotatoria 2816136 Rotifera other_Eukaryota 344 2.39e-90   NTclustered gi|1399047|gb|U41281.1|PAU41281 44582 g21327 i0 99.471 100.116402116402 189 1 100 0 1 189 170 358 Philodina acuticornis 18S rRNA gene blastn 18922 344 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Philodina Philodina acuticornis
17221137 17221137 PRJNA674048_P_NODE_24534_length_177_cov_2.312500_g24331_i0 PRJNA674048 24534 177 2.3125 4.093125 Adineta vaga 104782 Rotifera other_Eukaryota 300 4.84e-77   NTclustered gi|259129963|gb|GQ398061.1| 104782 g24331 i0 97.175 3.12994350282486 177 5 100 0 1 177 10205 10381 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 554 300 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);;