contig_metadata
20 rows where bioproject = "PRJNA792582", tax_kingdom = "Pseudomonadati" and tax_phylum = "Acidobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3328068 | 3328068 | PRJNA792582_P_NODE_33023_length_300_cov_1.356828_g32209_i0 | PRJNA792582 | 33023 | 300 | 1.356828 | 4.070484 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 390 | 5.209999999999999e-104 | NTclustered | gi|2874253710|emb|OY969475.1| | 2283092 | g32209 | i0 | 90.132 | 176.2 | 304 | 25 | 100 | 5 | 1 | 300 | 1821090 | 1821392 | MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1 | blastn | 52860 | 390 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 3767096 | 3767096 | PRJNA792582_P_NODE_32643_length_302_cov_1.650655_g31829_i0 | PRJNA792582 | 32643 | 302 | 1.650655 | 4.9849781 | Bacteria | 2 | Bacteria | Bacteria | 335 | 2.49e-87 | NTclustered | gi|2874254061|emb|OY970385.1| | 2026791 | g31829 | i0 | 87.755 | 284.033112582781 | 294 | 26 | 97 | 6 | 9 | 301 | 2775923 | 2776207 | MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1 | blastn | 85778 | 335 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 5880619 | 5880619 | PRJNA792582_P_NODE_52385_length_248_cov_1.685714_g51571_i0 | PRJNA792582 | 52385 | 248 | 1.685714 | 4.18057072 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 388 | 1.51e-103 | NTclustered | gi|2874254091|emb|OY970174.1| | 171953 | g51571 | i0 | 95.161 | 440.931451612903 | 248 | 9 | 99 | 3 | 3 | 248 | 4356911 | 4357157 | MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1 | blastn | 109351 | 388 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 7155312 | 7155312 | PRJNA792582_P_NODE_32806_length_301_cov_1.960526_g31992_i0 | PRJNA792582 | 32806 | 301 | 1.960526 | 5.90118326 | uncultured Bryobacterales bacterium | 2569091 | Bacteria | Bacteria | 237 | 7.210000000000001e-58 | NTclustered | gi|2546137838|emb|OY282420.1| | 2569091 | g31992 | i0 | 81.373 | 210.906976744186 | 306 | 44 | 100 | 12 | 1 | 301 | 989741 | 990038 | MAG: uncultured Bryobacterales bacterium isolate 78526416-339a-45b8-a6d3-8fabb82c2801 genome assembly, chromosome: 1 | blastn | 63483 | 237 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | uncultured Bryobacterales bacterium | ||||
| 26990246 | 26990246 | PRJNA792582_P_NODE_53582_length_247_cov_0.885057_g52768_i0 | PRJNA792582 | 53582 | 247 | 0.885057 | 2.18609079 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 46.6 | 0.00173 | NR | HEV2855820.1 | 2651171 | g52768 | i0 | 42.6 | 0.57085020242915 | 47 | 27 | 57.1 | 0 | 53 | 193 | 349 | 395 | HEV2855820.1 IPT/TIG domain-containing protein [Thermoanaerobaculia bacterium] | diamond | 141 | 46.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 27370146 | 27370146 | PRJNA792582_P_NODE_46263_length_260_cov_2.754011_g45449_i0 | PRJNA792582 | 46263 | 260 | 2.754011 | 7.1604286 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 147 | 2.75e-40 | NR | HYI92671.1 | 2212468 | g45449 | i0 | 77.6 | 0.980769230769231 | 85 | 19 | 98.1 | 0 | 259 | 5 | 220 | 304 | HYI92671.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 255 | 147 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 27464734 | 27464734 | PRJNA792582_P_NODE_50863_length_250_cov_0.870056_g50049_i0 | PRJNA792582 | 50863 | 250 | 0.870056 | 2.17514 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 168 | 1.83e-49 | NR | MBP6823786.1 | 1978231 | g50049 | i0 | 96.4 | 1.992 | 83 | 3 | 99.6 | 0 | 249 | 1 | 34 | 116 | MBP6823786.1 3-phosphoserine/phosphohydroxythreonine transaminase [Acidobacteriota bacterium] | diamond | 498 | 168 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29106526 | 29106526 | PRJNA792582_P_NODE_46288_length_260_cov_2.278075_g45474_i0 | PRJNA792582 | 46288 | 260 | 2.278075 | 5.922995 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 42.7 | 0.0431 | NR | MCI0407439.1 | 1978231 | g45474 | i0 | 36.5 | 0.726923076923077 | 63 | 37 | 72.7 | 2 | 17 | 205 | 39 | 98 | MCI0407439.1 acyl-CoA desaturase [Acidobacteriota bacterium] | diamond | 189 | 42.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29169731 | 29169731 | PRJNA792582_P_NODE_49429_length_251_cov_1.730337_g48615_i0 | PRJNA792582 | 49429 | 251 | 1.730337 | 4.34314587 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 158 | 2.87e-46 | NR | HCG37378.1 | 1978231 | g48615 | i0 | 100 | 0.99203187250996006 | 83 | 0 | 99.2 | 0 | 250 | 2 | 46 | 128 | HCG37378.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 249 | 158 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29359080 | 29359080 | PRJNA792582_P_NODE_23609_length_355_cov_1.088652_g22795_i0 | PRJNA792582 | 23609 | 355 | 1.088652 | 3.8647146 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 61.2 | 4.31e-8 | NR | MBX3294083.1 | 1978231 | g22795 | i0 | 45.6 | 0.667605633802817 | 79 | 42 | 66.8 | 1 | 354 | 118 | 424 | 501 | MBX3294083.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 237 | 61.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29800950 | 29800950 | PRJNA792582_P_NODE_50631_length_250_cov_1.152542_g49817_i0 | PRJNA792582 | 50631 | 250 | 1.152542 | 2.881355 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 69.3 | 1.76e-11 | NR | HSK74762.1 | 2283092 | g49817 | i0 | 42 | 2.532 | 81 | 45 | 94.8 | 1 | 244 | 8 | 356 | 436 | HSK74762.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 633 | 69.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29927590 | 29927590 | PRJNA792582_P_NODE_40451_length_276_cov_2.492611_g39637_i0 | PRJNA792582 | 40451 | 276 | 2.492611 | 6.87960636 | Granulicella mallensis | 940614 | Bacteria | Bacteria | 45.1 | 0.00817 | NR | WP_014263320.1 | 940614 | g39637 | i0 | 34.8 | 0.75 | 69 | 43 | 73.9 | 2 | 247 | 44 | 206 | 273 | WP_014263320.1 glycoside hydrolase family 28 protein [Granulicella mallensis] | diamond | 207 | 45.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Granulicella | Granulicella mallensis | ||
| 31042768 | 31042768 | PRJNA792582_P_NODE_35475_length_289_cov_4.115741_g34661_i0 | PRJNA792582 | 35475 | 289 | 4.115741 | 11.89449149 | Bacteria | 2 | Bacteria | Bacteria | 43.5 | 0.0338 | NR | PYQ27580.1 | 1978231 | g34661 | i0 | 28.9 | 1.57785467128028 | 76 | 40 | 64.4 | 2 | 246 | 61 | 211 | 286 | PYQ27580.1 MAG: hypothetical protein DMF56_19565 [Acidobacteriota bacterium] | diamond | 456 | 43.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31127641 | 31127641 | PRJNA792582_P_NODE_42155_length_272_cov_1.512563_g41341_i0 | PRJNA792582 | 42155 | 272 | 1.512563 | 4.11417136 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 46.6 | 0.00219 | NR | HEV2646267.1 | 2052142 | g41341 | i0 | 40 | 0.716911764705882 | 65 | 32 | 68.4 | 3 | 247 | 62 | 41 | 101 | HEV2646267.1 M48 family metallopeptidase [Acidobacteriaceae bacterium] | diamond | 195 | 46.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 31254407 | 31254407 | PRJNA792582_P_NODE_55715_length_245_cov_0.895349_g54901_i0 | PRJNA792582 | 55715 | 245 | 0.895349 | 2.19360505 | Terriglobia bacterium | 2081523 | Bacteria | Bacteria | 89.7 | 1.45e-19 | NR | MDD5542077.1 | 2081523 | g54901 | i0 | 58 | 2.97551020408163 | 81 | 34 | 99.2 | 0 | 2 | 244 | 123 | 203 | MDD5542077.1 FTR1 family protein [Terriglobia bacterium] | diamond | 729 | 89.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobia bacterium | |||||
| 31507667 | 31507667 | PRJNA792582_P_NODE_22456_length_364_cov_0.790378_g21642_i0 | PRJNA792582 | 22456 | 364 | 0.790378 | 2.87697592 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 45.4 | 0.0146 | NR | HZR24276.1 | 2910147 | g21642 | i0 | 48.6 | 0.288461538461538 | 35 | 18 | 28.8 | 0 | 326 | 222 | 137 | 171 | HZR24276.1 radical SAM protein [Vicinamibacterales bacterium] | diamond | 105 | 45.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 31539247 | 31539247 | PRJNA792582_P_NODE_50536_length_250_cov_1.451977_g49722_i0 | PRJNA792582 | 50536 | 250 | 1.451977 | 3.6299425 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 92.8 | 9.9e-20 | NR | MEO6966032.1 | 2052142 | g49722 | i0 | 58.5 | 0.984 | 82 | 33 | 98.4 | 1 | 246 | 1 | 62 | 142 | MEO6966032.1 DUF6259 domain-containing protein [Acidobacteriaceae bacterium] | diamond | 246 | 92.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 32076924 | 32076924 | PRJNA792582_P_NODE_45538_length_263_cov_0.910526_g44724_i0 | PRJNA792582 | 45538 | 263 | 0.910526 | 2.39468338 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 42.4 | 0.0493 | NR | MFN2578657.1 | 2283092 | g44724 | i0 | 40.5 | 0.422053231939163 | 37 | 22 | 42.2 | 0 | 188 | 78 | 34 | 70 | MFN2578657.1 DUF2585 family protein [Pyrinomonadaceae bacterium] | diamond | 111 | 42.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32307882 | 32307882 | PRJNA792582_P_NODE_25219_length_344_cov_1.446494_g24405_i0 | PRJNA792582 | 25219 | 344 | 1.446494 | 4.97593936 | Acidobacteriota | 57723 | Bacteria | Bacteria | 105 | 5.85e-24 | NR | WP_415199918.1 | 1964179 | g24405 | i0 | 76.8 | 2.45058139534884 | 69 | 16 | 60.2 | 0 | 207 | 1 | 9 | 77 | WP_415199918.1 IMP dehydrogenase [Silvibacterium sp.] | diamond | 843 | 105 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Silvibacterium | Silvibacterium sp. | ||
| 32551801 | 32551801 | PRJNA792582_P_NODE_47039_length_258_cov_2.059459_g46225_i0 | PRJNA792582 | 47039 | 258 | 2.059459 | 5.31340422 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 44.7 | 0.00878 | NR | MBU6240550.1 | 1978231 | g46225 | i0 | 62.1 | 0.337209302325581 | 29 | 11 | 33.7 | 0 | 232 | 146 | 254 | 282 | MBU6240550.1 molybdopterin-dependent oxidoreductase [Acidobacteriota bacterium] | diamond | 87 | 44.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota 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);;