RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA703759" and tax_clade = "Nitrospinota/Tectimicrobiota group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • Nitrospinota/Tectimicrobiota group · 4 ✖

bioproject 1

  • PRJNA703759 · 4 ✖

analysis 1

  • diamond · 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
27335803 27335803 PRJNA703759_P_NODE_49303_length_243_cov_0.917647_g48827_i0 PRJNA703759 49303 243 0.917647 2.22988221 Candidatus Entotheonella sp. 2066855 Bacteria Bacteria 56.2 6.42e-7   NR HEY7709496.1 2066855 g48827 i0 39.5 1 81 42 91.4 1 242 21 181 261 HEY7709496.1 chemotaxis protein CheB [Candidatus Entotheonella sp.] diamond 243 56.2 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Candidatus Tectimicrobiota Candidatus Entotheonellia Candidatus Entotheonellales Candidatus Entotheonellaceae Candidatus Entotheonella Candidatus Entotheonella sp.
28420569 28420569 PRJNA703759_P_NODE_49526_length_243_cov_0.917647_g49050_i0 PRJNA703759 49526 243 0.917647 2.22988221 Bacteria 2 Bacteria Bacteria 110 1.8499999999999999e-28   NR OGW21230.1 1801688 g49050 i0 60.5 4 81 31 100 1 243 1 17 96 OGW21230.1 MAG: protein tyrosine phosphatase [Nitrospinae bacterium RIFCSPLOWO2_12_FULL_47_7] diamond 972 111 0.990990990990991 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinae bacterium RIFCSPLOWO2_12_FULL_47_7
30809502 30809502 PRJNA703759_P_NODE_27434_length_275_cov_2.599010_g26958_i0 PRJNA703759 27434 275 2.59901 7.1472775 Nitrospina sp. 2024844 Bacteria Bacteria 58.2 2.13e-7   NR MCA9483733.1 2024844 g26958 i0 42 0.883636363636364 81 41 87.3 3 244 5 12 87 MCA9483733.1 alpha-2-macroglobulin family protein [Nitrospina sp.] diamond 243 58.2 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota Nitrospinia Nitrospinales Nitrospinaceae Nitrospina Nitrospina sp.
32832395 32832395 PRJNA703759_P_NODE_22240_length_297_cov_1.375000_g21764_i0 PRJNA703759 22240 297 1.375 4.08375 Nitrospina sp. 2024844 Bacteria Bacteria 106 2.5399999999999998e-24   NR HIB42721.1 2024844 g21764 i0 50 2.90909090909091 98 49 99 0 294 1 77 174 HIB42721.1 hypothetical protein [Nitrospina sp.] diamond 864 106 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota Nitrospinia Nitrospinales Nitrospinaceae Nitrospina Nitrospina sp.

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