RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA900028", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 4 ✖

tax_phylum 1

  • Nitrososphaerota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA900028 · 4 ✖

analysis 1

tax_clade 0

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
26612431 26612431 PRJNA900028_P_NODE_112761_length_170_cov_1.107438_g112012_i0 PRJNA900028 112761 170 1.107438 1.8826446 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 89 7.16e-19   NR MDW3645339.1 2169593 g112012 i0 76.4 0.970588235294118 55 13 97.1 0 166 2 410 464 MDW3645339.1 reverse transcriptase family protein [Nitrososphaeraceae archaeon] diamond 165 89 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
28729553 28729553 PRJNA900028_P_NODE_110727_length_171_cov_1.008197_g109978_i0 PRJNA900028 110727 171 1.008197 1.72401687 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 97.4 1.55e-22   NR HVD08304.1 2169593 g109978 i0 78.9 2 57 12 100 0 1 171 92 148 HVD08304.1 DDE-type integrase/transposase/recombinase [Nitrososphaeraceae archaeon] diamond 342 97.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31604482 31604482 PRJNA900028_P_NODE_60776_length_196_cov_1.387755_g60027_i0 PRJNA900028 60776 196 1.387755 2.7199998 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 124 3.92e-31   NR MDW0150286.1 2169593 g60027 i0 98.5 0.994897959183674 65 1 99.5 0 2 196 26 90 MDW0150286.1 reverse transcriptase family protein [Nitrososphaeraceae archaeon] diamond 195 124 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31604493 31604493 PRJNA900028_P_NODE_90596_length_180_cov_1.549618_g89847_i0 PRJNA900028 90596 180 1.549618 2.7893124 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 82.4 1.63e-16   NR HEY8522856.1 2169593 g89847 i0 76.4 0.916666666666667 55 12 91.7 1 167 3 463 516 HEY8522856.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 165 82.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon

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