RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA763243 · 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
5846746 5846746 PRJNA763243_P_NODE_36205_length_287_cov_1.378505_g35859_i0 PRJNA763243 36205 287 1.378505 3.95630935 Candidatus Babeliales bacterium 2803731 Bacteria Bacteria 268 2.42e-67   NTclustered gi|2874253748|emb|OY969622.1| 2803731 g35859 i0 83.793 73.8292682926829 290 40 99 5 2 287 457728 457442 MAG: Candidatus Babeliales bacterium isolate MFD04434.bin.c.2 genome assembly, chromosome: 1 blastn 21189 268 1 Bacteria Bacteria candidate phyla     Candidatus Babeliae Candidatus Babeliales     Candidatus Babeliales bacterium
9671189 9671189 PRJNA763243_P_NODE_18348_length_366_cov_4.634812_g18003_i0 PRJNA763243 18348 366 4.634812 16.96341192 Candidatus Saccharibacteria bacterium TM7i 2980174 Bacteria Bacteria 599 9.899999999999997e-167   NTclustered gi|2306681518|gb|CP075337.1| 2980174 g18003 i0 96.429 141.043715846995 364 12 99 1 1 363 667437 667800 Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome blastn 51622 599 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium TM7i
16045731 16045731 PRJNA763243_P_NODE_30993_length_305_cov_4.745690_g30647_i0 PRJNA763243 30993 305 4.74569 14.4743545 Candidatus Babela massiliensis 673862 Bacteria Bacteria 97.1 1.3e-15   NTclustered gi|563405083|emb|HG793133.1| 673862 g30647 i0 76.768 1.23606557377049 198 30 62 10 109 296 294212 294021 Candidatus Babela massiliensis strain BABL1 complete genome blastn 377 97.1 1 Bacteria Bacteria candidate phyla     Candidatus Babeliae Candidatus Babeliales Candidatus Babeliaceae Candidatus Babela Candidatus Babela massiliensis
18595503 18595503 PRJNA763243_P_NODE_64275_length_240_cov_5.970060_g63929_i0 PRJNA763243 64275 240 5.97006 14.328144 Candidatus Saccharimonadota bacterium 2026720 Bacteria Bacteria 222 1.55e-53   NTclustered gi|1474570736|gb|CP023991.1| 2026720 g63929 i0 83.966 743.9375 237 32 98 6 4 237 885237 885470 Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome blastn 178545 222 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);;