RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA432257" and tax_kingdom = "Fusobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Fusobacteriati · 14 ✖

bioproject 1

  • PRJNA432257 · 14 ✖

analysis 1

  • diamond · 14 ✖

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
8082579 8082579 PRJNA432257_S_NODE_17607_length_336_cov_3.859532_g17226_i0 PRJNA432257 17607 336 3.859532 12.96802752 Fusobacterium sp. PH5-7 2940528 Bacteria Bacteria 122 3.3499999999999996e-30   NR WP_280728489.1 2940528 g17226 i0 62 1.78571428571429 100 38 89.3 0 5 304 347 446 WP_280728489.1 O-unit flippase-like protein [Fusobacterium sp. PH5-7] diamond 600 122 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium sp. PH5-7
27928636 27928636 PRJNA432257_S_NODE_106405_length_170_cov_2.548872_g106024_i0 PRJNA432257 106405 170 2.548872 4.3330824 Fusobacterium necrophorum 859 Bacteria Bacteria 46.2 6.73e-5   NR WP_222702847.1 859 g106024 i0 51.1 0.794117647058823 45 20 75.9 2 2 130 15 59 WP_222702847.1 hypothetical protein, partial [Fusobacterium necrophorum] diamond 135 46.2 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium necrophorum
28117973 28117973 PRJNA432257_S_NODE_51025_length_229_cov_14.687500_g50644_i0 PRJNA432257 51025 229 14.6875 33.634375 Leptotrichia sp. 104608 Bacteria Bacteria 122 3.91e-32   NR MBF1336640.1 104608 g50644 i0 79.7 0.96943231441048 74 15 96.9 0 224 3 48 121 MBF1336640.1 autotransporter-associated N-terminal domain-containing protein [Leptotrichia sp.] diamond 222 122 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp.
28370589 28370589 PRJNA432257_S_NODE_117606_length_159_cov_1.278689_g117225_i0 PRJNA432257 117606 159 1.278689 2.03311551 Leptotrichia sp. 104608 Bacteria Bacteria 62 4.53e-11   NR MBF1334156.1 104608 g117225 i0 91.4 1.32075471698113 35 3 66 0 152 48 39 73 MBF1334156.1 LacI family DNA-binding transcriptional regulator [Leptotrichia sp.] diamond 210 62 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp.
28402229 28402229 PRJNA432257_S_NODE_13186_length_371_cov_50.212575_g12805_i0 PRJNA432257 13186 371 50.212575 186.28865325 Leptotrichia sp. oral taxon 215 712359 Bacteria Bacteria 204 2.09e-64   NR WP_021766462.1 712359 g12805 i0 96.4 0.897574123989218 111 4 89.8 0 39 371 80 190 WP_021766462.1 TraX family protein [Leptotrichia sp. oral taxon 215] diamond 333 204 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 215
28970606 28970606 PRJNA432257_S_NODE_117388_length_159_cov_1.598361_g117007_i0 PRJNA432257 117388 159 1.598361 2.54139399 Fusobacterium periodonticum 860 Bacteria Bacteria 109 1.32e-29   NR WP_261658623.1 860 g117007 i0 100 1 53 0 100 0 159 1 40 92 WP_261658623.1 AAA family ATPase [Fusobacterium periodonticum] diamond 159 109 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
29065387 29065387 PRJNA432257_S_NODE_105588_length_171_cov_2.298507_g105207_i0 PRJNA432257 105588 171 2.298507 3.93044697 Fusobacterium periodonticum 860 Bacteria Bacteria 103 1.23e-25   NR MBF1197312.1 860 g105207 i0 96.3 0.947368421052632 54 2 94.7 0 8 169 137 190 MBF1197312.1 AMP-binding protein [Fusobacterium periodonticum] diamond 162 103 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium periodonticum
30075691 30075691 PRJNA432257_S_NODE_62232_length_213_cov_2.039773_g61851_i0 PRJNA432257 62232 213 2.039773 4.34471649 Fusobacterium sp. 27 68766 Bacteria Bacteria 119 2.03e-29   NR WP_371566515.1 3003691 g61851 i0 100 0.985915492957746 70 0 98.6 0 2 211 1577 1646 WP_371566515.1 hypothetical protein, partial [Fusobacterium sp. 27098_8_59] diamond 210 119 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium sp. 27098_8_59
30186932 30186932 PRJNA432257_S_NODE_33892_length_267_cov_14.930435_g33511_i0 PRJNA432257 33892 267 14.930435 39.86426145 root 1 Root_unresolved Root_unresolved 60.8 8.58e-10   NR WP_187105728.1 859 g33511 i0 56.9 1.30337078651685 58 20 65.2 1 226 53 21 73 WP_187105728.1 hypothetical protein, partial [Fusobacterium necrophorum] diamond 348 60.8 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium necrophorum
30960529 30960529 PRJNA432257_S_NODE_106674_length_170_cov_1.759398_g106293_i0 PRJNA432257 106674 170 1.759398 2.9909766 Leptotrichia wadei 157687 Bacteria Bacteria 118 4.08e-30   NR WP_315520902.1 157687 g106293 i0 100 0.988235294117647 56 0 98.8 0 170 3 200 255 WP_315520902.1 alginate O-acetyltransferase AlgX-related protein [Leptotrichia wadei] diamond 168 118 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia wadei
31339707 31339707 PRJNA432257_S_NODE_68096_length_205_cov_153.601190_g67715_i0 PRJNA432257 68096 205 153.60119 314.8824395 Fusobacterium sp. 27 68766 Bacteria Bacteria 73.6 3.18e-13   NR WP_371566515.1 3003691 g67715 i0 76.4 0.804878048780488 55 8 80.5 1 165 1 1560 1609 WP_371566515.1 hypothetical protein, partial [Fusobacterium sp. 27098_8_59] diamond 165 73.6 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Fusobacteriaceae Fusobacterium Fusobacterium sp. 27098_8_59
32098915 32098915 PRJNA432257_S_NODE_59298_length_217_cov_1.655556_g58917_i0 PRJNA432257 59298 217 1.655556 3.59255652 Fusobacteriota bacterium 2060921 Bacteria Bacteria 80.1 1.78e-15   NR RUA09543.1 2060921 g58917 i0 56.3 0.884792626728111 64 28 88.5 0 26 217 316 379 RUA09543.1 MAG: carboxypeptidase M32 [Fusobacteriota bacterium] diamond 192 80.1 1 Bacteria   Fusobacteriati Fusobacteriota         Fusobacteriota bacterium
32636282 32636282 PRJNA432257_S_NODE_95680_length_179_cov_378.781690_g95299_i0 PRJNA432257 95680 179 378.78169 678.0192251 Pseudostreptobacillus hongkongensis 1162717 Bacteria Bacteria 72 4.52e-13   NR WP_066896629.1 1162717 g95299 i0 70.2 0.787709497206704 47 14 78.8 0 143 3 221 267 WP_066896629.1 metal ABC transporter permease [Pseudostreptobacillus hongkongensis] diamond 141 72 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Pseudostreptobacillus Pseudostreptobacillus hongkongensis
32825461 32825461 PRJNA432257_S_NODE_35480_length_263_cov_1.123894_g35099_i0 PRJNA432257 35480 263 1.123894 2.95584122 Leptotrichia sp. oral taxon 215 712359 Bacteria Bacteria 148 2.7899999999999993e-43   NR WP_021766371.1 712359 g35099 i0 95.7 0.787072243346008 69 3 78.7 0 208 2 1 69 WP_021766371.1 DNA-3-methyladenine glycosylase I [Leptotrichia sp. oral taxon 215] diamond 207 148 1 Bacteria   Fusobacteriati Fusobacteriota Fusobacteriia Fusobacteriales Leptotrichiaceae Leptotrichia Leptotrichia sp. oral taxon 215

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