contig_metadata
20 rows where bioproject = "PRJNA550047" and tax_phylum = "Synergistota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3067000 | 3067000 | PRJNA550047_P_NODE_410663_length_261_cov_3.861702_g408691_i0 | PRJNA550047 | 410663 | 261 | 3.861702 | 10.07904222 | uncultured Fretibacterium sp. | 1678694 | Bacteria | Bacteria | 151 | 2.6899999999999998e-42 | NR | WP_299080674.1 | 1678694 | g408691 | i0 | 85.1 | 1.08045977011494 | 94 | 6 | 98.9 | 1 | 260 | 3 | 99 | 192 | WP_299080674.1 hypothetical protein [uncultured Fretibacterium sp.] | diamond | 282 | 151 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | uncultured Fretibacterium sp. | ||
| 6891587 | 6891587 | PRJNA550047_P_NODE_224826_length_301_cov_8.807018_g222857_i0 | PRJNA550047 | 224826 | 301 | 8.807018 | 26.50912418 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 355 | 1.91e-93 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g222857 | i0 | 88.699 | 106.913621262458 | 292 | 32 | 97 | 1 | 1 | 292 | 70152 | 69862 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 32181 | 355 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 6894997 | 6894997 | PRJNA550047_P_NODE_495986_length_231_cov_39.272152_g494013_i0 | PRJNA550047 | 495986 | 231 | 39.272152 | 90.71867112 | Synergistetes bacterium oral taxon 363 | 713037 | Bacteria | Bacteria | 422 | 1.37e-113 | NTclustered | gi|285800810|gb|GU410792.1| | 713037 | g494013 | i0 | 99.567 | 102.004329004329 | 231 | 1 | 100 | 0 | 1 | 231 | 29 | 259 | Synergistetes bacterium oral taxon 363 clone AT057 16S ribosomal RNA gene, partial sequence | blastn | 23563 | 422 | 1 | Bacteria | Thermotogati | Synergistota | Synergistetes bacterium oral taxon 363 | ||||||
| 9442260 | 9442260 | PRJNA550047_P_NODE_233108_length_301_cov_4.894737_g231139_i0 | PRJNA550047 | 233108 | 301 | 4.894737 | 14.73315837 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 525 | 1.3699999999999995e-144 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g231139 | i0 | 98.328 | 499.063122923588 | 299 | 5 | 99 | 0 | 3 | 301 | 67852 | 68150 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 150218 | 525 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 12600389 | 12600389 | PRJNA550047_P_NODE_402430_length_264_cov_5.989529_g400458_i0 | PRJNA550047 | 402430 | 264 | 5.989529 | 15.81235656 | Bacteria | 2 | Bacteria | Bacteria | 486 | 5.579999999999999e-133 | NTclustered | gi|401555873|gb|JX010924.1| | 447826 | g400458 | i0 | 100 | 99.625 | 263 | 0 | 99 | 0 | 1 | 263 | 303 | 41 | Uncultured Synergistetes bacterium clone 1P15 16S ribosomal RNA gene, partial sequence | blastn | 26301 | 486 | 1 | Bacteria | Thermotogati | Synergistota | uncultured Synergistota bacterium | ||||||
| 14543736 | 14543736 | PRJNA550047_P_NODE_310552_length_296_cov_3.928251_g308583_i0 | PRJNA550047 | 310552 | 296 | 3.928251 | 11.62762296 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 100 | 3.59e-23 | NR | NLK18870.1 | 2053624 | g308583 | i0 | 89.8 | 0.496621621621622 | 49 | 5 | 49.7 | 0 | 296 | 150 | 204 | 252 | NLK18870.1 phosphoenolpyruvate hydrolase family protein [Synergistaceae bacterium] | diamond | 147 | 100 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 19639160 | 19639160 | PRJNA550047_P_NODE_149296_length_345_cov_4.764706_g147336_i0 | PRJNA550047 | 149296 | 345 | 4.764706 | 16.4382357 | Pyramidobacter piscolens | 638849 | Bacteria | Bacteria | 63.9 | 1.51e-5 | NTclustered | gi|2188906985|dbj|AP025585.1| | 638849 | g147336 | i0 | 93.182 | 0.359420289855072 | 44 | 2 | 13 | 1 | 301 | 344 | 1075428 | 1075470 | Pyramidobacter piscolens CE91-St28 DNA, complete genome | blastn | 124 | 63.9 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Dethiosulfovibrionaceae | Pyramidobacter | Pyramidobacter piscolens | ||
| 26871680 | 26871680 | PRJNA550047_P_NODE_57401_length_345_cov_16.077206_g55441_i0 | PRJNA550047 | 57401 | 345 | 16.077206 | 55.4663607 | Fretibacterium | 1434006 | Bacteria | Bacteria | 95.9 | 2.51e-20 | NR | WP_299300001.1 | 1678694 | g55441 | i0 | 94 | 0.869565217391304 | 50 | 3 | 43.5 | 0 | 151 | 2 | 427 | 476 | WP_299300001.1 nucleoside kinase [uncultured Fretibacterium sp.] | diamond | 300 | 95.9 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | uncultured Fretibacterium sp. | ||
| 27078131 | 27078131 | PRJNA550047_P_NODE_479822_length_237_cov_8.481707_g477849_i0 | PRJNA550047 | 479822 | 237 | 8.481707 | 20.10164559 | Aminobacterium sp. | 1872491 | Bacteria | Bacteria | 112 | 8.4e-28 | NR | HCA40675.1 | 1872491 | g477849 | i0 | 77.8 | 0.911392405063291 | 72 | 16 | 91.1 | 0 | 235 | 20 | 241 | 312 | HCA40675.1 hypothetical protein [Aminobacterium sp.] | diamond | 216 | 112 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Aminobacterium | Aminobacterium sp. | ||
| 28214878 | 28214878 | PRJNA550047_P_NODE_487426_length_234_cov_18.105590_g485453_i0 | PRJNA550047 | 487426 | 234 | 18.10559 | 42.3670806 | Aminivibrio sp. | 1872489 | Bacteria | Bacteria | 137 | 4.7e-37 | NR | WP_367340975.1 | 1872489 | g485453 | i0 | 84.4 | 1.97435897435897 | 77 | 12 | 98.7 | 0 | 232 | 2 | 252 | 328 | WP_367340975.1 type IV pilus twitching motility protein PilT [Aminivibrio sp.] | diamond | 462 | 137 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Aminivibrio | Aminivibrio sp. | ||
| 28751822 | 28751822 | PRJNA550047_P_NODE_430107_length_253_cov_22.577778_g428135_i0 | PRJNA550047 | 430107 | 253 | 22.577778 | 57.12177834 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 80.9 | 8.59e-16 | NR | MBQ6739169.1 | 2053624 | g428135 | i0 | 68.9 | 1.44664031620553 | 61 | 19 | 72.3 | 0 | 69 | 251 | 1 | 61 | MBQ6739169.1 hypothetical protein [Synergistaceae bacterium] | diamond | 366 | 80.9 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 29524400 | 29524400 | PRJNA550047_P_NODE_529650_length_220_cov_13.108844_g527677_i0 | PRJNA550047 | 529650 | 220 | 13.108844 | 28.8394568 | Synergistales | 649776 | Bacteria | Bacteria | 146 | 1.19e-39 | NR | WP_367339441.1 | 1872489 | g527677 | i0 | 98.6 | 1.96363636363636 | 72 | 1 | 98.2 | 0 | 5 | 220 | 269 | 340 | WP_367339441.1 glutathione ABC transporter substrate-binding protein [Aminivibrio sp.] | diamond | 432 | 146 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Aminivibrio | Aminivibrio sp. | ||
| 29603977 | 29603977 | PRJNA550047_P_NODE_327990_length_293_cov_3.363636_g326020_i0 | PRJNA550047 | 327990 | 293 | 3.363636 | 9.85545348 | Aminivibrio sp. | 1872489 | Bacteria | Bacteria | 185 | 2.769999999999999e-55 | NR | WP_367337857.1 | 1872489 | g326020 | i0 | 100 | 0.993174061433447 | 97 | 0 | 99.3 | 0 | 292 | 2 | 82 | 178 | WP_367337857.1 transaldolase [Aminivibrio sp.] | diamond | 291 | 185 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Aminivibrio | Aminivibrio sp. | ||
| 29825288 | 29825288 | PRJNA550047_P_NODE_561391_length_210_cov_5.379562_g559418_i0 | PRJNA550047 | 561391 | 210 | 5.379562 | 11.2970802 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 142 | 1.69e-40 | NR | MDD3390087.1 | 2053624 | g559418 | i0 | 100 | 0.985714285714286 | 69 | 0 | 98.6 | 0 | 209 | 3 | 134 | 202 | MDD3390087.1 hypothetical protein [Synergistaceae bacterium] | diamond | 207 | 142 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 30583389 | 30583389 | PRJNA550047_P_NODE_377053_length_274_cov_6.034826_g375081_i0 | PRJNA550047 | 377053 | 274 | 6.034826 | 16.53542324 | Aminivibrio sp. | 1872489 | Bacteria | Bacteria | 124 | 9.799999999999999e-35 | NR | WP_367338755.1 | 1872489 | g375081 | i0 | 100 | 0.635036496350365 | 58 | 0 | 63.5 | 0 | 1 | 174 | 31 | 88 | WP_367338755.1 hypothetical protein [Aminivibrio sp.] | diamond | 174 | 124 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Aminivibrio | Aminivibrio sp. | ||
| 30693060 | 30693060 | PRJNA550047_P_NODE_98673_length_345_cov_8.566176_g96713_i0 | PRJNA550047 | 98673 | 345 | 8.566176 | 29.5533072 | Aminivibrio | 1427172 | Bacteria | Bacteria | 172 | 2.55e-48 | NR | WP_367338113.1 | 1872489 | g96713 | i0 | 60.6 | 2.8695652173913 | 165 | 14 | 99.1 | 1 | 3 | 344 | 372 | 536 | WP_367338113.1 gamma-glutamyltransferase [Aminivibrio sp.] | diamond | 990 | 172 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Aminivibrio | Aminivibrio sp. | ||
| 30804808 | 30804808 | PRJNA550047_P_NODE_428654_length_254_cov_8.740331_g426682_i0 | PRJNA550047 | 428654 | 254 | 8.740331 | 22.20044074 | uncultured Fretibacterium sp. | 1678694 | Bacteria | Bacteria | 114 | 2.85e-27 | NR | WP_298779375.1 | 1678694 | g426682 | i0 | 67.5 | 0.980314960629921 | 83 | 26 | 98 | 1 | 4 | 252 | 775 | 856 | WP_298779375.1 Synerg-CTERM sorting domain-containing protein [uncultured Fretibacterium sp.] | diamond | 249 | 114 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | uncultured Fretibacterium sp. | ||
| 31342152 | 31342152 | PRJNA550047_P_NODE_595736_length_199_cov_10.349206_g593763_i0 | PRJNA550047 | 595736 | 199 | 10.349206 | 20.59491994 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 45.1 | 0.00142 | NR | MDI3533296.1 | 2053624 | g593763 | i0 | 45.3 | 0.798994974874372 | 53 | 29 | 79.9 | 0 | 11 | 169 | 55 | 107 | MDI3533296.1 hypothetical protein [Synergistaceae bacterium] | diamond | 159 | 45.1 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 31721630 | 31721630 | PRJNA550047_P_NODE_566197_length_208_cov_12.066667_g564224_i0 | PRJNA550047 | 566197 | 208 | 12.066667 | 25.09866736 | uncultured Fretibacterium sp. | 1678694 | Bacteria | Bacteria | 157 | 3.9199999999999996e-46 | NR | WP_299301585.1 | 1678694 | g564224 | i0 | 98.5 | 0.980769230769231 | 68 | 1 | 98.1 | 0 | 206 | 3 | 88 | 155 | WP_299301585.1 tRNA pseudouridine(38-40) synthase TruA [uncultured Fretibacterium sp.] | diamond | 204 | 157 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | uncultured Fretibacterium sp. | ||
| 32259753 | 32259753 | PRJNA550047_P_NODE_379698_length_273_cov_5.470000_g377726_i0 | PRJNA550047 | 379698 | 273 | 5.47 | 14.9331 | Fretibacterium sp. | 2699746 | Bacteria | Bacteria | 182 | 3.49e-57 | NR | MFC2594412.1 | 2699746 | g377726 | i0 | 98.9 | 0.989010989010989 | 90 | 1 | 98.9 | 0 | 271 | 2 | 13 | 102 | MFC2594412.1 hypothetical protein [Fretibacterium sp.] | diamond | 270 | 182 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium sp. |
Advanced export
JSON shape: default, array, newline-delimited
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);;