contig_metadata
41 rows where bioproject = "PRJNA1067370", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3563774 | 3563774 | PRJNA1067370_P_NODE_16763_length_454_cov_1.572178_g16215_i0 | PRJNA1067370 | 16763 | 454 | 1.572178 | 7.13768812 | Spirochaeta | 146 | Bacteria | Bacteria | 512 | 1.68e-140 | NTclustered | gi|507148391|ref|NR_103194.1| | 46355 | g16215 | i0 | 87.033 | 611.057268722467 | 455 | 57 | 99 | 2 | 1 | 453 | 2074 | 2528 | Spirochaeta africana strain Z-7692 23S ribosomal RNA gene, complete sequence | blastn | 277420 | 516 | 0.992248062015504 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Spirochaetaceae | Spirochaeta | Spirochaeta africana | ||
| 6559193 | 6559193 | PRJNA1067370_S_NODE_1746_length_379_cov_2.039216_g1720_i0 | PRJNA1067370 | 1746 | 379 | 2.039216 | 7.72862864 | Treponema parvum | 138851 | Bacteria | Bacteria | 346 | 1.4799999999999999e-90 | NTclustered | gi|2023444933|gb|CP054257.1| | 138851 | g1720 | i0 | 83.377 | 161.290237467018 | 385 | 52 | 100 | 11 | 1 | 379 | 1517776 | 1518154 | Treponema parvum strain ATCC 700773 chromosome, complete genome | blastn | 61129 | 346 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Treponemataceae | Treponema | Treponema parvum | ||
| 7833622 | 7833622 | PRJNA1067370_P_NODE_78007_length_253_cov_0.977778_g77458_i0 | PRJNA1067370 | 78007 | 253 | 0.977778 | 2.47377834 | Spirochaetia bacterium | 2053615 | Bacteria | Bacteria | 222 | 1.65e-53 | NTclustered | gi|2891483193|emb|OZ220223.1| | 2053615 | g77458 | i0 | 82.946 | 136.158102766798 | 258 | 32 | 99 | 11 | 1 | 252 | 1056274 | 1056525 | MAG: Spirochaetia bacterium isolate 03e4f5d5-dacf-4468-93a7-e7b19fb300a1 genome assembly, chromosome: 2 | blastn | 34448 | 222 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetia bacterium | |||||
| 9108582 | 9108582 | PRJNA1067370_P_NODE_65988_length_271_cov_0.984848_g65439_i0 | PRJNA1067370 | 65988 | 271 | 0.984848 | 2.66893808 | Breznakiella homolactica | 2798577 | Bacteria | Bacteria | 339 | 1.7e-88 | NTclustered | gi|2093987262|gb|CP067089.2| | 2798577 | g65439 | i0 | 89.299 | 168.708487084871 | 271 | 27 | 99 | 2 | 1 | 270 | 9825 | 9556 | Breznakiella homolactica strain RmG30 chromosome, complete genome | blastn | 45720 | 339 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Breznakiellaceae | Breznakiella | Breznakiella homolactica | ||
| 12934676 | 12934676 | PRJNA1067370_P_NODE_54171_length_289_cov_0.893519_g53622_i0 | PRJNA1067370 | 54171 | 289 | 0.893519 | 2.58226991 | Treponemataceae bacterium | 2854022 | Bacteria | Bacteria | 473 | 4.819999999999999e-129 | NTclustered | gi|2814788384|emb|OY762953.2| | 2854022 | g53622 | i0 | 96.194 | 193.813148788927 | 289 | 11 | 100 | 0 | 1 | 289 | 1491109 | 1490821 | MAG: Treponemataceae bacterium isolate a6accef0-0fd1-414a-935d-742eec6b5613 genome assembly, chromosome: 1 | blastn | 56012 | 473 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Treponemataceae | Treponemataceae bacterium | |||
| 15483539 | 15483539 | PRJNA1067370_P_NODE_29913_length_356_cov_1.074205_g29365_i0 | PRJNA1067370 | 29913 | 356 | 1.074205 | 3.8241698 | uncultured Sphaerochaeta sp. | 886478 | Bacteria | Bacteria | 320 | 8.369999999999998e-83 | NTclustered | gi|2621785415|emb|OY781873.1| | 886478 | g29365 | i0 | 83.106 | 168.63202247191 | 367 | 46 | 100 | 16 | 1 | 356 | 1914515 | 1914154 | MAG: uncultured Sphaerochaeta sp. isolate d3c3752c-658c-4035-93a5-350d78b9f8a8 genome assembly, chromosome: 1 | blastn | 60033 | 320 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Sphaerochaetaceae | Sphaerochaeta | uncultured Sphaerochaeta sp. | ||
| 15483604 | 15483604 | PRJNA1067370_P_NODE_39353_length_321_cov_1.387097_g38805_i0 | PRJNA1067370 | 39353 | 321 | 1.387097 | 4.45258137 | Brachyspira hampsonii | 1287055 | Bacteria | Bacteria | 52.8 | 0.03 | NTclustered | gi|1214564172|gb|CP019914.1| | 1287055 | g38805 | i0 | 88.372 | 0.133956386292835 | 43 | 5 | 13 | 0 | 9 | 51 | 1999824 | 1999782 | Brachyspira hampsonii strain NSH-16 chromosome, complete genome | blastn | 43 | 52.8 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Brachyspirales | Brachyspiraceae | Brachyspira | Brachyspira hampsonii | ||
| 15483742 | 15483742 | PRJNA1067370_P_NODE_62013_length_277_cov_1.039216_g61464_i0 | PRJNA1067370 | 62013 | 277 | 1.039216 | 2.87862832 | Treponemataceae bacterium | 2854022 | Bacteria | Bacteria | 390 | 4.749999999999999e-104 | NTclustered | gi|2814788384|emb|OY762953.2| | 2854022 | g61464 | i0 | 92.115 | 119.176895306859 | 279 | 19 | 100 | 2 | 1 | 277 | 1490252 | 1489975 | MAG: Treponemataceae bacterium isolate a6accef0-0fd1-414a-935d-742eec6b5613 genome assembly, chromosome: 1 | blastn | 33012 | 390 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Treponemataceae | Treponemataceae bacterium | |||
| 16757987 | 16757987 | PRJNA1067370_P_NODE_73714_length_259_cov_1.451613_g73165_i0 | PRJNA1067370 | 73714 | 259 | 1.451613 | 3.75967767 | Treponema medium | 58231 | Bacteria | Bacteria | 479 | 9.13e-131 | NTclustered | gi|1996296230|gb|CP031393.1| | 58231 | g73165 | i0 | 100 | 193.888030888031 | 259 | 0 | 100 | 0 | 1 | 259 | 1012718 | 1012976 | Treponema medium strain ATCC 700293 chromosome, complete genome | blastn | 50217 | 479 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Treponemataceae | Treponema | Treponema medium | ||
| 16758059 | 16758059 | PRJNA1067370_P_NODE_84614_length_250_cov_0.870056_g84065_i0 | PRJNA1067370 | 84614 | 250 | 0.870056 | 2.17514 | Spirochaetia bacterium | 2053615 | Bacteria | Bacteria | 52.8 | 0.023 | NTclustered | gi|2621706806|emb|OY764868.1| | 2053615 | g84065 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 119 | 146 | 461772 | 461745 | MAG: Spirochaetia bacterium isolate 011fa16d-6e6a-4572-b8a7-e5a7f8581680 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetia bacterium | |||||
| 18032603 | 18032603 | PRJNA1067370_P_NODE_44495_length_310_cov_2.223629_g43947_i0 | PRJNA1067370 | 44495 | 310 | 2.223629 | 6.8932499 | Borreliella tanukii | 56146 | Bacteria | Bacteria | 52.8 | 0.029 | NTclustered | gi|2918227553|gb|CP179589.1| | 56146 | g43947 | i0 | 90.476 | 0.135483870967742 | 42 | 1 | 13 | 3 | 259 | 297 | 25025 | 24984 | Borreliella tanukii strain TanegashimaAS13 plasmid lp36, complete sequence | blastn | 42 | 52.8 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Borreliaceae | Borreliella | Borreliella tanukii | ||
| 19306495 | 19306495 | PRJNA1067370_P_NODE_4396_length_836_cov_2.318480_g3923_i0 | PRJNA1067370 | 4396 | 836 | 2.31848 | 19.3824928 | Salinispira pacifica | 1307761 | Bacteria | Bacteria | 852 | 0 | NTclustered | gi|565679415|gb|CP006939.1| | 1307761 | g3923 | i0 | 85.34 | 237.864832535885 | 839 | 106 | 99 | 12 | 4 | 835 | 385017 | 385845 | Salinispira pacifica strain L21-RPul-D2, complete genome | blastn | 198855 | 852 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Spirochaetaceae | Salinispira | Salinispira pacifica | ||
| 21415235 | 21415235 | PRJNA1067370_P_NODE_32277_length_346_cov_1.358974_g31729_i0 | PRJNA1067370 | 32277 | 346 | 1.358974 | 4.70205004 | Treponema | 157 | Bacteria | Bacteria | 640 | 5.4999999999999996e-179 | NTclustered | gi|1996291085|gb|CP027017.1| | 58231 | g31729 | i0 | 100 | 194.060693641618 | 346 | 0 | 100 | 0 | 1 | 346 | 1014721 | 1015066 | Treponema medium strain T19 chromosome, complete genome | blastn | 67145 | 640 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Treponemataceae | Treponema | Treponema medium | ||
| 23133538 | 23133538 | PRJNA1067370_P_NODE_97139_length_246_cov_0.890173_g96590_i0 | PRJNA1067370 | 97139 | 246 | 0.890173 | 2.18982558 | Teretinema zuelzerae | 156 | Bacteria | Bacteria | 66.6 | 8.47e-11 | NR | WP_230754951.1 | 156 | g96590 | i0 | 54.2 | 1.4390243902439 | 59 | 27 | 72 | 0 | 63 | 239 | 75 | 133 | WP_230754951.1 translation elongation factor Ts [Teretinema zuelzerae] | diamond | 354 | 66.6 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Treponemataceae | Teretinema | Teretinema zuelzerae | ||
| 26845950 | 26845950 | PRJNA1067370_P_NODE_28241_length_364_cov_1.192440_g27693_i0 | PRJNA1067370 | 28241 | 364 | 1.19244 | 4.3404816 | Leptospiraceae bacterium | 2026757 | Bacteria | Bacteria | 94.4 | 8.63e-20 | NR | MBL8032961.1 | 2026757 | g27693 | i0 | 42.9 | 1.84615384615385 | 112 | 60 | 92.3 | 1 | 364 | 29 | 260 | 367 | MBL8032961.1 saccharopine dehydrogenase NADP-binding domain-containing protein [Leptospiraceae bacterium] | diamond | 672 | 94.4 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Leptospirales | Leptospiraceae | Leptospiraceae bacterium | |||
| 27161755 | 27161755 | PRJNA1067370_P_NODE_38522_length_324_cov_0.912351_g37974_i0 | PRJNA1067370 | 38522 | 324 | 0.912351 | 2.95601724 | Leptospiraceae bacterium | 2026757 | Bacteria | Bacteria | 75.5 | 9.39e-15 | NR | HNF17561.1 | 2026757 | g37974 | i0 | 43.5 | 1.7037037037037 | 92 | 49 | 84.3 | 2 | 305 | 33 | 20 | 109 | HNF17561.1 kelch repeat-containing protein [Leptospiraceae bacterium] | diamond | 552 | 75.5 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Leptospirales | Leptospiraceae | Leptospiraceae bacterium | |||
| 27438369 | 27438369 | PRJNA1067370_P_NODE_25043_length_382_cov_1.042071_g24495_i0 | PRJNA1067370 | 25043 | 382 | 1.042071 | 3.98071122 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 56.6 | 9.75e-7 | NR | OHD18884.1 | 1802176 | g24495 | i0 | 35.5 | 2.2696335078534 | 110 | 46 | 66.8 | 3 | 127 | 381 | 6 | 115 | OHD18884.1 MAG: hypothetical protein A2Y38_14560 [Spirochaetes bacterium GWB1_59_5] | diamond | 867 | 56.6 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetes bacterium GWB1_59_5 | ||||||
| 27438379 | 27438379 | PRJNA1067370_P_NODE_54563_length_288_cov_1.358140_g54014_i0 | PRJNA1067370 | 54563 | 288 | 1.35814 | 3.9114432 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 45.1 | 0.00649 | NR | MBD9150343.1 | 2053615 | g54014 | i0 | 40.7 | 1.14583333333333 | 54 | 31 | 56.3 | 1 | 20 | 181 | 126 | 178 | MBD9150343.1 tetratricopeptide repeat protein [Spirochaetia bacterium] | diamond | 330 | 45.1 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetia bacterium | |||||
| 27730874 | 27730874 | PRJNA1067370_P_NODE_35624_length_333_cov_1.584615_g35076_i0 | PRJNA1067370 | 35624 | 333 | 1.584615 | 5.27676795 | Spirochaetia bacterium | 2053615 | Bacteria | Bacteria | 82 | 1.02e-16 | NR | HTZ50180.1 | 2053615 | g35076 | i0 | 54 | 2.34234234234234 | 63 | 29 | 56.8 | 0 | 189 | 1 | 80 | 142 | HTZ50180.1 isoprenylcysteine carboxylmethyltransferase family protein [Spirochaetia bacterium] | diamond | 780 | 82 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetia bacterium | |||||
| 28488472 | 28488472 | PRJNA1067370_P_NODE_45507_length_308_cov_1.310638_g44959_i0 | PRJNA1067370 | 45507 | 308 | 1.310638 | 4.03676504 | Sphaerochaetaceae bacterium | 2791017 | Bacteria | Bacteria | 72.4 | 1.35e-12 | NR | MFA5570319.1 | 2791017 | g44959 | i0 | 63.5 | 1.01298701298701 | 52 | 19 | 50.6 | 0 | 150 | 305 | 3 | 54 | MFA5570319.1 deoxyribonuclease IV [Sphaerochaetaceae bacterium] | diamond | 312 | 72.4 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Sphaerochaetaceae | Sphaerochaetaceae bacterium | |||
| 28551677 | 28551677 | PRJNA1067370_P_NODE_27287_length_369_cov_1.179054_g26739_i0 | PRJNA1067370 | 27287 | 369 | 1.179054 | 4.35070926 | Treponema sp. | 166 | Bacteria | Bacteria | 47 | 0.0049 | NR | MBQ2529438.1 | 166 | g26739 | i0 | 29.3 | 3.23577235772358 | 99 | 67 | 80.5 | 1 | 324 | 28 | 13 | 108 | MBQ2529438.1 hypothetical protein [Treponema sp.] | diamond | 1194 | 47 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Treponemataceae | Treponema | Treponema sp. | ||
| 28669601 | 28669601 | PRJNA1067370_P_NODE_14607_length_483_cov_1.451220_g14060_i0 | PRJNA1067370 | 14607 | 483 | 1.45122 | 7.0093926 | Spirochaetales | 136 | Bacteria | Bacteria | 153 | 4.99e-40 | NR | MDR1326608.1 | 166 | g14060 | i0 | 52 | 29.0931677018634 | 148 | 71 | 91.9 | 0 | 477 | 34 | 421 | 568 | MDR1326608.1 molecular chaperone DnaK [Treponema sp.] | diamond | 14052 | 154 | 0.993506493506494 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Treponemataceae | Treponema | Treponema sp. | ||
| 28921937 | 28921937 | PRJNA1067370_P_NODE_70408_length_264_cov_1.230366_g69859_i0 | PRJNA1067370 | 70408 | 264 | 1.230366 | 3.24816624 | Bacteria | 2 | Bacteria | Bacteria | 103 | 9.31e-25 | NR | WP_319560268.1 | 2038653 | g69859 | i0 | 61.2 | 7.54545454545455 | 85 | 33 | 96.6 | 0 | 3 | 257 | 19 | 103 | WP_319560268.1 HesA/MoeB/ThiF family protein [Marispirochaeta sp.] | diamond | 1992 | 103 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Spirochaetaceae | Marispirochaeta | Marispirochaeta sp. | ||
| 28962179 | 28962179 | PRJNA1067370_P_NODE_11488_length_538_cov_1.913978_g10945_i0 | PRJNA1067370 | 11488 | 538 | 1.913978 | 10.29720164 | Leptospiraceae bacterium | 2026757 | Bacteria | Bacteria | 253 | 2.11e-79 | NR | MCB1310127.1 | 2026757 | g10945 | i0 | 69.3 | 3.99814126394052 | 179 | 54 | 99.8 | 1 | 1 | 537 | 255 | 432 | MCB1310127.1 aldehyde dehydrogenase family protein [Leptospiraceae bacterium] | diamond | 2151 | 253 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Leptospirales | Leptospiraceae | Leptospiraceae bacterium | |||
| 28962192 | 28962192 | PRJNA1067370_P_NODE_1888_length_1194_cov_2.434434_g1575_i0 | PRJNA1067370 | 1888 | 1194 | 2.434434 | 29.06714196 | Spirochaetota bacterium | 2202144 | Bacteria | Bacteria | 78.6 | 2.19e-12 | NR | MDR2733537.1 | 2202144 | g1575 | i0 | 31.7 | 0.869346733668342 | 161 | 102 | 39.4 | 4 | 1190 | 720 | 110 | 266 | MDR2733537.1 CAP domain-containing protein [Spirochaetota bacterium] | diamond | 1038 | 78.6 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetota bacterium | ||||||
| 29309247 | 29309247 | PRJNA1067370_P_NODE_49869_length_297_cov_1.026786_g49321_i0 | PRJNA1067370 | 49869 | 297 | 1.026786 | 3.04955442 | Spirochaetota bacterium | 2202144 | Bacteria | Bacteria | 43.9 | 0.027 | NR | HON78997.1 | 2202144 | g49321 | i0 | 47.6 | 0.94949494949495 | 42 | 21 | 42.4 | 1 | 296 | 171 | 310 | 350 | HON78997.1 mucoidy inhibitor MuiA family protein [Spirochaetota bacterium] | diamond | 282 | 43.9 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetota bacterium | ||||||
| 29656226 | 29656226 | PRJNA1067370_P_NODE_710_length_1694_cov_10.996299_g540_i0 | PRJNA1067370 | 710 | 1694 | 10.996299 | 186.27730506 | Turneriella sp. | 2717305 | Bacteria | Bacteria | 282 | 2.5299999999999996e-85 | NR | MFO1471830.1 | 2717305 | g540 | i0 | 36.3 | 3.18949232585596 | 452 | 265 | 79 | 8 | 99 | 1436 | 2 | 436 | MFO1471830.1 saccharopine dehydrogenase NADP-binding domain-containing protein [Turneriella sp.] | diamond | 5403 | 282 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Leptospirales | Leptospiraceae | Turneriella | Turneriella sp. | ||
| 30415066 | 30415066 | PRJNA1067370_P_NODE_22333_length_401_cov_1.408537_g21785_i0 | PRJNA1067370 | 22333 | 401 | 1.408537 | 5.64823337 | Spirochaetaceae bacterium | 1898206 | Bacteria | Bacteria | 47.8 | 0.00353 | NR | TVQ27676.1 | 1898206 | g21785 | i0 | 31.9 | 1.63092269326683 | 72 | 47 | 53.9 | 1 | 243 | 28 | 357 | 426 | TVQ27676.1 MAG: ABC transporter ATP-binding protein [Spirochaetaceae bacterium] | diamond | 654 | 47.8 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Spirochaetaceae | Spirochaetaceae bacterium | |||
| 30478071 | 30478071 | PRJNA1067370_P_NODE_49293_length_298_cov_1.368889_g48745_i0 | PRJNA1067370 | 49293 | 298 | 1.368889 | 4.07928922 | Spirochaetales bacterium | 2026792 | Bacteria | Bacteria | 71.6 | 3.07e-12 | NR | MBE7440661.1 | 2026792 | g48745 | i0 | 43.4 | 0.835570469798658 | 83 | 44 | 81.5 | 2 | 251 | 9 | 56 | 137 | MBE7440661.1 endonuclease/exonuclease/phosphatase family protein [Spirochaetales bacterium] | diamond | 249 | 71.6 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Spirochaetales bacterium | ||||
| 30722258 | 30722258 | PRJNA1067370_P_NODE_7234_length_665_cov_1.750000_g6715_i0 | PRJNA1067370 | 7234 | 665 | 1.75 | 11.6375 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 112 | 3.05e-25 | NR | NCN08856.1 | 178 | g6715 | i0 | 37.3 | 2.4812030075188 | 201 | 108 | 88.9 | 7 | 664 | 74 | 35 | 221 | NCN08856.1 alkane 1-monooxygenase [Leptospira sp.] | diamond | 1650 | 112 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Leptospirales | Leptospiraceae | Leptospira | Leptospira sp. | ||
| 30880300 | 30880300 | PRJNA1067370_P_NODE_41214_length_316_cov_0.818930_g40666_i0 | PRJNA1067370 | 41214 | 316 | 0.81893 | 2.5878188 | Bacteria | 2 | Bacteria | Bacteria | 74.7 | 4.89e-13 | NR | MBT89669.1 | 2026792 | g40666 | i0 | 38.1 | 2.91455696202532 | 105 | 63 | 98.7 | 2 | 3 | 314 | 283 | 386 | MBT89669.1 hypothetical protein [Spirochaetales bacterium] | diamond | 921 | 74.7 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Spirochaetales bacterium | ||||
| 30983680 | 30983680 | PRJNA1067370_P_NODE_72154_length_261_cov_1.638298_g71605_i0 | PRJNA1067370 | 72154 | 261 | 1.638298 | 4.27595778 | Spirochaetota bacterium | 2202144 | Bacteria | Bacteria | 42.7 | 0.0463 | NR | MDI9386498.1 | 2202144 | g71605 | i0 | 27.7 | 0.954022988505747 | 83 | 60 | 95.4 | 0 | 249 | 1 | 205 | 287 | MDI9386498.1 chromosomal replication initiator protein DnaA [Spirochaetota bacterium] | diamond | 249 | 42.7 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetota bacterium | ||||||
| 31014994 | 31014994 | PRJNA1067370_P_NODE_113375_length_241_cov_0.916667_g112826_i0 | PRJNA1067370 | 113375 | 241 | 0.916667 | 2.20916747 | Spirochaetia bacterium | 2053615 | Bacteria | Bacteria | 43.5 | 0.0175 | NR | GHU69831.1 | 2053615 | g112826 | i0 | 63.6 | 0.410788381742739 | 33 | 12 | 41.1 | 0 | 125 | 27 | 18 | 50 | GHU69831.1 deoxyribonuclease [Spirochaetia bacterium] | diamond | 99 | 43.5 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetia bacterium | |||||
| 31195925 | 31195925 | PRJNA1067370_P_NODE_73195_length_260_cov_1.235294_g72646_i0 | PRJNA1067370 | 73195 | 260 | 1.235294 | 3.2117644 | root | 1 | Root_unresolved | Root_unresolved | 43.5 | 0.0249 | NR | MBR5645669.1 | 166 | g72646 | i0 | 41.9 | 3.53076923076923 | 62 | 24 | 71.5 | 1 | 206 | 21 | 55 | 104 | MBR5645669.1 ankyrin repeat domain-containing protein [Treponema sp.] | diamond | 918 | 43.9 | 0.990888382687927 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Treponemataceae | Treponema | Treponema sp. | ||
| 31204197 | 31204197 | PRJNA1067370_P_NODE_62635_length_276_cov_1.073892_g62086_i0 | PRJNA1067370 | 62635 | 276 | 1.073892 | 2.96394192 | Spirochaetae bacterium HGW-Spirochaetae-8 | 2013840 | Bacteria | Bacteria | 65.1 | 5.83e-10 | NR | PKL14600.1 | 2013840 | g62086 | i0 | 51.6 | 7.40217391304348 | 62 | 30 | 67.4 | 0 | 226 | 41 | 86 | 147 | PKL14600.1 MAG: TIGR02452 family protein [Spirochaetae bacterium HGW-Spirochaetae-8] | diamond | 2043 | 65.1 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetae bacterium HGW-Spirochaetae-8 | ||||||
| 31481296 | 31481296 | PRJNA1067370_P_NODE_42336_length_312_cov_1.933054_g41788_i0 | PRJNA1067370 | 42336 | 312 | 1.933054 | 6.03112848 | root | 1 | Root_unresolved | Root_unresolved | 43.9 | 0.013 | NR | KAB2932045.1 | 183 | g41788 | i0 | 43.2 | 1.48076923076923 | 44 | 22 | 39.4 | 1 | 237 | 115 | 96 | 139 | KAB2932045.1 MAG: hypothetical protein F9K24_12235 [Leptonema illini] | diamond | 462 | 43.9 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Leptospirales | Leptospiraceae | Leptonema | Leptonema illini | ||
| 31773932 | 31773932 | PRJNA1067370_P_NODE_91437_length_248_cov_0.880000_g90888_i0 | PRJNA1067370 | 91437 | 248 | 0.88 | 2.1824 | Spirochaetales bacterium | 2026792 | Bacteria | Bacteria | 108 | 1.62e-25 | NR | MFP4377323.1 | 2026792 | g90888 | i0 | 63.8 | 1.91129032258065 | 80 | 29 | 96.8 | 0 | 5 | 244 | 168 | 247 | MFP4377323.1 ferric reductase-like transmembrane domain-containing protein [Spirochaetales bacterium] | diamond | 474 | 108 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Spirochaetales bacterium | ||||
| 32216989 | 32216989 | PRJNA1067370_P_NODE_54638_length_288_cov_1.255814_g54089_i0 | PRJNA1067370 | 54638 | 288 | 1.255814 | 3.61674432 | Spirochaetota bacterium | 2202144 | Bacteria | Bacteria | 66.2 | 1.05e-10 | NR | MFH0976764.1 | 2202144 | g54089 | i0 | 48.4 | 4.80208333333333 | 62 | 32 | 64.6 | 0 | 1 | 186 | 36 | 97 | MFH0976764.1 metallophosphoesterase family protein [Spirochaetota bacterium] | diamond | 1383 | 66.2 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetota bacterium | ||||||
| 32406896 | 32406896 | PRJNA1067370_P_NODE_97899_length_246_cov_0.890173_g97350_i0 | PRJNA1067370 | 97899 | 246 | 0.890173 | 2.18982558 | Leptospiraceae bacterium | 2026757 | Bacteria | Bacteria | 53.5 | 5.36e-6 | NR | MCB1173051.1 | 2026757 | g97350 | i0 | 43.2 | 0.902439024390244 | 74 | 37 | 84.1 | 1 | 17 | 223 | 175 | 248 | MCB1173051.1 alpha/beta hydrolase [Leptospiraceae bacterium] | diamond | 222 | 53.5 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Leptospirales | Leptospiraceae | Leptospiraceae bacterium | |||
| 32493484 | 32493484 | PRJNA1067370_P_NODE_100839_length_245_cov_0.895349_g100290_i0 | PRJNA1067370 | 100839 | 245 | 0.895349 | 2.19360505 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 94.7 | 6e-21 | NR | PJE00441.1 | 178 | g100290 | i0 | 57.1 | 3.73469387755102 | 77 | 33 | 94.3 | 0 | 5 | 235 | 82 | 158 | PJE00441.1 MAG: gluconolactonase [Leptospira sp.] | diamond | 915 | 94.7 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Leptospirales | Leptospiraceae | Leptospira | Leptospira sp. | ||
| 32659171 | 32659171 | PRJNA1067370_P_NODE_53640_length_289_cov_1.782407_g53091_i0 | PRJNA1067370 | 53640 | 289 | 1.782407 | 5.15115623 | Spirochaetaceae bacterium | 1898206 | Bacteria | Bacteria | 48.1 | 8.24e-4 | NR | MBL8968026.1 | 1898206 | g53091 | i0 | 40.8 | 0.508650519031142 | 49 | 28 | 49.8 | 1 | 225 | 82 | 476 | 524 | MBL8968026.1 adenylate/guanylate cyclase domain-containing protein [Spirochaetaceae bacterium] | diamond | 147 | 48.1 | 1 | Bacteria | Pseudomonadati | Spirochaetota | Spirochaetia | Spirochaetales | Spirochaetaceae | Spirochaetaceae 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);;