RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA900028" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA900028 · 4 ✖

analysis 1

  • blastn · 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
7253576 7253576 PRJNA900028_P_NODE_34786_length_229_cov_2.327778_g34037_i0 PRJNA900028 34786 229 2.327778 5.33061162 uncultured Armatimonadetes bacterium 157466 Bacteria Bacteria 185 1.9299999999999994e-42   NTclustered gi|2874254000|emb|OY970325.1| 157466 g34037 i0 84.946 261.301310043668 186 25 80 3 46 229 1304104 1304288 MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 blastn 59838 185 1 Bacteria   Bacillati Armatimonadota         uncultured Armatimonadetes bacterium
8897887 8897887 PRJNA900028_P_NODE_17947_length_281_cov_3.383621_g17198_i0 PRJNA900028 17947 281 3.383621 9.50797501 Bacteria 2 Bacteria Bacteria 204 6.76e-48   NTclustered gi|2874254000|emb|OY970325.1| 157466 g17198 i0 80.139 73.8932384341637 287 45 100 11 1 281 1304902 1304622 MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 blastn 20764 206 0.990291262135922 Bacteria   Bacillati Armatimonadota         uncultured Armatimonadetes bacterium
16177505 16177505 PRJNA900028_P_NODE_153013_length_164_cov_1.521739_g152264_i0 PRJNA900028 153013 164 1.521739 2.49565196 Armatimonadota bacterium 2033014 Bacteria Bacteria 303 3.42e-78   NTclustered gi|1493551556|dbj|LC378776.1| 2033014 g152264 i0 100 98.8109756097561 164 0 100 0 1 164 153 316 Armatimonadetes bacterium LA-DMC-2W6 gene for 16S ribosomal RNA, partial sequence blastn 16205 303 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
18726579 18726579 PRJNA900028_P_NODE_190235_length_161_cov_0.910714_g189486_i0 PRJNA900028 190235 161 0.910714 1.46624954 Fimbriimonas ginsengisoli 1005039 Bacteria Bacteria 65.8 1.72e-6   NTclustered gi|663071213|gb|CP007139.1| 661478 g189486 i0 87.719 0.354037267080745 57 5 35 2 106 161 801024 800969 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 57 65.8 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli

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