RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1093380 · 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
4025689 4025689 PRJNA1093380_P_NODE_1104_length_526_cov_4.249448_g1001_i0 PRJNA1093380 1104 526 4.249448 22.35209648 Candidatus Aminicenantes bacterium 2052149 Bacteria Bacteria 375 2.7e-99   NTclustered gi|2874253743|emb|OY969586.1| 2052149 g1001 i0 79.887 116.790874524715 532 91 100 15 1 526 2019138 2018617 MAG: Candidatus Aminicenantes bacterium isolate MFD10007.bin.c.2 genome assembly, chromosome: 1 blastn 61432 375 1 Bacteria Bacteria candidate phyla   Candidatus Aminicenantota         Candidatus Aminicenantes bacterium
16776157 16776157 PRJNA1093380_P_NODE_11974_length_251_cov_0.865169_g11868_i0 PRJNA1093380 11974 251 0.865169 2.17157419 Candidatus Eiseniibacteriota bacterium 2212470 Bacteria Bacteria 436 5.369999999999999e-118   NTclustered gi|2874253817|emb|OY969801.1| 2212470 g11868 i0 98.016 243.717131474104 252 4 100 1 1 251 738751 739002 MAG: Candidatus Eisenbacteria bacterium isolate MFD10007.bin.c.4 genome assembly, chromosome: 1 blastn 61173 436 1 Bacteria Bacteria candidate phyla   Candidatus Eiseniibacteriota         Candidatus Eiseniibacteriota bacterium
16776245 16776245 PRJNA1093380_P_NODE_1874_length_415_cov_1.125731_g1768_i0 PRJNA1093380 1874 415 1.125731 4.67178365 Candidatus Eiseniibacteriota bacterium 2212470 Bacteria Bacteria 673 0   NTclustered gi|2874253817|emb|OY969801.1| 2212470 g1768 i0 95.904 311.028915662651 415 17 100 0 1 415 738611 738197 MAG: Candidatus Eisenbacteria bacterium isolate MFD10007.bin.c.4 genome assembly, chromosome: 1 blastn 129077 673 1 Bacteria Bacteria candidate phyla   Candidatus Eiseniibacteriota         Candidatus Eiseniibacteriota bacterium
18050712 18050712 PRJNA1093380_P_NODE_10055_length_261_cov_2.505319_g9949_i0 PRJNA1093380 10055 261 2.505319 6.53888259 Candidatus Eiseniibacteriota bacterium 2212470 Bacteria Bacteria 411 3.409999999999999e-110   NTclustered gi|2874253817|emb|OY969801.1| 2212470 g9949 i0 95.019 129.578544061303 261 13 100 0 1 261 737655 737395 MAG: Candidatus Eisenbacteria bacterium isolate MFD10007.bin.c.4 genome assembly, chromosome: 1 blastn 33820 411 1 Bacteria Bacteria candidate phyla   Candidatus Eiseniibacteriota         Candidatus Eiseniibacteriota bacterium
20600249 20600249 PRJNA1093380_P_NODE_5617_length_287_cov_2.303738_g5511_i0 PRJNA1093380 5617 287 2.303738 6.61172806 Candidatus Saccharibacteria bacterium oral taxon 488 713059 Bacteria Bacteria 518 2.18e-142   NTclustered gi|1842065531|gb|CP040002.1| 713059 g5511 i0 99.301 6.97560975609756 286 2 99 0 2 287 761284 760999 Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome blastn 2002 518 1 Bacteria Bacteria candidate phyla   Candidatus Saccharimonadota         Candidatus Saccharibacteria bacterium oral taxon 488

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