RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB11523", tax_kingdom = "Pseudomonadati" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 4 ✖

tax_kingdom 1

  • Pseudomonadati · 4 ✖

bioproject 1

  • PRJEB11523 · 4 ✖

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
6391931 6391931 PRJEB11523_P_NODE_7706_length_166_cov_0.871795_g7628_i0 PRJEB11523 7706 166 0.871795 1.4471797 Nitrospira sp. 70125 Bacteria Bacteria 196 6.069999999999999e-46   NTclustered gi|2194432121|gb|CP092081.1| 70125 g7628 i0 87.952 1 166 20 100 0 1 166 3926336 3926171 MAG: Nitrospira sp. isolate UBC2 chromosome blastn 166 196 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27253878 27253878 PRJEB11523_P_NODE_4863_length_213_cov_6.829268_g4785_i0 PRJEB11523 4863 213 6.829268 14.54634084 Nitrospirota bacterium 2026887 Bacteria Bacteria 95.5 3.01e-22   NR HDL19921.1 2026887 g4785 i0 73.3 1.6056338028169 60 16 84.5 0 201 22 97 156 HDL19921.1 hypothetical protein [Nitrospirota bacterium] diamond 342 95.5 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
28106512 28106512 PRJEB11523_P_NODE_585_length_790_cov_15.221323_g523_i0 PRJEB11523 585 790 15.221323 120.2484517 Nitrospira sp. 70125 Bacteria Bacteria 142 1.04e-34   NR HEX7765419.1 70125 g523 i0 41.7 1.31012658227848 187 96 70.3 3 780 226 401 576 HEX7765419.1 hypothetical protein [Nitrospira sp.] diamond 1035 142 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30380697 30380697 PRJEB11523_P_NODE_4413_length_225_cov_33.215909_g4335_i0 PRJEB11523 4413 225 33.215909 74.73579525 Nitrospirota bacterium 2026887 Bacteria Bacteria 49.3 1.2e-5   NR MFH1563393.1 2026887 g4335 i0 36.2 0.773333333333333 58 37 77.3 0 38 211 7 64 MFH1563393.1 hypothetical protein [Nitrospirota bacterium] diamond 174 49.3 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium

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