RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA493632" 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

  • PRJNA493632 · 4 ✖

analysis 1

  • diamond · 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
23413858 23413858 PRJNA493632_P_NODE_311719_length_291_cov_4.330275_g308280_i0 PRJNA493632 311719 291 4.330275 12.60110025 Leptotrichia sp. oral taxon 879 1227267 Bacteria Bacteria 128 4.82e-32   NR WP_039901453.1 1227267 g308280 i0 63.5 0.989690721649485 96 35 99 0 290 3 2070 2165 WP_039901453.1 autotransporter-associated N-terminal domain-containing protein [Leptotrichia sp. oral taxon 879] diamond 288 128 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 879
28640116 28640116 PRJNA493632_P_NODE_556247_length_248_cov_0.880000_g552808_i0 PRJNA493632 556247 248 0.88 2.1824 Sebaldella 32068 Bacteria Bacteria 89 1.69e-20   NR MBP9479032.1 2819260 g552808 i0 56.2 3.54435483870968 73 32 88.3 0 220 2 3 75 MBP9479032.1 cytidine deaminase [Sebaldella sp.] diamond 879 89 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Sebaldella Sebaldella sp.
31040613 31040613 PRJNA493632_P_NODE_675815_length_236_cov_2.668712_g672374_i0 PRJNA493632 675815 236 2.668712 6.29816032 root 1 Root_unresolved Root_unresolved 85.5 1.58e-17   NR WP_394292705.1 859 g672374 i0 71 2.36440677966102 62 18 78.8 0 1 186 21 82 WP_394292705.1 hypothetical protein [Fusobacterium necrophorum] diamond 558 85.5 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium necrophorum
32258255 32258255 PRJNA493632_P_NODE_250958_length_314_cov_1.278008_g247522_i0 PRJNA493632 250958 314 1.278008 4.01294512 Leptotrichia sp. 104608 Bacteria Bacteria 106 6.59e-25   NR MBF1334113.1 104608 g247522 i0 74.3 0.707006369426752 74 18 69.7 1 223 5 253 326 MBF1334113.1 hypothetical protein [Leptotrichia sp.] diamond 222 106 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp.

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