RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB75227 · 8 ✖

analysis 1

  • diamond · 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
5238234 5238234 PRJEB75227_P_NODE_9865_length_248_cov_0.891429_g9694_i0 PRJEB75227 9865 248 0.891429 2.21074392 Nitrospira sp. 70125 Bacteria Bacteria 167 8.47e-51   NR ULA58477.1 70125 g9694 i0 95.1 0.991935483870968 82 4 99.2 0 247 2 33 114 ULA58477.1 MAG: putative rRNA methylase [Nitrospira sp.] diamond 246 167 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
26876259 26876259 PRJEB75227_P_NODE_7741_length_259_cov_2.473118_g7570_i0 PRJEB75227 7741 259 2.473118 6.40537562 Nitrospira sp. SCN 59-13 1660252 Bacteria Bacteria 45.4 0.00497   NR ODT43842.1 1660252 g7570 i0 77.8 0.312741312741313 27 6 31.3 0 179 259 1 27 ODT43842.1 MAG: hypothetical protein ABS70_07025 [Nitrospira sp. SCN 59-13] diamond 81 45.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. SCN 59-13
27192080 27192080 PRJEB75227_P_NODE_8362_length_253_cov_0.866667_g8191_i0 PRJEB75227 8362 253 0.866667 2.19266751 Nitrospira sp. 70125 Bacteria Bacteria 108 3.59e-28   NR MCA1957791.1 70125 g8191 i0 89.8 0.699604743083004 59 6 70 0 252 76 65 123 MCA1957791.1 PilZ domain-containing protein [Nitrospira sp.] diamond 177 108 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28865799 28865799 PRJEB75227_P_NODE_6208_length_284_cov_1.421801_g6037_i0 PRJEB75227 6208 284 1.421801 4.03791484 Nitrospira sp. 70125 Bacteria Bacteria 100 5e-25   NR MCP9452583.1 70125 g6037 i0 100 0.507042253521127 48 0 50.7 0 140 283 1 48 MCP9452583.1 hypothetical protein [Nitrospira sp.] diamond 144 100 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29339563 29339563 PRJEB75227_P_NODE_5009_length_314_cov_0.970954_g4838_i0 PRJEB75227 5009 314 0.970954 3.04879556 Nitrospira sp. 70125 Bacteria Bacteria 118 1.34e-28   NR MDH4186781.1 70125 g4838 i0 64.5 0.888535031847134 93 33 88.9 0 287 9 152 244 MDH4186781.1 hypothetical protein [Nitrospira sp.] diamond 279 118 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29371156 29371156 PRJEB75227_P_NODE_9589_length_249_cov_0.886364_g9418_i0 PRJEB75227 9589 249 0.886364 2.20704636 Nitrospira sp. 70125 Bacteria Bacteria 146 5.79e-41   NR MBH0190806.1 70125 g9418 i0 91.5 1.96385542168675 82 7 98.8 0 248 3 4 85 MBH0190806.1 HEAT repeat domain-containing protein [Nitrospira sp.] diamond 489 146 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31551401 31551401 PRJEB75227_P_NODE_9656_length_248_cov_1.262857_g9485_i0 PRJEB75227 9656 248 1.262857 3.13188536 Nitrospira sp. 70125 Bacteria Bacteria 52.8 7.17e-6   NR MDH5738737.1 70125 g9485 i0 61 0.495967741935484 41 16 49.6 0 124 2 13 53 MDH5738737.1 hypothetical protein [Nitrospira sp.] diamond 123 52.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32183956 32183956 PRJEB75227_P_NODE_9898_length_248_cov_0.891429_g9727_i0 PRJEB75227 9898 248 0.891429 2.21074392 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 102 1.97e-26   NR NLI30044.1 2026770 g9727 i0 100 0.592741935483871 49 0 59.3 0 102 248 1 49 NLI30044.1 hypothetical protein [Nitrospiraceae bacterium] diamond 147 102 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium

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);;