contig_metadata
16 rows where bioproject = "PRJEB20058" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25516539 | 25516539 | PRJEB20058_P_NODE_186265_length_269_cov_2.024038_g183442_i0 | PRJEB20058 | 186265 | 269 | 2.024038 | 5.44466222 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 374 | 4.629999999999998e-99 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g183442 | i0 | 93.6 | 3.10780669144981 | 250 | 16 | 93 | 0 | 19 | 268 | 2292329 | 2292080 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 836 | 374 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 25789312 | 25789312 | PRJEB20058_P_NODE_204003_length_253_cov_5.703125_g201179_i0 | PRJEB20058 | 204003 | 253 | 5.703125 | 14.42890625 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 132 | 2.87e-26 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g201179 | i0 | 95.181 | 1.56916996047431 | 83 | 4 | 51 | 0 | 77 | 159 | 1179088 | 1179170 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 397 | 132 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 25924509 | 25924509 | PRJEB20058_P_NODE_180324_length_275_cov_28.584112_g177501_i0 | PRJEB20058 | 180324 | 275 | 28.584112 | 78.606308 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 374 | 4.7499999999999996e-99 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g177501 | i0 | 99.512 | 23.1272727272727 | 205 | 1 | 75 | 0 | 1 | 205 | 69966 | 70170 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 6360 | 374 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 25929649 | 25929649 | PRJEB20058_P_NODE_70844_length_495_cov_2.002304_g68072_i0 | PRJEB20058 | 70844 | 495 | 2.002304 | 9.9114048 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 405 | 3.22e-108 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g68072 | i0 | 90.323 | 1.25252525252525 | 310 | 28 | 62 | 2 | 10 | 318 | 535303 | 534995 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 620 | 405 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 25929830 | 25929830 | PRJEB20058_P_NODE_74308_length_482_cov_8.187648_g71531_i0 | PRJEB20058 | 74308 | 482 | 8.187648 | 39.46446336 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 815 | 0 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g71531 | i0 | 99.335 | 23.4170124481328 | 451 | 1 | 94 | 2 | 25 | 475 | 2673061 | 2672613 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 11287 | 815 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 26060961 | 26060961 | PRJEB20058_P_NODE_191453_length_263_cov_38.900990_g188629_i0 | PRJEB20058 | 191453 | 263 | 38.90099 | 102.3096037 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 228 | 3.719999999999999e-55 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g188629 | i0 | 87.374 | 123.087452471483 | 198 | 25 | 81 | 0 | 65 | 262 | 70155 | 69958 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 32372 | 228 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 26329440 | 26329440 | PRJEB20058_P_NODE_109231_length_386_cov_28.033846_g106420_i0 | PRJEB20058 | 109231 | 386 | 28.033846 | 108.21064556 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 658 | 0 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g106420 | i0 | 99.18 | 1.89637305699482 | 366 | 2 | 95 | 1 | 1 | 365 | 2378481 | 2378846 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 732 | 658 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 26469416 | 26469416 | PRJEB20058_P_NODE_19328_length_944_cov_2.778029_g17279_i0 | PRJEB20058 | 19328 | 944 | 2.778029 | 26.22459376 | Fretibacterium sp. OH122 | 2699746 | Bacteria | Bacteria | 320 | 3.09e-104 | NR | WP_124889134.1 | 2491047 | g17279 | i0 | 94 | 1.06779661016949 | 168 | 10 | 53.4 | 0 | 513 | 10 | 1 | 168 | WP_124889134.1 glycine C-acetyltransferase [Fretibacterium sp. OH1220_COT-178] | diamond | 1008 | 320 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium sp. OH1220_COT-178 | ||
| 26473926 | 26473926 | PRJEB20058_P_NODE_68304_length_504_cov_78.203160_g65534_i0 | PRJEB20058 | 68304 | 504 | 78.20316 | 394.1439264 | Fretibacterium fastidiosum | 651822 | Bacteria | Bacteria | 824 | 0 | NTclustered | gi|2869663113|emb|OZ209244.1| | 651822 | g65534 | i0 | 99.127 | 1.81746031746032 | 458 | 4 | 91 | 0 | 24 | 481 | 2007621 | 2008078 | Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 | blastn | 916 | 824 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium fastidiosum | ||
| 26474845 | 26474845 | PRJEB20058_P_NODE_86520_length_443_cov_2.643979_g83731_i0 | PRJEB20058 | 86520 | 443 | 2.643979 | 11.71282697 | Fretibacterium sp. OH122 | 2699746 | Bacteria | Bacteria | 201 | 3.16e-60 | NR | WP_124887202.1 | 2491047 | g83731 | i0 | 87.5 | 0.758465011286682 | 112 | 14 | 75.8 | 0 | 9 | 344 | 285 | 396 | WP_124887202.1 cell division protein FtsZ [Fretibacterium sp. OH1220_COT-178] | diamond | 336 | 201 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | Fretibacterium sp. OH1220_COT-178 | ||
| 32945253 | 32945253 | PRJEB20058_P_NODE_204258_length_253_cov_2.651042_g201434_i0 | PRJEB20058 | 204258 | 253 | 2.651042 | 6.70713626 | Acetomicrobium sp. | 1872099 | Bacteria | Bacteria | 114 | 5.889999999999999e-28 | NR | MBP8674744.1 | 1872099 | g201434 | i0 | 66.7 | 1.77865612648221 | 75 | 25 | 88.9 | 0 | 24 | 248 | 97 | 171 | MBP8674744.1 restriction endonuclease subunit S [Acetomicrobium sp.] | diamond | 450 | 114 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Acetomicrobiaceae | Acetomicrobium | Acetomicrobium sp. | ||
| 32979099 | 32979099 | PRJEB20058_P_NODE_117747_length_369_cov_1.733766_g114932_i0 | PRJEB20058 | 117747 | 369 | 1.733766 | 6.39759654 | Jonquetella | 428711 | Bacteria | Bacteria | 237 | 2.55e-76 | NR | WP_008519836.1 | 428711 | g114932 | i0 | 99.2 | 0.975609756097561 | 120 | 1 | 97.6 | 0 | 368 | 9 | 27 | 146 | WP_008519836.1 MULTISPECIES: L-serine ammonia-lyase, iron-sulfur-dependent, subunit alpha [Jonquetella] | diamond | 360 | 237 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Dethiosulfovibrionaceae | Jonquetella | |||
| 32980079 | 32980079 | PRJEB20058_P_NODE_75123_length_479_cov_16.937799_g72345_i0 | PRJEB20058 | 75123 | 479 | 16.937799 | 81.13205721 | uncultured Fretibacterium sp. | 1678694 | Bacteria | Bacteria | 262 | 1.72e-83 | NR | WP_299075721.1 | 1678694 | g72345 | i0 | 91.7 | 1.79123173277662 | 145 | 12 | 90.8 | 0 | 457 | 23 | 186 | 330 | WP_299075721.1 LCP family protein [uncultured Fretibacterium sp.] | diamond | 858 | 262 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Fretibacterium | uncultured Fretibacterium sp. | ||
| 33064781 | 33064781 | PRJEB20058_P_NODE_220453_length_242_cov_2.298343_g217628_i0 | PRJEB20058 | 220453 | 242 | 2.298343 | 5.56199006 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 63.5 | 1.69e-9 | NR | NLA90347.1 | 2053624 | g217628 | i0 | 46.8 | 0.954545454545455 | 77 | 24 | 95.5 | 2 | 3 | 233 | 111 | 170 | NLA90347.1 preprotein translocase subunit SecY [Synergistaceae bacterium] | diamond | 231 | 63.5 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 33116508 | 33116508 | PRJEB20058_P_NODE_97247_length_414_cov_4.535411_g94444_i0 | PRJEB20058 | 97247 | 414 | 4.535411 | 18.77660154 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 251 | 1.12e-80 | NR | MBP8633137.1 | 2053624 | g94444 | i0 | 92.5 | 0.963768115942029 | 133 | 10 | 96.4 | 0 | 6 | 404 | 121 | 253 | MBP8633137.1 histidinol-phosphate transaminase [Synergistaceae bacterium] | diamond | 399 | 251 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 33132564 | 33132564 | PRJEB20058_P_NODE_131375_length_343_cov_9.109929_g128556_i0 | PRJEB20058 | 131375 | 343 | 9.109929 | 31.24705647 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 154 | 1.59e-44 | NR | MDR1732101.1 | 2053624 | g128556 | i0 | 78.4 | 0.848396501457726 | 97 | 21 | 84.8 | 0 | 18 | 308 | 45 | 141 | MDR1732101.1 cobalamin-dependent protein [Synergistaceae bacterium] | diamond | 291 | 154 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium |
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);;