RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA674308" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 7 ✖

bioproject 1

  • PRJNA674308 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
27018493 27018493 PRJNA674308_P_NODE_12442_length_272_cov_1.242152_g12207_i0 PRJNA674308 12442 272 1.242152 3.37865344 Leptotrichia hongkongensis 554406 Bacteria Bacteria 41.6 0.026   NR WP_147005239.1 554406 g12207 i0 31 0.639705882352941 58 40 64 0 212 39 6 63 WP_147005239.1 hypothetical protein [Leptotrichia hongkongensis] diamond 174 41.6 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia hongkongensis
27144604 27144604 PRJNA674308_P_NODE_53362_length_162_cov_0.920354_g53127_i0 PRJNA674308 53362 162 0.920354 1.49097348 Leptotrichia sp. oral taxon 212 712357 Bacteria Bacteria 108 1.89e-26   NR WP_172673340.1 712357 g53127 i0 96.3 1 54 2 100 0 1 162 127 180 WP_172673340.1 [FeFe] hydrogenase H-cluster radical SAM maturase HydE [Leptotrichia sp. oral taxon 212] diamond 162 108 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 212
27271438 27271438 PRJNA674308_P_NODE_38563_length_168_cov_0.873950_g38328_i0 PRJNA674308 38563 168 0.87395 1.468236 Leptotrichia sp. oral taxon 215 712359 Bacteria Bacteria 111 1.03e-26   NR WP_021767488.1 712359 g38328 i0 96.4 1 56 2 100 0 168 1 90 145 WP_021767488.1 alpha-amylase family glycosyl hydrolase [Leptotrichia sp. oral taxon 215] diamond 168 111 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 215
28976708 28976708 PRJNA674308_P_NODE_49968_length_163_cov_0.912281_g49733_i0 PRJNA674308 49968 163 0.912281 1.48701803 Leptotrichia sp. oral taxon 215 712359 Bacteria Bacteria 101 1.29e-25   NR WP_021766118.1 712359 g49733 i0 92.6 0.993865030674847 54 4 99.4 0 2 163 89 142 WP_021766118.1 divergent PAP2 family protein [Leptotrichia sp. oral taxon 215] diamond 162 101 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 215
31946571 31946571 PRJNA674308_P_NODE_41177_length_167_cov_0.881356_g40942_i0 PRJNA674308 41177 167 0.881356 1.47186452 Leptotrichia sp. oral taxon 215 712359 Bacteria Bacteria 42 0.0226   NR WP_021766636.1 712359 g40942 i0 85.7 0.377245508982036 21 3 37.7 0 166 104 200 220 WP_021766636.1 Fic family protein [Leptotrichia sp. oral taxon 215] diamond 63 42 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 215
31946575 31946575 PRJNA674308_P_NODE_47457_length_164_cov_0.904348_g47222_i0 PRJNA674308 47457 164 0.904348 1.48313072 unclassified Cetobacterium 2630983 Bacteria Bacteria 110 1.45e-28   NR WP_047381875.1 2630983 g47222 i0 98.1 0.98780487804878 54 1 98.8 0 1 162 167 220 WP_047381875.1 MULTISPECIES: type 1 glutamine amidotransferase domain-containing protein [unclassified Cetobacterium] diamond 162 110 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Cetobacterium  
32874708 32874708 PRJNA674308_P_NODE_33940_length_174_cov_1.248000_g33705_i0 PRJNA674308 33940 174 1.248 2.17152 Bacteria 2 Bacteria Bacteria 82.8 2.03e-17   NR WP_134112166.1 1627895 g33705 i0 76 2.62068965517241 50 12 86.2 0 171 22 88 137 WP_134112166.1 phosphoribosylformimino-5-aminoimidazole carboxamide ribotide isomerase [Hypnocyclicus thermotrophus] diamond 456 82.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Hypnocyclicus Hypnocyclicus thermotrophus

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