RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA384462" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 2 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA384462 · 2 ✖

analysis 1

  • blastn · 2 ✖
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
10609099 10609099 PRJNA384462_S_NODE_12049_length_171_cov_1.639344_g11933_i0 PRJNA384462 12049 171 1.639344 2.80327824 Longimicrobiales bacterium 2910168 Bacteria Bacteria 52.8 0.014   NTclustered gi|2893358411|emb|OZ220702.1| 2910168 g11933 i0 96.774 0.181286549707602 31 1 18 0 54 84 3416 3386 MAG: Longimicrobiales bacterium isolate 5c038fdb-8e0b-4cbd-9550-43be1afc0bbf genome assembly, chromosome: 1 blastn 31 52.8 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
24631706 24631706 PRJNA384462_S_NODE_14140_length_164_cov_0.886957_g14024_i0 PRJNA384462 14140 164 0.886957 1.45460948 Gemmatimonas phototrophica 1379270 Bacteria Bacteria 268 1.25e-67   NTclustered gi|1015602748|gb|CP011454.1| 1379270 g14024 i0 100 13.609756097561 145 0 88 0 2 146 2076008 2076152 Gemmatimonas phototrophica strain AP64, complete genome blastn 2232 268 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas phototrophica

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