RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA890871" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 6 ✖

bioproject 1

  • PRJNA890871 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
4693480 4693480 PRJNA890871_P_NODE_70284_length_248_cov_0.880000_g70149_i0 PRJNA890871 70284 248 0.88 2.1824 Leptotrichia sp. oral taxon 847 1785996 Bacteria Bacteria 442 1.1399999999999995e-119   NTclustered gi|987458696|gb|CP014231.1| 1785996 g70149 i0 98.79 7.85483870967742 248 3 100 0 1 248 933963 933716 Leptotrichia sp. oral taxon 847 strain F0260 chromosome, complete genome blastn 1948 442 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 847
15270271 15270271 PRJNA890871_P_NODE_2572_length_1000_cov_4.993528_g2453_i0 PRJNA890871 2572 1000 4.993528 49.93528 Fusobacterium 848 Bacteria Bacteria 54.7 0.028   NTclustered gi|2705015041|gb|CP084068.1| 856 g2453 i0 100 0.087 29 0 3 0 362 390 1799294 1799322 Fusobacterium varium strain SB064 chromosome, complete genome blastn 87 54.7 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium varium
16167658 16167658 PRJNA890871_P_NODE_64433_length_250_cov_1.768362_g64298_i0 PRJNA890871 64433 250 1.768362 4.420905 Leptotrichia wadei 157687 Bacteria Bacteria 387 5.459999999999998e-103   NTclustered gi|1791353085|dbj|AP019829.2| 157687 g64298 i0 96.186 13.14 236 9 94 0 1 236 2015573 2015338 Leptotrichia wadei JCM16777 DNA, complete genome blastn 3285 387 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
21266685 21266685 PRJNA890871_P_NODE_51897_length_264_cov_1.549738_g51762_i0 PRJNA890871 51897 264 1.549738 4.0913083200000004 Cetobacterium somerae 188913 Bacteria Bacteria 52.8 0.024   NTclustered gi|2666490969|gb|CP143322.1| 188913 g51762 i0 100 0.106060606060606 28 0 11 0 169 196 4188 4215 Cetobacterium somerae strain ceto plasmid p3, complete sequence blastn 28 52.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium Cetobacterium somerae
21267447 21267447 PRJNA890871_P_NODE_93737_length_205_cov_4.128788_g93602_i0 PRJNA890871 93737 205 4.128788 8.4640154 Fusobacterium pseudoperiodonticum 2663009 Bacteria Bacteria 351 1.58e-92   NTclustered gi|1276712381|gb|CP024701.1| 2663009 g93602 i0 97.561 1 205 5 100 0 1 205 160785 160581 Fusobacterium pseudoperiodonticum strain KCOM 1277 chromosome, complete genome blastn 205 351 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium pseudoperiodonticum
21644814 21644814 PRJNA890871_P_NODE_65677_length_250_cov_0.870056_g65542_i0 PRJNA890871 65677 250 0.870056 2.17514 root 1 Root_unresolved Root_unresolved 462 8.83e-126   NTclustered gi|2446175567|gb|CP117964.1| 851 g65542 i0 100 50.384 250 0 100 0 1 250 2402229 2402478 Fusobacterium nucleatum strain 2/1/50A chromosome, complete genome blastn 12596 462 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium nucleatum

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