RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA934472" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA934472 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
27846157 27846157 PRJNA934472_P_NODE_36364_length_248_cov_0.880000_g35986_i0 PRJNA934472 36364 248 0.88 2.1824 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 93.6 4.11e-20   NR MBX3108943.1 2682144 g35986 i0 50 0.991935483870968 82 41 99.2 0 247 2 137 218 MBX3108943.1 tyrosine-type recombinase/integrase [Fimbriimonadaceae bacterium] diamond 246 93.6 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae bacterium
29867067 29867067 PRJNA934472_P_NODE_27911_length_280_cov_1.444444_g27533_i0 PRJNA934472 27911 280 1.444444 4.0444432 Capsulimonas sp. 2494211 Bacteria Bacteria 62.4 6.43e-9   NR WP_348223279.1 2494211 g27533 i0 33.3 1.06071428571429 99 58 97.5 3 3 275 20 118 WP_348223279.1 PepSY-associated TM helix domain-containing protein [Capsulimonas sp.] diamond 297 62.4 1 Bacteria   Bacillati Armatimonadota Armatimonadia Capsulimonadales Capsulimonadaceae Capsulimonas Capsulimonas sp.
29930399 29930399 PRJNA934472_P_NODE_28551_length_277_cov_1.416667_g28173_i0 PRJNA934472 28551 277 1.416667 3.92416759 Armatimonadota bacterium 2033014 Bacteria Bacteria 91.7 3.69e-19   NR NLC58560.1 2033014 g28173 i0 46.7 5.12274368231047 92 49 99.6 0 2 277 621 712 NLC58560.1 hypothetical protein [Armatimonadota bacterium] diamond 1419 91.7 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
31004475 31004475 PRJNA934472_P_NODE_22174_length_310_cov_3.189873_g21796_i0 PRJNA934472 22174 310 3.189873 9.8886063 Fimbriimonas ginsengisoli 1005039 Bacteria Bacteria 58.5 6.64e-8   NR WP_025225480.1 1005039 g21796 i0 58.7 0.445161290322581 46 19 44.5 0 308 171 43 88 WP_025225480.1 RNA polymerase sigma factor [Fimbriimonas ginsengisoli] diamond 138 58.5 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli
31889801 31889801 PRJNA934472_P_NODE_36297_length_248_cov_0.880000_g35919_i0 PRJNA934472 36297 248 0.88 2.1824 Armatimonas rosea 685828 Bacteria Bacteria 154 7.539999999999998e-42   NR WP_184203789.1 685828 g35919 i0 92.7 2.9758064516129 82 6 99.2 0 248 3 175 256 WP_184203789.1 YjhG/YagF family D-xylonate dehydratase [Armatimonas rosea] diamond 738 154 1 Bacteria   Bacillati Armatimonadota Armatimonadia Armatimonadales Armatimonadaceae Armatimonas Armatimonas rosea
32301575 32301575 PRJNA934472_P_NODE_35479_length_250_cov_1.548023_g35101_i0 PRJNA934472 35479 250 1.548023 3.8700575 Armatimonadota bacterium 2033014 Bacteria Bacteria 96.7 3.3100000000000003e-21   NR MBN9500294.1 2033014 g35101 i0 57.6 2.052 85 31 98.4 3 1 246 250 332 MBN9500294.1 deoxyribodipyrimidine photo-lyase [Armatimonadota bacterium] diamond 513 96.7 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);;