RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA734348 · 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
1197448 1197448 PRJNA734348_P_NODE_76881_length_263_cov_2.057895_g76183_i0 PRJNA734348 76881 263 2.057895 5.41226385 Adineta 104781 Rotifera other_Eukaryota 420 5.71e-113   NTclustered gi|1005055598|gb|KU860741.1| 1813167 g76183 i0 95.455 92.0304182509506 264 11 100 1 1 263 145 408 Adineta vaga complex sp. D JFF-2016 isolate H3-14b 28S ribosomal RNA gene, partial sequence blastn 24204 420 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta vaga complex sp. D JFF-2016
8372106 8372106 PRJNA734348_P_NODE_74347_length_265_cov_3.015625_g73649_i0 PRJNA734348 74347 265 3.015625 7.99140625 Adineta vaga 104782 Rotifera other_Eukaryota 479 9.38e-131   NTclustered gi|72153731|gb|DQ089739.1| 104782 g73649 i0 99.245 58.0264150943396 265 2 100 0 1 265 2719 2455 Adineta vaga 28S ribosomal RNA gene, partial sequence blastn 15377 479 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta vaga
14746489 14746489 PRJNA734348_P_NODE_146832_length_212_cov_5.805755_g146134_i0 PRJNA734348 146832 212 5.8057550000000004 12.3082006 Adineta vaga 104782 Rotifera other_Eukaryota 272 1.3099999999999999e-68   NTclustered gi|259129963|gb|GQ398061.1| 104782 g146134 i0 94.35 2.5188679245283 177 10 83 0 36 212 10398 10222 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 534 272 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);;