RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJDB14275" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJDB14275 · 8 ✖

analysis 1

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
27853693 27853693 PRJDB14275_P_NODE_7285_length_166_cov_1.000000_g7226_i0 PRJDB14275 7285 166 1 1.66 Nitrospira sp. 70125 Bacteria Bacteria 83.2 2.59e-19   NR HAN92592.1 70125 g7226 i0 97.6 0.740963855421687 41 1 74.1 0 125 3 1 41 HAN92592.1 hypothetical protein [Nitrospira sp.] diamond 123 83.2 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28327179 28327179 PRJDB14275_P_NODE_6166_length_187_cov_2.067568_g6107_i0 PRJDB14275 6166 187 2.067568 3.86635216 Nitrospira sp. 70125 Bacteria Bacteria 116 4.519999999999999e-31   NR HAN93876.1 70125 g6107 i0 98.3 1.92513368983957 60 1 96.3 0 180 1 69 128 HAN93876.1 hypothetical protein [Nitrospira sp.] diamond 360 116 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28706336 28706336 PRJDB14275_P_NODE_6247_length_186_cov_1.081633_g6188_i0 PRJDB14275 6247 186 1.081633 2.01183738 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 43.9 0.0039   NR HWI68268.1 2026770 g6188 i0 87 0.370967741935484 23 3 37.1 0 72 4 4 26 HWI68268.1 hypothetical protein [Nitrospiraceae bacterium] diamond 69 43.9 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
29116847 29116847 PRJDB14275_P_NODE_2629_length_401_cov_2.160221_g2570_i0 PRJDB14275 2629 401 2.160221 8.66248621 Nitrospira sp. 70125 Bacteria Bacteria 270 1.18e-88   NR HAN92594.1 70125 g2570 i0 99.2 0.950124688279302 127 1 95 0 383 3 64 190 HAN92594.1 hypothetical protein [Nitrospira sp.] diamond 381 270 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30000992 30000992 PRJDB14275_P_NODE_3311_length_328_cov_1.961938_g3252_i0 PRJDB14275 3311 328 1.961938 6.43515664 Nitrospira sp. 70125 Bacteria Bacteria 220 2.56e-67   NR HAN92282.1 70125 g3252 i0 98.2 0.996951219512195 109 2 99.7 0 327 1 295 403 HAN92282.1 hypothetical protein [Nitrospira sp.] diamond 327 220 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30063922 30063922 PRJDB14275_P_NODE_4332_length_257_cov_1.068807_g4273_i0 PRJDB14275 4332 257 1.068807 2.74683399 Nitrospira sp. 70125 Bacteria Bacteria 143 3.43e-38   NR HAN92282.1 70125 g4273 i0 94.2 0.805447470817121 69 4 80.5 0 256 50 175 243 HAN92282.1 hypothetical protein [Nitrospira sp.] diamond 207 143 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30531989 30531989 PRJDB14275_P_NODE_7373_length_164_cov_1.936000_g7314_i0 PRJDB14275 7373 164 1.936 3.17504 root 1 Root_unresolved Root_unresolved 58.9 1.28e-8   NR UVT14425.1 70125 g7314 i0 50 6.25609756097561 52 26 95.1 0 162 7 165 216 UVT14425.1 MAG: phosphoribosylglycinamide formyltransferase [Nitrospira sp.] diamond 1026 58.9 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31897328 31897328 PRJDB14275_P_NODE_4677_length_239_cov_1.770000_g4618_i0 PRJDB14275 4677 239 1.77 4.2303 Nitrospira sp. 70125 Bacteria Bacteria 164 3.68e-48   NR HAN92594.1 70125 g4618 i0 98.6 1.85774058577406 74 1 92.9 0 238 17 233 306 HAN92594.1 hypothetical protein [Nitrospira sp.] diamond 444 164 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);;