RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJDB14275" 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

  • PRJDB14275 · 4 ✖

analysis 1

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
8645 8645 PRJDB14275_P_NODE_6341_length_183_cov_1.812500_g6282_i0 PRJDB14275 6341 183 1.8125 3.316875 Leptotrichia sp. SK-5 3075818 Bacteria Bacteria 327 2.31e-85   NTclustered gi|2899356158|dbj|AP028931.1| 3075818 g6282 i0 98.907 431.786885245902 183 2 100 0 1 183 262895 262713 Leptotrichia sp. SK-5 DNA, complete genome blastn 79017 327 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. SK-5
5111027 5111027 PRJDB14275_P_NODE_4985_length_226_cov_1.737968_g4926_i0 PRJDB14275 4985 226 1.737968 3.92780768 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 401 1.7299999999999993e-107   NTclustered gi|922689899|gb|CP012410.1| 712357 g4926 i0 98.673 29.2433628318584 226 3 100 0 1 226 51868 52093 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 6609 401 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
8935572 8935572 PRJDB14275_P_NODE_3568_length_305_cov_2.112782_g3509_i0 PRJDB14275 3568 305 2.112782 6.4439851 Leptotrichia sp. HMT-225 3058373 Bacteria Bacteria 564 2.95e-156   NTclustered gi|2557559843|gb|CP130323.1| 3058373 g3509 i0 100 400.996721311475 305 0 100 0 1 305 198203 197899 Leptotrichia sp. HMT-225 chromosome, complete genome blastn 122304 564 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. HMT-225
21685201 21685201 PRJDB14275_P_NODE_6518_length_179_cov_2.242857_g6459_i0 PRJDB14275 6518 179 2.242857 4.01471403 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 296 6.34e-76   NTclustered gi|922689899|gb|CP012410.1| 712357 g6459 i0 100 11.3240223463687 160 0 89 0 20 179 51583 51742 Leptotrichia sp. oral taxon 212 strain W10393, complete genome blastn 2027 296 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212

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