RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJEB81171" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJEB81171 · 6 ✖

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
6517613 6517613 PRJEB81171_P_NODE_6446_length_272_cov_1.532663_g6319_i0 PRJEB81171 6446 272 1.532663 4.16884336 Nitrospira sp. 70125 Bacteria Bacteria 194 5.969999999999999e-60   NR MCS6328919.1 70125 g6319 i0 98.9 0.992647058823529 90 1 99.3 0 1 270 164 253 MCS6328919.1 sterol desaturase family protein [Nitrospira sp.] diamond 270 194 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
15441959 15441959 PRJEB81171_P_NODE_8013_length_251_cov_1.421348_g7886_i0 PRJEB81171 8013 251 1.421348 3.56758348 Candidatus Nitrospira inopinata 1715989 Bacteria Bacteria 409 1.17e-109   NTclustered gi|952974062|emb|LN885086.1| 1715989 g7886 i0 96.016 1 251 10 100 0 1 251 56521 56271 Nitrospira sp. ENR4 genome assembly NiCh1, chromosome : 1 blastn 251 409 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Candidatus Nitrospira inopinata
28037797 28037797 PRJEB81171_P_NODE_6045_length_278_cov_1.521951_g5918_i0 PRJEB81171 6045 278 1.521951 4.23102378 Bacteria 2 Bacteria Bacteria 106 1.7699999999999998e-24   NR HKO30746.1 2026770 g5918 i0 80.3 3.53956834532374 66 13 71.2 0 200 3 237 302 HKO30746.1 PAS domain S-box protein [Nitrospiraceae bacterium] diamond 984 107 0.990654205607477 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
30950728 30950728 PRJEB81171_P_NODE_9474_length_244_cov_1.362573_g9347_i0 PRJEB81171 9474 244 1.362573 3.32467812 Nitrospira sp. SG-bin1 1827376 Bacteria Bacteria 55.8 6.74e-8   NR OQW33779.1 1827376 g9347 i0 41.8 0.823770491803279 67 36 82.4 1 43 243 19 82 OQW33779.1 MAG: hypothetical protein A4E19_02720 [Nitrospira sp. SG-bin1] diamond 201 55.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. SG-bin1
31298126 31298126 PRJEB81171_P_NODE_8635_length_248_cov_1.337143_g8508_i0 PRJEB81171 8635 248 1.337143 3.31611464 Candidatus Magnetobacterium casense 1455061 Bacteria Bacteria 52.8 1.04e-5   NR WP_218252369.1 1455061 g8508 i0 38.4 1.80241935483871 73 38 88.3 1 246 28 19 84 WP_218252369.1 GGDEF domain-containing protein [Candidatus Magnetobacterium casense] diamond 447 52.8 1 Bacteria   Pseudomonadati Nitrospirota Thermodesulfovibrionia Thermodesulfovibrionales Candidatus Magnetobacteriaceae Candidatus Magnetobacterium Candidatus Magnetobacterium casense
31994083 31994083 PRJEB81171_P_NODE_6858_length_265_cov_1.463542_g6731_i0 PRJEB81171 6858 265 1.463542 3.8783863 Nitrospira sp. 70125 Bacteria Bacteria 80.9 6.99e-17   NR MBS0172193.1 70125 g6731 i0 57.1 1.74339622641509 77 33 87.2 0 257 27 66 142 MBS0172193.1 hypothetical protein [Nitrospira sp.] diamond 462 80.9 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);;