RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJEB76780" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB76780 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
2688886 2688886 PRJEB76780_P_NODE_7323_length_298_cov_2.080000_g7223_i0 PRJEB76780 7323 298 2.08 6.1984 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 374 5.2e-99   NTclustered gi|2874253938|emb|OY970263.1| 412054 g7223 i0 89.562 116.687919463087 297 27 99 4 1 294 801531 801236 MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1 blastn 34773 374 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
16715407 16715407 PRJEB76780_P_NODE_11254_length_250_cov_0.881356_g11154_i0 PRJEB76780 11254 250 0.881356 2.20339 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 399 7.019999999999998e-107   NTclustered gi|2874253938|emb|OY970263.1| 412054 g11154 i0 95.6 69.148 250 9 100 1 1 250 801921 801674 MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1 blastn 17287 399 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     uncultured Gemmatimonadales bacterium
20539763 20539763 PRJEB76780_P_NODE_9497_length_263_cov_2.336842_g9397_i0 PRJEB76780 9497 263 2.336842 6.14589446 uncultured Gemmatimonadales bacterium 412054 Bacteria Bacteria 357 4.54e-94   NTclustered gi|2874253938|emb|OY970263.1| 412054 g9397 i0 91.353 184.524714828897 266 15 99 7 2 263 802185 801924 MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1 blastn 48530 357 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);;