RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA493244" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA493244 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
5558850 5558850 PRJNA493244_P_NODE_1285005_length_301_cov_2.825000_g1261881_i0 PRJNA493244 1285005 301 2.825 8.50325 Fimbriimonadales bacterium 2682145 Bacteria Bacteria 313 1.16e-80   NTclustered gi|2314715370|dbj|AP024673.1| 2682145 g1261881 i0 87.097 2.54485049833887 279 33 92 1 1 276 531031 531309 MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome blastn 766 313 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales     Fimbriimonadales bacterium
5560103 5560103 PRJNA493244_P_NODE_1749265_length_181_cov_4.033333_g1726140_i0 PRJNA493244 1749265 181 4.033333 7.30033273 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 169 1.4599999999999998e-37   NTclustered gi|2076452338|gb|CP075364.1| 2682144 g1726140 i0 86.928 32.171270718232 153 16 83 4 1 151 667553 667403 MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome blastn 5823 169 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae bacterium
9384015 9384015 PRJNA493244_P_NODE_1603748_length_219_cov_16.088608_g1580623_i0 PRJNA493244 1603748 219 16.088608 35.23405152 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 183 6.59e-42   NTclustered gi|2076452338|gb|CP075364.1| 2682144 g1580623 i0 84.021 308.867579908676 194 27 87 3 1 190 667594 667401 MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome blastn 67642 183 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae bacterium
10028305 10028305 PRJNA493244_P_NODE_1745728_length_188_cov_2.354331_g1722603_i0 PRJNA493244 1745728 188 2.354331 4.42614228 Fimbriimonas 1005038 Bacteria Bacteria 209 9.03e-50   NTclustered gi|663071213|gb|CP007139.1| 661478 g1722603 i0 89.222 20.9627659574468 167 18 89 0 22 188 27630 27464 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 3941 209 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli
19582023 19582023 PRJNA493244_P_NODE_1633856_length_213_cov_2.105263_g1610731_i0 PRJNA493244 1633856 213 2.105263 4.48421019 Capsulimonas corticalis 2219043 Bacteria Bacteria 93.5 1.1e-14   NTclustered gi|2240447379|dbj|AP025739.1| 2219043 g1610731 i0 82.243 2.51173708920188 107 19 50 0 30 136 595557 595451 Capsulimonas corticalis AX-7 DNA, complete genome blastn 535 93.5 1 Bacteria   Bacillati Armatimonadota Armatimonadia Capsulimonadales Capsulimonadaceae Capsulimonas Capsulimonas corticalis
21501734 21501734 PRJNA493244_P_NODE_1536037_length_234_cov_53.606936_g1512912_i0 PRJNA493244 1536037 234 53.606936 125.44023024 Fimbriimonas 1005038 Bacteria Bacteria 281 2.46e-71   NTclustered gi|663071213|gb|CP007139.1| 661478 g1512912 i0 90.61 63.4102564102564 213 18 91 2 1 212 29575 29786 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 14838 281 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli
23408056 23408056 PRJNA493244_P_NODE_1501659_length_242_cov_2.928177_g1478534_i0 PRJNA493244 1501659 242 2.928177 7.08618834 Fimbriimonas ginsengisoli 1005039 Bacteria Bacteria 122 1.6399999999999998e-23   NTclustered gi|663071213|gb|CP007139.1| 661478 g1478534 i0 87.619 4.85537190082645 105 13 43 0 1 105 5174333 5174437 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 1175 122 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli
23408297 23408297 PRJNA493244_P_NODE_1585359_length_223_cov_22.993827_g1562234_i0 PRJNA493244 1585359 223 22.993827 51.27623421 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 196 8.64e-46   NTclustered gi|2076452338|gb|CP075364.1| 2682144 g1562234 i0 85.946 2.56502242152466 185 25 83 1 40 223 667410 667594 MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome blastn 572 196 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae bacterium
24052161 24052161 PRJNA493244_P_NODE_992599_length_410_cov_2.716332_g969519_i0 PRJNA493244 992599 410 2.716332 11.1369612 Fimbriimonas 1005038 Bacteria Bacteria 457 7.14e-124   NTclustered gi|663071213|gb|CP007139.1| 661478 g969519 i0 86.925 132.221951219512 413 47 100 6 1 410 28020 28428 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 54211 457 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli
25326074 25326074 PRJNA493244_P_NODE_1518580_length_238_cov_231.644068_g1495455_i0 PRJNA493244 1518580 238 231.644068 551.31288184 Fimbriimonas 1005038 Bacteria Bacteria 215 2.58e-51   NTclustered gi|663071213|gb|CP007139.1| 661478 g1495455 i0 85.446 37.218487394958 213 23 88 8 3 211 29573 29781 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 8858 215 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);;