RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA315314" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA315314 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
27439801 27439801 PRJNA315314_S_NODE_31643_length_152_cov_1.081301_g31322_i0 PRJNA315314 31643 152 1.081301 1.64357752 Pseudomonadati 3379134 Bacteria Bacteria 41.6 0.0246   NR MBA4372995.1 2067987 g31322 i0 53.1 2.94078947368421 49 18 96.7 1 152 6 81 124 MBA4372995.1 amino acid transporter [Thermodesulfovibrio sp.] diamond 447 42 0.990476190476191 Bacteria   Pseudomonadati Nitrospirota Thermodesulfovibrionia Thermodesulfovibrionales Thermodesulfovibrionaceae Thermodesulfovibrio Thermodesulfovibrio sp.
27453775 27453775 PRJNA315314_S_NODE_14703_length_213_cov_3.668478_g14382_i0 PRJNA315314 14703 213 3.668478 7.81385814 Nitrospirota bacterium 2026887 Bacteria Bacteria 57.4 7.24e-9   NR HEY6010389.1 2026887 g14382 i0 54.5 1.49295774647887 55 17 66.2 1 167 27 25 79 HEY6010389.1 hypothetical protein [Nitrospirota bacterium] diamond 318 57.4 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
29997219 29997219 PRJNA315314_S_NODE_27351_length_161_cov_2.113636_g27030_i0 PRJNA315314 27351 161 2.113636 3.40295396 Pseudomonadati 3379134 Bacteria Bacteria 52.4 4.84e-6   NR MDH5642359.1 70125 g27030 i0 51.2 3.96894409937888 43 21 80.1 0 158 30 76 118 MDH5642359.1 protein ndvB [Nitrospira sp.] diamond 639 52.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32192500 32192500 PRJNA315314_S_NODE_25098_length_167_cov_2.956522_g24777_i0 PRJNA315314 25098 167 2.956522 4.93739174 Nitrospirota bacterium 2026887 Bacteria Bacteria 70.9 4.25e-14   NR NCO68327.1 2026887 g24777 i0 56.4 3.95209580838323 55 24 98.8 0 2 166 12 66 NCO68327.1 RNA-binding protein [Nitrospirota bacterium] diamond 660 70.9 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota 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);;