RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA980585" 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

  • PRJNA980585 · 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
2230398 2230398 PRJNA980585_P_NODE_50042_length_246_cov_1.780347_g49788_i0 PRJNA980585 50042 246 1.780347 4.37965362 Nitrospira sp. 70125 Bacteria Bacteria 220 5.76e-53   NTclustered gi|1938802452|gb|CP054184.1| 70125 g49788 i0 83.264 1.95528455284553 239 40 97 0 5 243 850331 850569 MAG: Nitrospira sp. isolate H3_NOB1 chromosome, complete genome blastn 481 220 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
3505325 3505325 PRJNA980585_P_NODE_33503_length_270_cov_1.228426_g33249_i0 PRJNA980585 33503 270 1.228426 3.3167502 Nitrospira sp. 70125 Bacteria Bacteria 174 5.06e-39   NTclustered gi|1938802452|gb|CP054184.1| 70125 g33249 i0 80.995 55.2666666666667 221 40 81 2 1 220 1710953 1711172 MAG: Nitrospira sp. isolate H3_NOB1 chromosome, complete genome blastn 14922 174 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
7332617 7332617 PRJNA980585_P_NODE_36626_length_261_cov_1.638298_g36372_i0 PRJNA980585 36626 261 1.638298 4.27595778 Nitrospira defluvii 330214 Bacteria Bacteria 263 1.01e-65   NTclustered gi|300603458|emb|FP929003.1| 330214 g36372 i0 85.156 0.980842911877395 256 38 98 0 1 256 3482599 3482854 Candidatus Nitrospira defluvii chromosome, complete genome blastn 256 263 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira defluvii
9883043 9883043 PRJNA980585_P_NODE_43188_length_250_cov_0.870056_g42934_i0 PRJNA980585 43188 250 0.870056 2.17514 Nitrospira sp. 70125 Bacteria Bacteria 385 1.97e-102   NTclustered gi|2194436381|gb|CP092080.1| 70125 g42934 i0 94.4 1 250 14 100 0 1 250 3277668 3277419 MAG: Nitrospira sp. isolate UBC1 chromosome blastn 250 385 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
17533094 17533094 PRJNA980585_P_NODE_57434_length_243_cov_0.905882_g57180_i0 PRJNA980585 57434 243 0.905882 2.20129326 Nitrospira sp. 70125 Bacteria Bacteria 361 3.2e-95   NTclustered gi|2511640680|gb|CP126121.1| 70125 g57180 i0 93.416 1.99588477366255 243 16 100 0 1 243 1080628 1080870 MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome blastn 485 361 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
18806502 18806502 PRJNA980585_P_NODE_30295_length_279_cov_1.233010_g30041_i0 PRJNA980585 30295 279 1.23301 3.4400979 Nitrospira sp. 70125 Bacteria Bacteria 315 2.97e-81   NTclustered gi|2194432121|gb|CP092081.1| 70125 g30041 i0 87.05 1.99641577060932 278 36 99 0 1 278 2538210 2537933 MAG: Nitrospira sp. isolate UBC2 chromosome blastn 557 315 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
25181256 25181256 PRJNA980585_P_NODE_55740_length_243_cov_1.723529_g55486_i0 PRJNA980585 55740 243 1.723529 4.18817547 Nitrospira sp. 70125 Bacteria Bacteria 241 4.36e-59   NTclustered gi|2194428397|gb|CP092079.1| 70125 g55486 i0 84.711 0.995884773662551 242 35 99 2 3 243 447874 447634 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 242 241 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);;