RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA642647", 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 · 9 ✖

tax_kingdom 1

  • Pseudomonadati · 9 ✖

bioproject 1

  • PRJNA642647 · 9 ✖

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
12097421 12097421 PRJNA642647_P_NODE_4030_length_179_cov_5.000000_g3980_i0 PRJNA642647 4030 179 5 8.95 Candidatus Nitrospira kreftii 2652173 Bacteria Bacteria 291 2.95e-74   NTclustered gi|1884724763|gb|CP047423.1| 2652173 g3980 i0 96.591 193.748603351955 176 5 98 1 4 179 2705017 2704843 Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome blastn 34681 291 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Candidatus Nitrospira kreftii
27175875 27175875 PRJNA642647_P_NODE_3062_length_200_cov_3.208589_g3012_i0 PRJNA642647 3062 200 3.208589 6.417178 Nitrospira sp. 70125 Bacteria Bacteria 120 1.78e-30   NR HAN92588.1 70125 g3012 i0 98.4 0.93 62 1 93 0 13 198 1 62 HAN92588.1 hypothetical protein [Nitrospira sp.] diamond 186 120 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28155296 28155296 PRJNA642647_P_NODE_6585_length_151_cov_1.078947_g6535_i0 PRJNA642647 6585 151 1.078947 1.62920997 Nitrospira sp. 70125 Bacteria Bacteria 58.9 2.07e-8   NR MCG3774260.1 70125 g6535 i0 54 0.993377483443709 50 22 97.4 1 151 5 568 617 MCG3774260.1 hypothetical protein [Nitrospira sp.] diamond 150 58.9 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28534188 28534188 PRJNA642647_P_NODE_4467_length_172_cov_1.022222_g4417_i0 PRJNA642647 4467 172 1.022222 1.75822184 Nitrospira sp. 70125 Bacteria Bacteria 96.3 2.01e-21   NR MBK7421575.1 70125 g4417 i0 87 0.941860465116279 54 7 94.2 0 172 11 67 120 MBK7421575.1 hypothetical protein [Nitrospira sp.] diamond 162 96.3 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29146565 29146565 PRJNA642647_P_NODE_4109_length_178_cov_1.347518_g4059_i0 PRJNA642647 4109 178 1.347518 2.39858204 Pseudomonadati 3379134 Bacteria Bacteria 100 9.78e-23   NR HNG54568.1 70125 g4059 i0 86.4 1.98876404494382 59 8 99.4 0 1 177 447 505 HNG54568.1 hypothetical protein [Nitrospira sp.] diamond 354 100 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30112741 30112741 PRJNA642647_P_NODE_6512_length_151_cov_2.921053_g6462_i0 PRJNA642647 6512 151 2.921053 4.41079003 Nitrospira sp. 70125 Bacteria Bacteria 56.6 1.29e-7   NR HAN92588.1 70125 g6462 i0 100 0.496688741721854 25 0 49.7 0 3 77 398 422 HAN92588.1 hypothetical protein [Nitrospira sp.] diamond 75 56.6 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30239219 30239219 PRJNA642647_P_NODE_3832_length_183_cov_1.527397_g3782_i0 PRJNA642647 3832 183 1.527397 2.79513651 Nitrospira sp. 70125 Bacteria Bacteria 86.7 5.33e-18   NR HMV57842.1 70125 g3782 i0 65 0.983606557377049 60 21 98.4 0 181 2 7 66 HMV57842.1 hypothetical protein [Nitrospira sp.] diamond 180 86.7 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31376997 31376997 PRJNA642647_P_NODE_6416_length_151_cov_3.552632_g6366_i0 PRJNA642647 6416 151 3.552632 5.36447432 Nitrospira sp. 70125 Bacteria Bacteria 46.2 6.39e-4   NR HNI18217.1 70125 g6366 i0 51.3 0.774834437086093 39 19 77.5 0 10 126 1 39 HNI18217.1 hypothetical protein [Nitrospira sp.] diamond 117 46.2 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32211749 32211749 PRJNA642647_P_NODE_4938_length_166_cov_3.209302_g4888_i0 PRJNA642647 4938 166 3.209302 5.32744132 Pseudomonadati 3379134 Bacteria Bacteria 52 7.27e-6   NR HMS83593.1 70125 g4888 i0 43.1 4.66265060240964 65 26 97.6 1 165 4 1173 1237 HMS83593.1 DUF5906 domain-containing protein [Nitrospira sp.] diamond 774 52 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira 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);;