RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJEB11523" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJEB11523 · 3 ✖

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
23934957 23934957 PRJEB11523_P_NODE_4359_length_227_cov_9.578652_g4281_i0 PRJEB11523 4359 227 9.578652 21.74354004 Fimbriimonas 1005038 Bacteria Bacteria 211 3.15e-50   NTclustered gi|663071213|gb|CP007139.1| 661478 g4281 i0 85.93 37.4581497797357 199 26 87 2 30 227 29779 29582 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 8503 211 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli
24239619 24239619 PRJEB11523_P_NODE_1060_length_575_cov_15.844106_g984_i0 PRJEB11523 1060 575 15.844106 91.1036095 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 442 2.8799999999999986e-119   NTclustered gi|2076452338|gb|CP075364.1| 2682144 g984 i0 81.769 103.641739130435 554 77 95 13 10 558 669215 668681 MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome blastn 59594 442 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae bacterium
29938082 29938082 PRJEB11523_P_NODE_1911_length_396_cov_2.662824_g1833_i0 PRJEB11523 1911 396 2.662824 10.54478304 Armatimonadota bacterium 2033014 Bacteria Bacteria 67.4 4.66e-10   NR MEI8280768.1 2033014 g1833 i0 40.2 0.621212121212121 82 48 62.1 1 275 30 64 144 MEI8280768.1 hypothetical protein [Armatimonadota bacterium] diamond 246 67.4 1 Bacteria   Bacillati Armatimonadota         Armatimonadota 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);;