RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA724039" 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 · 5 ✖

bioproject 1

  • PRJNA724039 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
9639676 9639676 PRJNA724039_S_NODE_3328_length_399_cov_35.190608_g3121_i0 PRJNA724039 3328 399 35.190608 140.41052592 Candidatus Binatia bacterium 2838779 Bacteria Bacteria 516 1.13e-141   NTclustered gi|2814788338|emb|OY761159.2| 2838779 g3121 i0 90.025 231.022556390977 401 36 100 4 1 399 3737401 3737799 MAG: Candidatus Binatia bacterium isolate a3054953-5fa8-48fb-90a5-e173aac96f7a genome assembly, chromosome: 1 blastn 92178 516 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia       Candidatus Binatia bacterium
10122659 10122659 PRJNA724039_S_NODE_16448_length_157_cov_1.891667_g16241_i0 PRJNA724039 16448 157 1.891667 2.96991719 Bacteria 2 Bacteria Bacteria 158 2.67e-34   NTclustered gi|2621785934|emb|OY782392.1| 2052139 g16241 i0 85 123.872611464968 160 19 100 4 1 157 427713 427870 MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1 blastn 19448 158 1 Bacteria Bacteria candidate phyla             Patescibacteria group bacterium
10122662 10122662 PRJNA724039_S_NODE_17068_length_154_cov_2.888889_g16861_i0 PRJNA724039 17068 154 2.888889 4.44888906 Pseudomonadati 3379134 Bacteria Bacteria 121 3.4199999999999996e-23   NTclustered gi|2518551991|emb|OX638351.1| 265321 g16861 i0 94.805 135.876623376623 77 4 50 0 1 77 592208 592284 MAG: uncultured Poribacteria bacterium isolate d4690918-7cf6-4b6d-bcb0-07eb3c50a363 genome assembly, chromosome: 1 blastn 20925 121 1 Bacteria Bacteria candidate phyla   Candidatus Poribacteria         uncultured Poribacteria bacterium
18562836 18562836 PRJNA724039_S_NODE_14115_length_170_cov_1.744361_g13908_i0 PRJNA724039 14115 170 1.744361 2.9654137 Candidatus Peribacteria bacterium 2053688 Bacteria Bacteria 171 3.7599999999999997e-38   NTclustered gi|2258833497|gb|CP060226.1| 2053688 g13908 i0 89.051 423.005882352941 137 15 81 0 1 137 813989 814125 MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome blastn 71911 171 1 Bacteria Bacteria candidate phyla   Candidatus Peregrinibacteriota Candidatus Peribacteria       Candidatus Peribacteria bacterium
24937808 24937808 PRJNA724039_S_NODE_9780_length_208_cov_4.397661_g9573_i0 PRJNA724039 9780 208 4.397661 9.14713488 uncultured Candidatus Binatia bacterium 3036252 Bacteria Bacteria 313 7.569999999999998e-81   NTclustered gi|2531949172|emb|OY282457.1| 3036252 g9573 i0 94.146 47.7451923076923 205 12 99 0 2 206 988585 988381 MAG: uncultured Candidatus Binatia bacterium genome assembly, chromosome: 1 blastn 9931 313 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia       uncultured Candidatus Binatia 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);;