RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA888821 · 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
5069896 5069896 PRJNA888821_P_NODE_31684_length_263_cov_1.673684_g31601_i0 PRJNA888821 31684 263 1.673684 4.40178892 Nitrospira 1234 Bacteria Bacteria 449 7.29e-122   NTclustered gi|2511640680|gb|CP126121.1| 70125 g31601 i0 97.701 185.80608365019 261 6 99 0 1 261 201912 201652 MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome blastn 48867 449 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
8515708 8515708 PRJNA888821_P_NODE_30567_length_267_cov_7.479381_g30484_i0 PRJNA888821 30567 267 7.479381 19.96994727 Nitrospira sp. 70125 Bacteria Bacteria 196 1.07e-45   NTclustered gi|2511640680|gb|CP126121.1| 70125 g30484 i0 80.8 1.89138576779026 250 48 94 0 5 254 4433318 4433069 MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome blastn 505 196 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
13616569 13616569 PRJNA888821_P_NODE_36851_length_246_cov_6.976879_g36768_i0 PRJNA888821 36851 246 6.976879 17.16312234 Nitrospira sp. 70125 Bacteria Bacteria 217 7.449999999999999e-52   NTclustered gi|2511640680|gb|CP126121.1| 70125 g36768 i0 82.52 1 246 43 100 0 1 246 3836218 3836463 MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome blastn 246 217 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
16165417 16165417 PRJNA888821_P_NODE_21593_length_309_cov_5.750000_g21511_i0 PRJNA888821 21593 309 5.75 17.7675 Nitrospira sp. 70125 Bacteria Bacteria 193 1.63e-44   NTclustered gi|2511640680|gb|CP126121.1| 70125 g21511 i0 90.411 18.7184466019417 146 14 47 0 161 306 1559198 1559343 MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome blastn 5784 193 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
17441067 17441067 PRJNA888821_P_NODE_34554_length_251_cov_7.494382_g34471_i0 PRJNA888821 34554 251 7.494382 18.81089882 Candidatus Nitrospira inopinata 1715989 Bacteria Bacteria 316 7.31e-82   NTclustered gi|952974062|emb|LN885086.1| 1715989 g34471 i0 89.558 3.43824701195219 249 26 99 0 3 251 2894915 2895163 Nitrospira sp. ENR4 genome assembly NiCh1, chromosome : 1 blastn 863 316 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Candidatus Nitrospira inopinata
21264706 21264706 PRJNA888821_P_NODE_25257_length_291_cov_6.500000_g25175_i0 PRJNA888821 25257 291 6.5 18.915 Nitrospira sp. 70125 Bacteria Bacteria 339 1.85e-88   NTclustered gi|2511640680|gb|CP126121.1| 70125 g25175 i0 87.847 0.989690721649485 288 35 99 0 2 289 1111717 1112004 MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome blastn 288 339 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
23814815 23814815 PRJNA888821_P_NODE_18239_length_310_cov_4.215190_g18157_i0 PRJNA888821 18239 310 4.21519 13.067089 Nitrospira sp. 70125 Bacteria Bacteria 316 9.299999999999999e-82   NTclustered gi|2290911150|gb|CP060501.1| 70125 g18157 i0 85.209 1.00322580645161 311 36 100 3 1 310 3846066 3845765 MAG: Nitrospira sp. isolate NSFW chromosome, complete genome blastn 311 316 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);;