RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1002570" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1002570 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
4828778 4828778 PRJNA1002570_P_NODE_39904_length_246_cov_1.335260_g39709_i0 PRJNA1002570 39904 246 1.33526 3.2847396 Pseudomonadati 3379134 Bacteria Bacteria 244 3.42e-60   NTclustered gi|922305621|gb|CP011801.1| 42253 g39709 i0 84.615 100.548780487805 247 36 100 2 1 246 56546 56301 Nitrospira moscoviensis strain NSP M-1, complete genome blastn 24735 244 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira moscoviensis
10355735 10355735 PRJNA1002570_P_NODE_40629_length_245_cov_1.744186_g40434_i0 PRJNA1002570 40629 245 1.744186 4.2732557 Candidatus Manganitrophus sp. 2927580 Bacteria Bacteria 187 5.809999999999998e-43   NTclustered gi|2449729286|gb|CP114553.1| 2927580 g40434 i0 81.9 134.783673469388 221 40 90 0 20 240 1674927 1675147 MAG: Candidatus Manganitrophus sp. isolate GAC1 chromosome, complete genome blastn 33022 187 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Candidatus Troglogloeales Candidatus Manganitrophaceae Candidatus Manganitrophus Candidatus Manganitrophus sp.
16729159 16729159 PRJNA1002570_P_NODE_21894_length_286_cov_2.131455_g21699_i0 PRJNA1002570 21894 286 2.131455 6.0959613 Nitrospira sp. 70125 Bacteria Bacteria 257 5.22e-64   NTclustered gi|2194432121|gb|CP092081.1| 70125 g21699 i0 82.867 68.2832167832168 286 49 100 0 1 286 336579 336294 MAG: Nitrospira sp. isolate UBC2 chromosome blastn 19529 257 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
16729583 16729583 PRJNA1002570_P_NODE_5334_length_471_cov_2.776382_g5140_i0 PRJNA1002570 5334 471 2.776382 13.07675922 Candidatus Manganitrophus sp. 2927580 Bacteria Bacteria 296 1.92e-75   NTclustered gi|2449738114|gb|CP114561.1| 2927580 g5140 i0 88.353 102.422505307856 249 25 52 4 4 249 845442 845195 MAG: Candidatus Manganitrophus sp. isolate GAC4 chromosome, complete genome blastn 48241 296 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Candidatus Troglogloeales Candidatus Manganitrophaceae Candidatus Manganitrophus Candidatus Manganitrophus sp.
19278051 19278051 PRJNA1002570_P_NODE_3596_length_566_cov_1.817444_g3404_i0 PRJNA1002570 3596 566 1.817444 10.28673304 Candidatus Manganitrophus sp. 2927580 Bacteria Bacteria 348 6.36e-91   NTclustered gi|2449738114|gb|CP114561.1| 2927580 g3404 i0 78.897 52.5212014134276 526 102 92 9 22 543 2661151 2661671 MAG: Candidatus Manganitrophus sp. isolate GAC4 chromosome, complete genome blastn 29727 348 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Candidatus Troglogloeales Candidatus Manganitrophaceae Candidatus Manganitrophus Candidatus Manganitrophus 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);;