RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJEB65099" 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

  • PRJEB65099 · 5 ✖

analysis 1

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
28707837 28707837 PRJEB65099_P_NODE_5607_length_249_cov_0.886364_g5502_i0 PRJEB65099 5607 249 0.886364 2.20704636 Nitrospira sp. 70125 Bacteria Bacteria 156 3.7399999999999997e-42   NR HSN05084.1 70125 g5502 i0 90.2 1.97590361445783 82 8 98.8 0 248 3 1129 1210 HSN05084.1 hypothetical protein [Nitrospira sp.] diamond 492 156 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28802183 28802183 PRJEB65099_P_NODE_6628_length_243_cov_0.917647_g6523_i0 PRJEB65099 6628 243 0.917647 2.22988221 Nitrospira sp. 70125 Bacteria Bacteria 139 3.8999999999999994e-36   NR MCP9464522.1 70125 g6523 i0 91.3 0.987654320987654 80 7 98.8 0 242 3 32 111 MCP9464522.1 restriction endonuclease [Nitrospira sp.] diamond 240 139 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30034005 30034005 PRJEB65099_P_NODE_6851_length_242_cov_0.923077_g6746_i0 PRJEB65099 6851 242 0.923077 2.23384634 Nitrospira sp. 70125 Bacteria Bacteria 97.8 8.74e-24   NR MCS6294329.1 70125 g6746 i0 90.7 0.669421487603306 54 5 66.9 0 80 241 1 54 MCS6294329.1 hypothetical protein [Nitrospira sp.] diamond 162 97.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30981950 30981950 PRJEB65099_P_NODE_5994_length_247_cov_0.896552_g5889_i0 PRJEB65099 5994 247 0.896552 2.21448344 Nitrospira sp. ND1 1658518 Bacteria Bacteria 162 4.21e-50   NR WP_235000149.1 1658518 g5889 i0 100 0.97165991902834 80 0 97.2 0 241 2 1 80 WP_235000149.1 ArsR/SmtB family transcription factor [Nitrospira sp. ND1] diamond 240 162 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. ND1
32373592 32373592 PRJEB65099_P_NODE_6559_length_244_cov_0.912281_g6454_i0 PRJEB65099 6559 244 0.912281 2.22596564 Nitrospira sp. 70125 Bacteria Bacteria 84 2.28e-17   NR MCP9455810.1 70125 g6454 i0 95.7 0.565573770491803 46 2 56.6 0 140 3 1 46 MCP9455810.1 cytochrome c biogenesis protein [Nitrospira sp.] diamond 138 84 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);;