RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1104180 · 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
1487126 1487126 PRJNA1104180_P_NODE_27782_length_226_cov_2.013072_g27639_i0 PRJNA1104180 27782 226 2.013072 4.54954272 Candidatus Aminicenantes bacterium 2052149 Bacteria Bacteria 189 1.4699999999999999e-43   NTclustered gi|2874253756|emb|OY969696.1| 2052149 g27639 i0 82.301 164.898230088496 226 33 99 7 1 223 971270 971491 MAG: Candidatus Aminicenantes bacterium isolate MFD04408.bin.1.14 genome assembly, chromosome: 1 blastn 37267 189 1 Bacteria Bacteria candidate phyla   Candidatus Aminicenantota         Candidatus Aminicenantes bacterium
5315090 5315090 PRJNA1104180_P_NODE_11165_length_306_cov_1.287554_g11023_i0 PRJNA1104180 11165 306 1.287554 3.93991524 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 505 1.8199999999999998e-138   NTclustered gi|1474570736|gb|CP023991.1| 2026720 g11023 i0 96.417 195.529411764706 307 10 100 1 1 306 883813 884119 Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome blastn 59832 505 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota bacterium
6590355 6590355 PRJNA1104180_P_NODE_15886_length_272_cov_2.125628_g15744_i0 PRJNA1104180 15886 272 2.125628 5.78170816 Candidatus Saccharibacteria bacterium RAAC3_TM7_1 1394711 Bacteria Bacteria 204 6.509999999999999e-48   NTclustered gi|563353835|gb|CP006915.1| 1394711 g15744 i0 80.435 1.01470588235294 276 46 100 7 1 272 144628 144899 Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome blastn 276 204 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium RAAC3_TM7_1
11691217 11691217 PRJNA1104180_P_NODE_7730_length_349_cov_1.380435_g7588_i0 PRJNA1104180 7730 349 1.380435 4.81771815 Candidatus Saccharibacteria bacterium oral taxon 488 713059 Bacteria Bacteria 640 5.529999999999999e-179   NTclustered gi|1842065531|gb|CP040002.1| 713059 g7588 i0 99.713 216.289398280802 349 1 100 0 1 349 150086 149738 Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome blastn 75485 640 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium oral taxon 488
14241236 14241236 PRJNA1104180_P_NODE_25712_length_242_cov_0.911243_g25569_i0 PRJNA1104180 25712 242 0.911243 2.20520806 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 351 1.92e-92   NTclustered gi|1474570736|gb|CP023991.1| 2026720 g25569 i0 92.975 135.057851239669 242 15 99 2 3 242 882250 882491 Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome blastn 32684 351 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharimonadota 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);;