RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA666695" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 3 ✖

bioproject 1

  • PRJNA666695 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
1909416 1909416 PRJNA666695_S_NODE_78822_length_244_cov_3.625616_g77728_i0 PRJNA666695 78822 244 3.625616 8.84650304 Haliovirga abyssi 2996794 Bacteria Bacteria 54.7 0.006   NTclustered gi|2502752323|dbj|AP027059.1| 2996794 g77728 i0 96.875 0.131147540983607 32 1 13 0 163 194 937381 937412 Fusobacteria bacterium IC12 DNA, complete genome blastn 32 54.7 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Haliovirgaceae Haliovirga Haliovirga abyssi
3182989 3182989 PRJNA666695_S_NODE_28483_length_363_cov_5.736025_g27390_i0 PRJNA666695 28483 363 5.736025 20.82177075 Fusobacterium animalis 76859 Bacteria Bacteria 52.8 0.034   NTclustered gi|2706431087|gb|CP077150.1| 76859 g27390 i0 100 0.154269972451791 28 0 8 0 311 338 1681324 1681351 Fusobacterium animalis strain KCOM1280 chromosome, complete genome blastn 56 52.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium animalis
5736387 5736387 PRJNA666695_S_NODE_65085_length_264_cov_4.125561_g63991_i0 PRJNA666695 65085 264 4.125561 10.89148104 Leptotrichia wadei 157687 Bacteria Bacteria 488 1.5499999999999999e-133   NTclustered gi|1708575239|dbj|AP019834.1| 157687 g63991 i0 100 291.94696969697 264 0 100 0 1 264 221664 221927 Leptotrichia wadei JMUB3933 DNA, complete genome blastn 77074 488 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei

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