RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA493828 · 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
2382239 2382239 PRJNA493828_P_NODE_45262_length_217_cov_4.236111_g44843_i0 PRJNA493828 45262 217 4.236111 9.19236087 Nitrospira 1234 Bacteria Bacteria 350 6.07e-92   NTclustered gi|922305621|gb|CP011801.1| 42253 g44843 i0 98.01 148.764976958525 201 4 93 0 17 217 1279050 1278850 Nitrospira moscoviensis strain NSP M-1, complete genome blastn 32282 350 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira moscoviensis
2382268 2382268 PRJNA493828_P_NODE_4742_length_504_cov_2.529002_g4352_i0 PRJNA493828 4742 504 2.529002 12.74617008 Nitrospira 1234 Bacteria Bacteria 819 0   NTclustered gi|922305621|gb|CP011801.1| 42253 g4352 i0 96.032 239.323412698413 504 19 100 1 1 504 1278613 1278111 Nitrospira moscoviensis strain NSP M-1, complete genome blastn 120619 826 0.991525423728814 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira moscoviensis
4301612 4301612 PRJNA493828_P_NODE_30364_length_255_cov_2.010989_g29945_i0 PRJNA493828 30364 255 2.010989 5.12802195 Nitrospira moscoviensis 42253 Bacteria Bacteria 466 6.98e-127   NTclustered gi|922305621|gb|CP011801.1| 42253 g29945 i0 99.608 2 255 1 100 0 1 255 113687 113941 Nitrospira moscoviensis strain NSP M-1, complete genome blastn 510 466 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira moscoviensis
5578244 5578244 PRJNA493828_P_NODE_26325_length_266_cov_2.922280_g25906_i0 PRJNA493828 26325 266 2.92228 7.7732648 Candidatus Nitrospira kreftii 2652173 Bacteria Bacteria 438 1.6e-118   NTclustered gi|1884724763|gb|CP047423.1| 2652173 g25906 i0 97.647 285.071428571429 255 6 96 0 1 255 2707774 2707520 Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome blastn 75829 438 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Candidatus Nitrospira kreftii
10678520 10678520 PRJNA493828_P_NODE_44949_length_219_cov_5.712329_g44530_i0 PRJNA493828 44949 219 5.712329 12.51000051 Nitrospira moscoviensis 42253 Bacteria Bacteria 355 1.32e-93   NTclustered gi|922305621|gb|CP011801.1| 42253 g44530 i0 95.89 258.803652968037 219 9 100 0 1 219 1277864 1278082 Nitrospira moscoviensis strain NSP M-1, complete genome blastn 56678 355 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira moscoviensis
11953499 11953499 PRJNA493828_P_NODE_33770_length_248_cov_13.965714_g33351_i0 PRJNA493828 33770 248 13.965714 34.63497072 Candidatus Nitrospira kreftii 2652173 Bacteria Bacteria 435 1.91e-117   NTclustered gi|1884724763|gb|CP047423.1| 2652173 g33351 i0 98.776 146.552419354839 245 2 99 1 4 248 2705030 2704787 Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome blastn 36345 435 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Candidatus Nitrospira kreftii
13228540 13228540 PRJNA493828_P_NODE_29851_length_256_cov_3.142077_g29432_i0 PRJNA493828 29851 256 3.142077 8.04371712 Nitrospira sp. 70125 Bacteria Bacteria 473 4.189999999999999e-129   NTclustered gi|2290915413|gb|CP060502.1| 70125 g29432 i0 100 2 256 0 100 0 1 256 195858 195603 MAG: Nitrospira sp. isolate NSFW plasmid pNSFW1, complete sequence blastn 512 473 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);;