RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA393181" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA393181 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
2960733 2960733 PRJNA393181_S_NODE_10923_length_365_cov_2.856707_g10817_i0 PRJNA393181 10923 365 2.856707 10.42698055 Nitrospira sp. 70125 Bacteria Bacteria 226 2.92e-69   NR HEX9154166.1 70125 g10817 i0 82.6 1.98904109589041 121 21 99.5 0 3 365 317 437 HEX9154166.1 arylsulfatase [Nitrospira sp.] diamond 726 226 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
5514192 5514192 PRJNA393181_S_NODE_27745_length_215_cov_2.191011_g27639_i0 PRJNA393181 27745 215 2.191011 4.71067365 Nitrospirales bacterium 2358460 Bacteria Bacteria 64.7 4.91e-11   NR GJL59938.1 2358460 g27639 i0 48.5 0.948837209302326 68 18 94.9 1 11 214 73 123 GJL59938.1 MAG: glyoxalase [Nitrospirales bacterium] diamond 204 64.7 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales     Nitrospirales bacterium
9338532 9338532 PRJNA393181_S_NODE_26528_length_221_cov_2.586957_g26422_i0 PRJNA393181 26528 221 2.586957 5.71717497 Nitrospirota bacterium 2026887 Bacteria Bacteria 53.5 4.44e-6   NR MBI5101691.1 2026887 g26422 i0 40.4 0.773755656108597 57 34 77.4 0 204 34 307 363 MBI5101691.1 PAS domain S-box protein [Nitrospirota bacterium] diamond 171 53.5 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
16987991 16987991 PRJNA393181_S_NODE_3114_length_608_cov_2.164623_g3026_i0 PRJNA393181 3114 608 2.164623 13.16090784 Pseudomonadati 3379134 Bacteria Bacteria 73.6 1.39e-11   NR KJU83480.1 29290 g3026 i0 64.2 2.75822368421053 179 63 88.3 1 587 51 26 203 KJU83480.1 FG-GAP repeat-containing protein [Candidatus Magnetobacterium bavaricum] diamond 1677 74.3 0.990578734858681 Bacteria   Pseudomonadati Nitrospirota Thermodesulfovibrionia Thermodesulfovibrionales Candidatus Magnetobacteriaceae Candidatus Magnetobacterium Candidatus Magnetobacterium bavaricum
26885660 26885660 PRJNA393181_S_NODE_27601_length_216_cov_1.709497_g27495_i0 PRJNA393181 27601 216 1.709497 3.69251352 Nitrospirota bacterium 2026887 Bacteria Bacteria 86.7 8.56e-18   NR MDP2382078.1 2026887 g27495 i0 62.3 9.47222222222222 61 23 84.7 0 187 5 6 66 MDP2382078.1 hypothetical protein [Nitrospirota bacterium] diamond 2046 86.7 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
28117466 28117466 PRJNA393181_S_NODE_39965_length_169_cov_2.037879_g39859_i0 PRJNA393181 39965 169 2.037879 3.44401551 Nitrospirota bacterium 2026887 Bacteria Bacteria 62.4 1.59e-10   NR MEW6324445.1 2026887 g39859 i0 44.6 0.994082840236686 56 31 99.4 0 2 169 73 128 MEW6324445.1 hypothetical protein [Nitrospirota bacterium] diamond 168 62.4 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
28622916 28622916 PRJNA393181_S_NODE_23967_length_236_cov_2.296482_g23861_i0 PRJNA393181 23967 236 2.296482 5.41969752 Nitrospira sp. 70125 Bacteria Bacteria 48.5 3e-4   NR MFO0706994.1 70125 g23861 i0 46.3 3.35593220338983 54 29 68.6 0 178 17 10 63 MFO0706994.1 sensor histidine kinase [Nitrospira sp.] diamond 792 48.5 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30408373 30408373 PRJNA393181_S_NODE_6153_length_472_cov_2.577011_g6047_i0 PRJNA393181 6153 472 2.577011 12.16349192 Pseudomonadati 3379134 Bacteria Bacteria 73.9 1.34e-13   NR MBK7417591.1 70125 g6047 i0 64.7 0.781779661016949 51 18 32.4 0 160 8 11 61 MBK7417591.1 hypothetical protein [Nitrospira sp.] diamond 369 73.9 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30913739 30913739 PRJNA393181_S_NODE_44754_length_157_cov_1.300000_g44648_i0 PRJNA393181 44754 157 1.3 2.041 PVC group 1783257 Bacteria Bacteria 43.1 0.004   NR MBX3330977.1 70125 g44648 i0 43.1 6.51592356687898 51 29 97.5 0 153 1 9 59 MBX3330977.1 purine-binding chemotaxis protein CheW [Nitrospira sp.] diamond 1023 43.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31055070 31055070 PRJNA393181_S_NODE_3775_length_568_cov_2.363465_g3679_i0 PRJNA393181 3775 568 2.363465 13.4244812 Nitrospirota bacterium 2026887 Bacteria Bacteria 84.7 2.79e-15   NR MEW6162022.1 2026887 g3679 i0 33.2 2.74119718309859 184 114 94 3 4 537 702 882 MEW6162022.1 adenylate/guanylate cyclase domain-containing protein [Nitrospirota bacterium] diamond 1557 84.7 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
32320292 32320292 PRJNA393181_S_NODE_35279_length_184_cov_1.843537_g35173_i0 PRJNA393181 35279 184 1.843537 3.39210808 Nitrospirota bacterium 2026887 Bacteria Bacteria 57.8 8.52e-8   NR MBI3611961.1 2026887 g35173 i0 49.1 1.85869565217391 53 27 86.4 0 26 184 47 99 MBI3611961.1 response regulator [Nitrospirota bacterium] diamond 342 57.8 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
32478337 32478337 PRJNA393181_S_NODE_12219_length_345_cov_3.688312_g12113_i0 PRJNA393181 12219 345 3.688312 12.7246764 Nitrospirota bacterium 2026887 Bacteria Bacteria 58.5 3.35e-8   NR MDH4229660.1 2026887 g12113 i0 69.2 0.339130434782609 39 12 33.9 0 126 10 1 39 MDH4229660.1 response regulator [Nitrospirota bacterium] diamond 117 58.5 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);;