RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA438111 · 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
2985077 2985077 PRJNA438111_P_NODE_58183_length_173_cov_2.763889_g57558_i0 PRJNA438111 58183 173 2.763889 4.78152797 Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 1619070 Bacteria Bacteria 320 3.61e-83   NTclustered gi|837350690|gb|CP011211.1| 1619070 g57558 i0 100 1 173 0 100 0 1 173 446083 446255 Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome blastn 173 320 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
4261661 4261661 PRJNA438111_P_NODE_75924_length_161_cov_1.075758_g75299_i0 PRJNA438111 75924 161 1.075758 1.73197038 uncultured Candidatus Saccharibacteria bacterium 179883 Bacteria Bacteria 154 3.5600000000000004e-33   NTclustered gi|2874253997|emb|OY970322.1| 179883 g75299 i0 84.472 90.7826086956522 161 20 99 4 1 159 778507 778664 MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05512.bin.c.2 genome assembly, chromosome: 1 blastn 14616 154 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         uncultured Candidatus Saccharibacteria bacterium
4261692 4261692 PRJNA438111_P_NODE_78004_length_159_cov_3.838462_g77379_i0 PRJNA438111 78004 159 3.838462 6.10315458 Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17 1619070 Bacteria Bacteria 294 1.98e-75   NTclustered gi|837350690|gb|CP011211.1| 1619070 g77379 i0 100 1.33333333333333 159 0 100 0 1 159 842032 841874 Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome blastn 212 294 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
5538518 5538518 PRJNA438111_P_NODE_89245_length_151_cov_2.877049_g88620_i0 PRJNA438111 89245 151 2.877049 4.34434399 Candidatus Binatia bacterium 2838779 Bacteria Bacteria 102 1.21e-17   NTclustered gi|2814788387|emb|OY762897.2| 2838779 g88620 i0 89.024 0.543046357615894 82 9 54 0 14 95 3316815 3316896 MAG: Candidatus Binatia bacterium isolate 08c4157d-86a7-49cc-8b26-f3076a3ae996 genome assembly, chromosome: 1 blastn 82 102 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia       Candidatus Binatia bacterium
9362051 9362051 PRJNA438111_P_NODE_32348_length_210_cov_3.425414_g31723_i0 PRJNA438111 32348 210 3.425414 7.1933694 candidate division SR1 bacterium RAAC1_SR1_1 1394709 Bacteria Bacteria 130 8.280000000000001e-26   NTclustered gi|563351663|gb|CP006913.1| 1394709 g31723 i0 90 3.59047619047619 100 10 48 0 1 100 29885 29786 Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome blastn 754 130 1 Bacteria Bacteria candidate phyla   Candidatus Absconditibacteriota         candidate division SR1 bacterium RAAC1_SR1_1

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