RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1095825" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 5 ✖

bioproject 1

  • PRJNA1095825 · 5 ✖

analysis 1

  • blastn · 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
1019468 1019468 PRJNA1095825_P_NODE_250941_length_249_cov_0.875000_g247878_i0 PRJNA1095825 250941 249 0.875 2.17875 Fusobacterium 848 Bacteria Bacteria 438 1.4799999999999996e-118   NTclustered gi|1370537877|gb|CP028108.1| 860 g247878 i0 98.394 100 249 4 100 0 1 249 1721250 1721002 Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome blastn 24900 438 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
2294734 2294734 PRJNA1095825_P_NODE_126182_length_343_cov_0.948148_g123119_i0 PRJNA1095825 126182 343 0.948148 3.25214764 Fusobacterium 848 Bacteria Bacteria 612 1.19e-170   NTclustered gi|1721134154|emb|LR698955.1| 851 g123119 i0 98.834 479.148688046647 343 4 100 0 1 343 83063 83405 Fusobacterium nucleatum isolate MGYG-HGUT-01347 genome assembly, chromosome: 1 blastn 164348 617 0.991896272285251 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
21421677 21421677 PRJNA1095825_P_NODE_52377_length_527_cov_1.515419_g49320_i0 PRJNA1095825 52377 527 1.515419 7.98625813 Fusobacterium 848 Bacteria Bacteria 946 0   NTclustered gi|1370537877|gb|CP028108.1| 860 g49320 i0 99.051 475.003795066414 527 5 100 0 1 527 463047 462521 Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome blastn 250327 952 0.993697478991597 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
22696502 22696502 PRJNA1095825_P_NODE_272118_length_245_cov_0.895349_g269055_i0 PRJNA1095825 272118 245 0.895349 2.19360505 Fusobacterium 848 Bacteria Bacteria 56.5 0.002   NTclustered gi|2573686249|gb|CP133474.1| 851 g269055 i0 97.059 4.85714285714286 34 0 14 1 64 97 169396 169364 Fusobacterium nucleatum strain LMG 13131 chromosome, complete genome blastn 1190 56.5 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum
25245678 25245678 PRJNA1095825_P_NODE_127360_length_341_cov_1.638060_g124297_i0 PRJNA1095825 127360 341 1.63806 5.5857846 Fusobacterium 848 Bacteria Bacteria 592 1.54e-164   NTclustered gi|1890959825|gb|CP060112.1| 1583098 g124297 i0 97.947 473.686217008798 341 7 100 0 1 341 2195953 2196293 Fusobacterium hwasookii strain KCOM 1249 chromosome, complete genome blastn 161527 597 0.991624790619765 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium hwasookii

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