RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJEB83101" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJEB83101 · 5 ✖

analysis 1

  • diamond · 5 ✖

tax_clade 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
27034287 27034287 PRJEB83101_P_NODE_47562_length_280_cov_1.864734_g47257_i0 PRJEB83101 47562 280 1.864734 5.2212552 Arcobacter cloacae 1054034 Bacteria Bacteria 52.4 2.06e-5   NR WP_129013981.1 1054034 g47257 i0 61.5 0.835714285714286 39 15 41.8 0 5 121 255 293 WP_129013981.1 hypothetical protein [Arcobacter cloacae] diamond 234 52.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter cloacae
27539978 27539978 PRJEB83101_P_NODE_84964_length_242_cov_2.585799_g84659_i0 PRJEB83101 84964 242 2.585799 6.25763358 Helicobacter pylori 210 Bacteria Bacteria 60.1 1.32e-9   NR GAA8686254.1 210 g84659 i0 100 0.384297520661157 31 0 38.4 0 117 25 1 31 GAA8686254.1 hypothetical protein Kyoto145A_1480 [Helicobacter pylori] diamond 93 60.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28708264 28708264 PRJEB83101_P_NODE_57807_length_263_cov_1.957895_g57502_i0 PRJEB83101 57807 263 1.957895 5.14926385 Desulfurellales bacterium 2482794 Bacteria Bacteria 120 3.7199999999999997e-32   NR TXH50932.1 2482794 g57502 i0 64.7 0.96958174904943 85 30 97 0 257 3 20 104 TXH50932.1 MAG: HNH endonuclease [Desulfurellales bacterium] diamond 255 120 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
29213540 29213540 PRJEB83101_P_NODE_56069_length_266_cov_1.492228_g55764_i0 PRJEB83101 56069 266 1.492228 3.96932648 Campylobacter majalis 2790656 Bacteria Bacteria 135 3.67e-39   NR CAD7289866.1 2790656 g55764 i0 97.3 0.845864661654135 75 2 84.6 0 225 1 1 75 CAD7289866.1 hypothetical protein LMG7974_01952 [Campylobacter majalis] diamond 225 135 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter majalis
30065807 30065807 PRJEB83101_P_NODE_24232_length_373_cov_2.623333_g23927_i0 PRJEB83101 24232 373 2.623333 9.78503209 Helicobacter pylori 210 Bacteria Bacteria 61.6 1.83e-9   NR GAA6799321.1 210 g23927 i0 100 0.20911528150134 26 0 20.9 0 346 269 1 26 GAA6799321.1 hypothetical protein Kyoto200A_1680 [Helicobacter pylori] diamond 78 61.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori

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