RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA741997" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 4 ✖

bioproject 1

  • PRJNA741997 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
721592 721592 PRJNA741997_P_NODE_64921_length_266_cov_2.113990_g63801_i0 PRJNA741997 64921 266 2.11399 5.6232134 Cetobacterium somerae 188913 Bacteria Bacteria 265 2.87e-66   NTclustered gi|2850953754|gb|CP173062.1| 1319815 g63801 i0 84.644 5.01503759398496 267 39 100 2 1 266 681438 681703 Cetobacterium somerae ATCC BAA-474 plasmid unnamed01 blastn 1334 265 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
10126815 10126815 PRJNA741997_P_NODE_55628_length_288_cov_0.888372_g54508_i0 PRJNA741997 55628 288 0.888372 2.55851136 Fusobacterium 848 Bacteria Bacteria 532 7.8e-147   NTclustered gi|2706496642|gb|CP084152.1| 76857 g54508 i0 100 489.017361111111 288 0 100 0 1 288 627102 626815 Fusobacterium polymorphum strain KCOM2594 chromosome, complete genome blastn 140837 532 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium polymorphum
10925576 10925576 PRJNA741997_P_NODE_77069_length_248_cov_0.880000_g75949_i0 PRJNA741997 77069 248 0.88 2.1824 Cetobacterium somerae 188913 Bacteria Bacteria 449 6.81e-122   NTclustered gi|2666488225|gb|CP143319.1| 188913 g75949 i0 99.593 8.21370967741935 246 1 99 0 3 248 1368767 1369012 Cetobacterium somerae strain ceto chromosome, complete genome blastn 2037 449 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
11401866 11401866 PRJNA741997_P_NODE_6689_length_1045_cov_1.654321_g5901_i0 PRJNA741997 6689 1045 1.654321 17.28765445 Cetobacterium 180162 Bacteria Bacteria 1903 0   NTclustered gi|2865368125|gb|CP122294.1| 188913 g5901 i0 99.522 523.065071770335 1045 5 100 0 1 1045 278673 279717 Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence blastn 546603 1903 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);;