RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA312899" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA312899 · 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
18230675 18230675 PRJNA312899_P_NODE_12375_length_537_cov_55.598361_g11946_i0 PRJNA312899 12375 537 55.598361 298.56319857 Nitrososphaeria archaeon 2268198 Archaea Archaea 137 4.19e-37   NR NDB92457.1 2268198 g11946 i0 65.3 0.547486033519553 98 34 54.7 0 294 1 7 104 NDB92457.1 class I SAM-dependent methyltransferase [Nitrososphaeria archaeon] diamond 294 137 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria       Nitrososphaeria archaeon
29789865 29789865 PRJNA312899_P_NODE_96991_length_163_cov_0.894737_g96549_i0 PRJNA312899 96991 163 0.894737 1.45842131 Nitrososphaera sp. 1971748 Archaea Archaea 97.1 3.98e-23   NR HEV8387235.1 1971748 g96549 i0 77.8 5.96319018404908 54 12 99.4 0 2 163 157 210 HEV8387235.1 DUF72 domain-containing protein [Nitrososphaera sp.] diamond 972 97.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
32287640 32287640 PRJNA312899_P_NODE_72319_length_189_cov_1.457143_g71877_i0 PRJNA312899 72319 189 1.457143 2.75400027 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 107 2.9800000000000003e-27   NR HZB65072.1 2169593 g71877 i0 90.3 0.984126984126984 62 6 98.4 0 3 188 26 87 HZB65072.1 2-phospho-L-lactate guanylyltransferase [Nitrososphaeraceae archaeon] diamond 186 107 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32572253 32572253 PRJNA312899_P_NODE_43799_length_267_cov_6.513761_g43357_i0 PRJNA312899 43799 267 6.513761 17.39174187 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 157 1.94e-43   NR HEY7110298.1 2169593 g43357 i0 89.8 3.98876404494382 88 9 98.9 0 4 267 221 308 HEY7110298.1 ATP-binding protein [Nitrososphaeraceae archaeon] diamond 1065 157 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);;