RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1095825" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1095825 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
1475257 1475257 PRJNA1095825_P_NODE_237462_length_251_cov_0.865169_g234399_i0 PRJNA1095825 237462 251 0.865169 2.17157419 Candidatus Manganitrophus sp. 2927580 Bacteria Bacteria 176 1.2899999999999999e-39   NTclustered gi|2449738114|gb|CP114561.1| 2927580 g234399 i0 83.684 18.0278884462151 190 28 75 3 1 188 96334 96146 MAG: Candidatus Manganitrophus sp. isolate GAC4 chromosome, complete genome blastn 4525 176 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Candidatus Troglogloeales Candidatus Manganitrophaceae Candidatus Manganitrophus Candidatus Manganitrophus sp.
1475528 1475528 PRJNA1095825_P_NODE_265182_length_246_cov_0.890173_g262119_i0 PRJNA1095825 265182 246 0.890173 2.18982558 Nitrospira sp. 70125 Bacteria Bacteria 206 1.61e-48   NTclustered gi|2194428397|gb|CP092079.1| 70125 g262119 i0 81.707 3.80894308943089 246 45 100 0 1 246 1987370 1987615 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 937 206 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
2751102 2751102 PRJNA1095825_P_NODE_209883_length_269_cov_2.030612_g206820_i0 PRJNA1095825 209883 269 2.030612 5.46234628 Nitrospira sp. 70125 Bacteria Bacteria 276 1.34e-69   NTclustered gi|2290907019|gb|CP060499.1| 70125 g206820 i0 86.275 1.72862453531599 255 33 94 2 1 254 4085331 4085584 MAG: Nitrospira sp. isolate DH1 chromosome, complete genome blastn 465 276 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
2751625 2751625 PRJNA1095825_P_NODE_266163_length_246_cov_0.890173_g263100_i0 PRJNA1095825 266163 246 0.890173 2.18982558 Nitrospira japonica 1325564 Bacteria Bacteria 165 2.74e-36   NTclustered gi|1167499077|emb|LT828648.1| 1325564 g263100 i0 82.967 0.739837398373984 182 31 74 0 38 219 1471576 1471757 Nitrospira japonica isolate Genome sequencing of Nitrospira japonica strain NJ11 genome assembly, chromosome: I blastn 182 165 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira japonica
6578974 6578974 PRJNA1095825_P_NODE_272726_length_245_cov_0.895349_g269663_i0 PRJNA1095825 272726 245 0.895349 2.19360505 Candidatus Nitrospira kreftii 2652173 Bacteria Bacteria 254 5.65e-63   NTclustered gi|1884724763|gb|CP047423.1| 2652173 g269663 i0 85.774 1.97142857142857 239 34 98 0 1 239 130806 131044 Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome blastn 483 254 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Candidatus Nitrospira kreftii
16777366 16777366 PRJNA1095825_P_NODE_198554_length_277_cov_2.539216_g195491_i0 PRJNA1095825 198554 277 2.539216 7.03362832 Nitrospira japonica 1325564 Bacteria Bacteria 110 1.49e-19   NTclustered gi|1167499077|emb|LT828648.1| 1325564 g195491 i0 82 1.68953068592058 150 8 47 5 3 133 472344 472493 Nitrospira japonica isolate Genome sequencing of Nitrospira japonica strain NJ11 genome assembly, chromosome: I blastn 468 110 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira japonica
20602164 20602164 PRJNA1095825_P_NODE_278437_length_244_cov_0.900585_g275374_i0 PRJNA1095825 278437 244 0.900585 2.1974274 Nitrospirales bacterium 2358460 Bacteria Bacteria 63.9 1.02e-5   NTclustered gi|2621704626|emb|OY763007.1| 2358460 g275374 i0 97.297 5.31147540983607 37 1 18 0 4 40 1124 1160 MAG: Nitrospirales bacterium isolate d9641d0a-9015-4cc2-bf8e-6a264f466c72 genome assembly, chromosome: 1 blastn 1296 63.9 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales     Nitrospirales 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);;