RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA839281", 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

  • PRJNA839281 · 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
19956238 19956238 PRJNA839281_S_NODE_34436_length_163_cov_0.894737_g34167_i0 PRJNA839281 34436 163 0.894737 1.45842131 Bacteria 2 Bacteria Bacteria 95.1 1.25e-21   NR MFA5073140.1 2026887 g34167 i0 83 11.6503067484663 53 9 97.5 0 161 3 44 96 MFA5073140.1 phosphoribosylformylglycinamidine cyclo-ligase [Nitrospirota bacterium] diamond 1899 95.9 0.991657977059437 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
23782026 23782026 PRJNA839281_S_NODE_26619_length_167_cov_0.864407_g26350_i0 PRJNA839281 26619 167 0.864407 1.44355969 Nitrospira sp. 70125 Bacteria Bacteria 100 4.93e-17   NTclustered gi|2194432121|gb|CP092081.1| 70125 g26350 i0 80.952 0.754491017964072 126 24 75 0 34 159 3789404 3789279 MAG: Nitrospira sp. isolate UBC2 chromosome blastn 126 100 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27655142 27655142 PRJNA839281_S_NODE_35104_length_162_cov_0.902655_g34835_i0 PRJNA839281 35104 162 0.902655 1.4623011 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 77.8 1.42e-15   NR HET6675969.1 2026770 g34835 i0 89.7 0.722222222222222 39 4 72.2 0 160 44 219 257 HET6675969.1 thioredoxin domain-containing protein [Nitrospiraceae bacterium] diamond 117 77.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
30465721 30465721 PRJNA839281_S_NODE_28973_length_166_cov_0.871795_g28704_i0 PRJNA839281 28973 166 0.871795 1.4471797 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 45.8 0.00108   NR MDA8028853.1 2026770 g28704 i0 40 0.813253012048193 45 27 81.3 0 8 142 132 176 MDA8028853.1 phosphate ABC transporter substrate-binding protein PstS [Nitrospiraceae bacterium] diamond 135 45.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae 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);;