RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB15333" and tax_phylum = "Fusobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Fusobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJEB15333 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
1295809 1295809 PRJEB15333_P_NODE_17442_length_168_cov_0.873950_g17358_i0 PRJEB15333 17442 168 0.87395 1.468236 Cetobacterium somerae 188913 Bacteria Bacteria 307 2.73e-79   NTclustered gi|2201062197|gb|CP092519.1| 188913 g17358 i0 100 4.94047619047619 166 0 99 0 3 168 398466 398301 Cetobacterium somerae strain CS2105-BJ chromosome, complete genome blastn 830 307 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
7363536 7363536 PRJEB15333_P_NODE_7326_length_246_cov_2.030457_g7242_i0 PRJEB15333 7326 246 2.030457 4.99492422 Cetobacterium 180162 Bacteria Bacteria 418 1.9e-112   NTclustered gi|2666488225|gb|CP143319.1| 188913 g7242 i0 97.925 12.719512195122 241 5 98 0 6 246 1904292 1904052 Cetobacterium somerae strain ceto chromosome, complete genome blastn 3129 418 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
8638927 8638927 PRJEB15333_P_NODE_20687_length_162_cov_0.920354_g20603_i0 PRJEB15333 20687 162 0.920354 1.49097348 Cetobacterium 180162 Bacteria Bacteria 283 4.39e-72   NTclustered gi|2666488225|gb|CP143319.1| 188913 g20603 i0 98.148 19 162 3 100 0 1 162 1906275 1906436 Cetobacterium somerae strain ceto chromosome, complete genome blastn 3078 283 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
9914003 9914003 PRJEB15333_P_NODE_19588_length_164_cov_0.904348_g19504_i0 PRJEB15333 19588 164 0.904348 1.48313072 Cetobacterium 180162 Bacteria Bacteria 195 2.15e-45   NTclustered gi|2666488225|gb|CP143319.1| 188913 g19504 i0 89.375 7.8780487804878 160 9 98 3 3 162 872117 871966 Cetobacterium somerae strain ceto chromosome, complete genome blastn 1292 195 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
14049746 14049746 PRJEB15333_P_NODE_17512_length_168_cov_0.873950_g17428_i0 PRJEB15333 17512 168 0.87395 1.468236 Cetobacterium somerae 188913 Bacteria Bacteria 305 9.81e-79   NTclustered gi|2201062197|gb|CP092519.1| 188913 g17428 i0 100 6.875 165 0 98 0 4 168 1769118 1769282 Cetobacterium somerae strain CS2105-BJ chromosome, complete genome blastn 1155 305 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
18837643 18837643 PRJEB15333_P_NODE_21035_length_160_cov_2.099099_g20951_i0 PRJEB15333 21035 160 2.099099 3.3585584 Cetobacterium 180162 Bacteria Bacteria 263 5.629999999999999e-66   NTclustered gi|2666488225|gb|CP143319.1| 188913 g20951 i0 96.273 5.03125 161 5 100 1 1 160 1303567 1303407 Cetobacterium somerae strain ceto chromosome, complete genome blastn 805 263 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
21698327 21698327 PRJEB15333_P_NODE_17518_length_168_cov_0.873950_g17434_i0 PRJEB15333 17518 168 0.87395 1.468236 Cetobacterium somerae 188913 Bacteria Bacteria 311 2.11e-80   NTclustered gi|2201062197|gb|CP092519.1| 188913 g17434 i0 100 5 168 0 100 0 1 168 587102 586935 Cetobacterium somerae strain CS2105-BJ chromosome, complete genome blastn 840 311 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae

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