RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB49404" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB49404 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
1369372 1369372 PRJEB49404_P_NODE_16782_length_1911_cov_3.402778_g11324_i0 PRJEB49404 16782 1911 3.402778 65.02708758 Gemmatirosa kalamazoonensis 861299 Bacteria Bacteria 2152 0   NTclustered gi|575456455|gb|CP007128.1| 861299 g11324 i0 87.221 107.526425954997 1925 202 99 39 2 1911 3044204 3042309 Gemmatirosa kalamazoonesis strain KBS708, complete genome blastn 205483 2152 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatirosa Gemmatirosa kalamazoonensis
5219640 5219640 PRJEB49404_P_NODE_636145_length_153_cov_1.052632_g622344_i0 PRJEB49404 636145 153 1.052632 1.61052696 Gemmatimonas phototrophica 1379270 Bacteria Bacteria 250 4.14e-62   NTclustered gi|1015602748|gb|CP011454.1| 1379270 g622344 i0 96.078 88.0196078431373 153 6 100 0 1 153 2075209 2075057 Gemmatimonas phototrophica strain AP64, complete genome blastn 13467 250 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae Gemmatimonas Gemmatimonas phototrophica
6495680 6495680 PRJEB49404_P_NODE_642386_length_151_cov_2.642857_g628585_i0 PRJEB49404 642386 151 2.642857 3.99071407 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 209 6.91e-50   NTclustered gi|2874253978|emb|OY970303.1| 412054 g628585 i0 92.617 179.794701986755 149 6 97 4 3 149 1902961 1902816 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 27149 209 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
10321876 10321876 PRJEB49404_P_NODE_90009_length_620_cov_2.617900_g76776_i0 PRJEB49404 90009 620 2.6179 16.23098 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 785 0   NTclustered gi|2874253978|emb|OY970303.1| 412054 g76776 i0 89.666 104.608064516129 629 48 100 11 1 620 1903620 1903000 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 64857 785 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
14134170 14134170 PRJEB49404_P_NODE_399872_length_214_cov_1.457143_g386071_i0 PRJEB49404 399872 214 1.457143 3.11828602 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 287 4.75e-73   NTclustered gi|2874253978|emb|OY970303.1| 412054 g386071 i0 91.748 436.429906542056 206 17 96 0 9 214 1903906 1904111 MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 blastn 93396 287 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
23061465 23061465 PRJEB49404_P_NODE_475919_length_188_cov_2.201342_g462118_i0 PRJEB49404 475919 188 2.201342 4.13852296 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 276 8.780000000000001e-70   NTclustered gi|2874253728|emb|OY969570.1| 412054 g462118 i0 93.085 222.239361702128 188 13 100 0 1 188 172334 172521 MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 blastn 41781 276 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
24343501 24343501 PRJEB49404_P_NODE_645660_length_151_cov_1.455357_g631859_i0 PRJEB49404 645660 151 1.455357 2.19758907 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 159 7.059999999999998e-35   NTclustered gi|2874253789|emb|OY969773.1| 412054 g631859 i0 85.906 53.3576158940397 149 21 99 0 3 151 422858 423006 MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 blastn 8057 159 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);;