RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1112809" 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

  • PRJNA1112809 · 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
6599277 6599277 PRJNA1112809_P_NODE_63566_length_451_cov_1.910053_g60292_i0 PRJNA1112809 63566 451 1.910053 8.61433903 uncultured Armatimonadetes bacterium 157466 Bacteria Bacteria 56.5 0.003   NTclustered gi|2874253689|emb|OY969415.1| 157466 g60292 i0 100 0.0665188470066519 30 0 7 0 76 105 2217846 2217875 MAG: uncultured Armatimonadetes bacterium isolate MFD00905.bin.2.19 genome assembly, chromosome: 1 blastn 30 56.5 1 Bacteria   Bacillati Armatimonadota         uncultured Armatimonadetes bacterium
8676885 8676885 PRJNA1112809_P_NODE_82727_length_374_cov_2.013289_g79452_i0 PRJNA1112809 82727 374 2.013289 7.52970086 Fimbriimonas 1005038 Bacteria Bacteria 496 1.37e-135   NTclustered gi|663071213|gb|CP007139.1| 661478 g79452 i0 91.057 259.090909090909 369 29 98 4 1 367 28781 29147 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 96900 496 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli
24445252 24445252 PRJNA1112809_P_NODE_133080_length_281_cov_1.360577_g129805_i0 PRJNA1112809 133080 281 1.360577 3.82322137 uncultured Fimbriimonas sp. 1936177 Bacteria Bacteria 518 2.13e-142   NTclustered gi|2329044906|gb|OP833538.1| 1936177 g129805 i0 100 99.2953736654804 280 0 99 0 2 281 281 2 Uncultured Fimbriimonas sp. clone OTU29655 16S ribosomal RNA gene, partial sequence blastn 27902 518 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas uncultured Fimbriimonas sp.
24447161 24447161 PRJNA1112809_P_NODE_57720_length_485_cov_1.990291_g54449_i0 PRJNA1112809 57720 485 1.990291 9.65291135 uncultured Armatimonadetes bacterium 157466 Bacteria Bacteria 95.3 7.74e-15   NTclustered gi|2874254000|emb|OY970325.1| 157466 g54449 i0 77.778 10.8680412371134 162 30 33 4 327 485 914527 914369 MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 blastn 5271 95.3 1 Bacteria   Bacillati Armatimonadota         uncultured Armatimonadetes 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);;