RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB28062 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
2574095 2574095 PRJEB28062_P_NODE_16743_length_927_cov_2.747073_g14817_i0 PRJEB28062 16743 927 2.747073 25.46536671 Nitrospira tepida 2973512 Bacteria Bacteria 392 4.859999999999999e-104   NTclustered gi|2526808154|emb|OX365700.1| 2973512 g14817 i0 79.926 10.5911542610572 543 101 58 7 369 907 23974 24512 Nitrospira sp. DNF genome assembly, chromosome: NsDNF blastn 9818 392 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira tepida
3850199 3850199 PRJEB28062_P_NODE_132744_length_234_cov_2.341615_g130380_i0 PRJEB28062 132744 234 2.341615 5.4793791 Nitrospira sp. 70125 Bacteria Bacteria 279 8.83e-71   NTclustered gi|2194428397|gb|CP092079.1| 70125 g130380 i0 91.96 1.04700854700855 199 16 85 0 36 234 1262066 1262264 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 245 279 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
6401973 6401973 PRJEB28062_P_NODE_122406_length_255_cov_1.642857_g120042_i0 PRJEB28062 122406 255 1.642857 4.18928535 Nitrospira sp. 70125 Bacteria Bacteria 322 1.6e-83   NTclustered gi|2194428397|gb|CP092079.1| 70125 g120042 i0 89.453 1.25098039215686 256 25 100 2 1 255 2933992 2934246 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 319 322 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
7675898 7675898 PRJEB28062_P_NODE_110167_length_286_cov_1.732394_g107804_i0 PRJEB28062 110167 286 1.732394 4.95464684 Nitrospira defluvii 330214 Bacteria Bacteria 340 5.04e-89   NTclustered gi|300603458|emb|FP929003.1| 330214 g107804 i0 90.385 8.46153846153846 260 24 91 1 1 259 803465 803724 Candidatus Nitrospira defluvii chromosome, complete genome blastn 2420 340 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira defluvii
12777343 12777343 PRJEB28062_P_NODE_117371_length_267_cov_1.587629_g115008_i0 PRJEB28062 117371 267 1.587629 4.23896943 Candidatus Nitrospira inopinata 1715989 Bacteria Bacteria 69.4 2.43e-7   NTclustered gi|952974062|emb|LN885086.1| 1715989 g115008 i0 97.561 2.7940074906367 41 0 15 1 81 120 3121462 3121502 Nitrospira sp. ENR4 genome assembly NiCh1, chromosome : 1 blastn 746 69.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Candidatus Nitrospira inopinata
15327862 15327862 PRJEB28062_P_NODE_88573_length_349_cov_8.855072_g86211_i0 PRJEB28062 88573 349 8.855072 30.90420128 Nitrospira moscoviensis 42253 Bacteria Bacteria 379 1.33e-100   NTclustered gi|922305621|gb|CP011801.1| 42253 g86211 i0 87.73 25.8481375358166 326 38 93 2 22 346 245234 245558 Nitrospira moscoviensis strain NSP M-1, complete genome blastn 9021 379 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira moscoviensis
16290375 16290375 PRJEB28062_P_NODE_65173_length_430_cov_2.019608_g62812_i0 PRJEB28062 65173 430 2.019608 8.6843144 Nitrospira 1234 Bacteria Bacteria 612 1.5199999999999999e-170   NTclustered gi|922305621|gb|CP011801.1| 42253 g62812 i0 95.103 81.1348837209302 388 19 90 0 1 388 1278657 1279044 Nitrospira moscoviensis strain NSP M-1, complete genome blastn 34888 614 0.996742671009772 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira moscoviensis
17876442 17876442 PRJEB28062_P_NODE_44495_length_540_cov_5.248394_g42156_i0 PRJEB28062 44495 540 5.248394 28.3413276 Nitrospira sp. 70125 Bacteria Bacteria 411 7.6e-110   NTclustered gi|2194428397|gb|CP092079.1| 70125 g42156 i0 81.143 0.972222222222222 525 88 96 10 15 532 3537261 3536741 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 525 411 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);;