RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA550047", tax_phylum = "Nitrospinota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_phylum 1

  • Nitrospinota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA550047 · 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
5621283 5621283 PRJNA550047_P_NODE_52045_length_345_cov_19.742647_g50085_i0 PRJNA550047 52045 345 19.742647 68.11213215 Candidatus Nitrohelix vancouverensis 2705534 Bacteria Bacteria 65.8 4.19e-6   NTclustered gi|1938442527|gb|CP048620.1| 2705534 g50085 i0 89.286 10.2782608695652 56 1 15 3 100 151 733777 733723 MAG: Candidatus Nitrohelix vancouverensis isolate VA-1 chromosome blastn 3546 65.8 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota Nitrospinia Nitrospinales Nitrospinaceae Candidatus Nitrohelix Candidatus Nitrohelix vancouverensis
28924259 28924259 PRJNA550047_P_NODE_552288_length_213_cov_4.942857_g550315_i0 PRJNA550047 552288 213 4.942857 10.52828541 Bacteria 2 Bacteria Bacteria 102 1.1099999999999999e-23   NR OGW12588.1 1801690 g550315 i0 67.6 22 71 23 100 0 1 213 276 346 OGW12588.1 MAG: diaminopimelate decarboxylase [Nitrospinae bacterium RIFCSPLOWO2_12_39_16] diamond 4686 102 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinae bacterium RIFCSPLOWO2_12_39_16
30204223 30204223 PRJNA550047_P_NODE_479932_length_237_cov_7.939024_g477959_i0 PRJNA550047 479932 237 7.939024 18.81548688 Nitrospinota bacterium 2026769 Bacteria Bacteria 74.7 1.23e-14   NR MDP7661740.1 2026769 g477959 i0 54.8 1.88607594936709 73 33 92.4 0 219 1 2 74 MDP7661740.1 IS5 family transposase [Nitrospinota bacterium] diamond 447 74.7 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota bacterium
30994451 30994451 PRJNA550047_P_NODE_539774_length_217_cov_7.284722_g537801_i0 PRJNA550047 539774 217 7.284722 15.80784674 Nitrospinota bacterium 2026769 Bacteria Bacteria 101 4.39e-24   NR MBI3584007.1 2026769 g537801 i0 70.4 1.963133640553 71 21 98.2 0 215 3 145 215 MBI3584007.1 AAA family ATPase [Nitrospinota bacterium] diamond 426 101 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota 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);;