RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1028258" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1028258 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
1440690 1440690 PRJNA1028258_P_NODE_99182_length_262_cov_0.963731_g98619_i0 PRJNA1028258 99182 262 0.963731 2.52497522 Gemmatimonas phototrophica 1379270 Bacteria Bacteria 283 7.789999999999999e-72   NTclustered gi|1015602748|gb|CP011454.1| 1379270 g98619 i0 86.486 165.041984732824 259 33 98 2 5 262 2076276 2076533 Gemmatimonas phototrophica strain AP64, complete genome blastn 43241 283 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas phototrophica
5266997 5266997 PRJNA1028258_P_NODE_174945_length_225_cov_0.910256_g174382_i0 PRJNA1028258 174945 225 0.910256 2.048076 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 176 1.14e-39   NTclustered gi|575456455|gb|CP007128.1| 861299 g174382 i0 83.077 5.91111111111111 195 31 86 2 3 196 2023080 2022887 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 1330 176 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
5267085 5267085 PRJNA1028258_P_NODE_180045_length_219_cov_4.486667_g179482_i0 PRJNA1028258 180045 219 4.486667 9.82580073 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 154 5.16e-33   NTclustered gi|575462059|gb|CP007130.1| 861299 g179482 i0 90 1.47945205479452 120 10 54 2 14 132 864672 864554 Gemmatirosa kalamazoonesis strain KBS708 plasmid 2, complete sequence blastn 324 154 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
10366347 10366347 PRJNA1028258_P_NODE_112729_length_250_cov_1.469613_g112166_i0 PRJNA1028258 112729 250 1.469613 3.6740325 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 261 3.4600000000000002e-65   NTclustered gi|2874253728|emb|OY969570.1| 412054 g112166 i0 86.809 4.364 235 29 94 2 15 248 5118865 5119098 MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 blastn 1091 261 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
18016611 18016611 PRJNA1028258_P_NODE_40455_length_398_cov_0.851064_g39892_i0 PRJNA1028258 40455 398 0.851064 3.38723472 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 412 1.5199999999999998e-110   NTclustered gi|2874253978|emb|OY970303.1| 412054 g39892 i0 85.372 228.462311557789 417 39 100 9 1 398 1903704 1904117 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 90928 412 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
18017711 18017711 PRJNA1028258_P_NODE_94275_length_267_cov_0.929293_g93712_i0 PRJNA1028258 94275 267 0.929293 2.48121231 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 217 8.19e-52   NTclustered gi|2874253789|emb|OY969773.1| 412054 g93712 i0 81.55 20.3895131086142 271 42 100 8 1 267 421114 420848 MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 blastn 5444 217 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales 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);;