RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJEB14175" and tax_phylum = "Rotifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rotifera · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB14175 · 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
25504667 25504667 PRJEB14175_P_NODE_178481_length_246_cov_3.113514_g176214_i0 PRJEB14175 178481 246 3.113514 7.65924444 Adineta vaga 104782 Rotifera other_Eukaryota 200 7.5e-47   NTclustered gi|402761739|gb|JX184001.1| 104782 g176214 i0 83.258 0.898373983739837 221 34 89 3 3 222 1521 1303 Adineta vaga cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial blastn 221 200 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta vaga
25636898 25636898 PRJEB14175_P_NODE_103578_length_350_cov_2.740484_g101312_i0 PRJEB14175 103578 350 2.740484 9.591694 Brachionus urceolaris 204736 Rotifera other_Eukaryota 494 4.57e-135   NTclustered gi|72153738|gb|DQ089740.1| 204736 g101312 i0 92.733 63.46 344 21 97 4 10 350 2101 1759 Brachionus urceolaris 28S ribosomal RNA gene, partial sequence blastn 22211 494 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Brachionidae Brachionus Brachionus urceolaris
25746623 25746623 PRJEB14175_P_NODE_34690_length_633_cov_7.351399_g32546_i0 PRJEB14175 34690 633 7.351399 46.53435567 Eurotatoria 2816136 Rotifera other_Eukaryota 1125 0   NTclustered gi|72153731|gb|DQ089739.1| 104782 g32546 i0 98.736 42.2243285939968 633 8 100 0 1 633 1507 2139 Adineta vaga 28S ribosomal RNA gene, partial sequence blastn 26728 1125 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Adinetida Adinetidae Adineta Adineta vaga
26424779 26424779 PRJEB14175_P_NODE_179391_length_245_cov_4.543478_g177124_i0 PRJEB14175 179391 245 4.543478 11.1315211 Metazoa 33208 Rotifera other_Eukaryota 268 2.02e-67   NTclustered gi|37785582|gb|AY210469.1| 96448 g177124 i0 89.401 56.6489795918367 217 18 87 2 9 220 1815 1599 Philodina roseola 28S ribosomal RNA gene, partial sequence blastn 13879 268 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Philodina Philodina roseola

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