RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA681861", tax_phylum = "Deferribacterota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_phylum 1

  • Deferribacterota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA681861 · 4 ✖

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
1171343 1171343 PRJNA681861_P_NODE_29821_length_217_cov_5.021277_g27721_i0 PRJNA681861 29821 217 5.021277 10.89617109 Calditerrivibrio 545865 Bacteria Bacteria 351 1.69e-92   NTclustered gi|470487186|ref|NR_076806.1| 477976 g27721 i0 95.853 105.336405529954 217 9 100 0 1 217 282 498 Calditerrivibrio nitroreducens strain Yu37-1 23S ribosomal RNA gene, complete sequence blastn 22858 351 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Calditerrivibrionaceae Calditerrivibrio Calditerrivibrio nitroreducens
4485517 4485517 PRJNA681861_P_NODE_17364_length_362_cov_3.249249_g15268_i0 PRJNA681861 17364 362 3.249249 11.76228138 Calditerrivibrio nitroreducens 477976 Bacteria Bacteria 329 1.42e-85   NTclustered gi|312938725|gb|CP002347.1| 768670 g15268 i0 98.913 56.0580110497238 184 2 92 0 1 184 2001704 2001887 Calditerrivibrio nitroreducens DSM 19672, complete genome blastn 20293 329 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Calditerrivibrionaceae Calditerrivibrio Calditerrivibrio nitroreducens
11375010 11375010 PRJNA681861_P_NODE_33929_length_196_cov_4.976048_g31829_i0 PRJNA681861 33929 196 4.976048 9.75305408 Calditerrivibrio 545865 Bacteria Bacteria 294 2.55e-75   NTclustered gi|470487186|ref|NR_076806.1| 477976 g31829 i0 93.878 28.1632653061224 196 10 99 2 3 196 1498 1693 Calditerrivibrio nitroreducens strain Yu37-1 23S ribosomal RNA gene, complete sequence blastn 5520 294 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Calditerrivibrionaceae Calditerrivibrio Calditerrivibrio nitroreducens
11375018 11375018 PRJNA681861_P_NODE_47209_length_150_cov_2.231405_g45109_i0 PRJNA681861 47209 150 2.231405 3.3471075 Calditerrivibrio 545865 Bacteria Bacteria 267 4.009999999999999e-67   NTclustered gi|470487186|ref|NR_076806.1| 477976 g45109 i0 98.667 270.406666666667 150 2 100 0 1 150 2129 2278 Calditerrivibrio nitroreducens strain Yu37-1 23S ribosomal RNA gene, complete sequence blastn 40561 267 1 Bacteria   Pseudomonadati Deferribacterota Deferribacteres Deferribacterales Calditerrivibrionaceae Calditerrivibrio Calditerrivibrio nitroreducens

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