RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA902848 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
4710439 4710439 PRJNA902848_P_NODE_12344_length_259_cov_1.672043_g12294_i0 PRJNA902848 12344 259 1.672043 4.33059137 Candidatus Eiseniibacteriota bacterium 2212470 Bacteria Bacteria 222 1.6999999999999998e-53   NTclustered gi|2874253817|emb|OY969801.1| 2212470 g12294 i0 84.581 5.40540540540541 227 31 86 4 36 259 1399988 1400213 MAG: Candidatus Eisenbacteria bacterium isolate MFD10007.bin.c.4 genome assembly, chromosome: 1 blastn 1400 222 1 Bacteria Bacteria candidate phyla   Candidatus Eiseniibacteriota         Candidatus Eiseniibacteriota bacterium
9810076 9810076 PRJNA902848_P_NODE_7968_length_312_cov_1.305439_g7918_i0 PRJNA902848 7968 312 1.305439 4.07296968 Candidatus Nomurabacteria bacterium 2052152 Bacteria Bacteria 344 4.2999999999999985e-90   NTclustered gi|1958028780|gb|CP064973.1| 2052152 g7918 i0 88.732 4.22115384615385 284 29 91 2 9 292 393923 393643 MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome blastn 1317 344 1 Bacteria Bacteria candidate phyla   Candidatus Nomuraibacteriota         Candidatus Nomurabacteria bacterium
17460132 17460132 PRJNA902848_P_NODE_15534_length_249_cov_0.886364_g15484_i0 PRJNA902848 15534 249 0.886364 2.20704636 Candidatus Eiseniibacteriota bacterium 2212470 Bacteria Bacteria 259 1.24e-64   NTclustered gi|2874254095|emb|OY970178.1| 2212470 g15484 i0 85.6 1.00401606425703 250 33 99 3 2 249 1887652 1887404 MAG: Candidatus Eisenbacteria bacterium isolate MFD05942.bin.c.1 genome assembly, chromosome: 1 blastn 250 259 1 Bacteria Bacteria candidate phyla   Candidatus Eiseniibacteriota         Candidatus Eiseniibacteriota bacterium
23833999 23833999 PRJNA902848_P_NODE_12159_length_261_cov_1.579787_g12109_i0 PRJNA902848 12159 261 1.579787 4.12324407 Candidatus Parcubacteria bacterium 2762014 Bacteria Bacteria 189 1.7399999999999999e-43   NTclustered gi|2650368334|dbj|AP029158.1| 2762014 g12109 i0 79.848 1.00766283524904 263 49 100 4 1 261 683424 683164 MAG: Candidatus Parcubacteria bacterium ADS-1 DNA, complete genome blastn 263 189 1 Bacteria Bacteria candidate phyla   Candidatus Parcubacteria         Candidatus Parcubacteria 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);;