RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJEB36940" and tax_clade = "Bacteria candidate phyla"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Bacteria candidate phyla · 3 ✖

bioproject 1

  • PRJEB36940 · 3 ✖

analysis 1

  • blastn · 3 ✖

tax_kingdom 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
6434948 6434948 PRJEB36940_P_NODE_15346_length_243_cov_1.829412_g15217_i0 PRJEB36940 15346 243 1.829412 4.44547116 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 320 5.44e-83   NTclustered gi|1474570736|gb|CP023991.1| 2026720 g15217 i0 90.535 471.329218106996 243 22 100 1 1 243 884091 883850 Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome blastn 114533 320 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota bacterium
14085154 14085154 PRJEB36940_P_NODE_8872_length_291_cov_2.348624_g8743_i0 PRJEB36940 8872 291 2.348624 6.83449584 Candidatus Nanosynbacter sp. HMT-348_TM7c-JB 2933970 Bacteria Bacteria 388 1.81e-103   NTclustered gi|2179907571|gb|CP090820.1| 2933970 g8743 i0 90.753 121.742268041237 292 25 100 2 1 291 138396 138106 MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome blastn 35427 388 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota Candidatus Saccharimonadia Candidatus Nanosynbacterales Candidatus Nanosynbacteraceae Candidatus Nanosynbacter Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
23941328 23941328 PRJEB36940_P_NODE_11659_length_258_cov_1.908108_g11530_i0 PRJEB36940 11659 258 1.908108 4.92291864 Candidatus Mycosynbacter 2831665 Bacteria Bacteria 370 5.71e-98   NTclustered gi|1842054184|gb|CP039999.1| 713059 g11530 i0 92.664 58.2015503875969 259 16 100 3 1 258 143733 143989 Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome blastn 15016 372 0.99462365591397806 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium oral taxon 488

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);;