contig_metadata
27 rows where bioproject = "PRJNA980587", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14983628 | 14983628 | PRJNA980587_P_NODE_52832_length_316_cov_0.864198_g52039_i0 | PRJNA980587 | 52832 | 316 | 0.864198 | 2.73086568 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 436 | 6.9899999999999996e-118 | NTclustered | gi|2874254159|emb|OY970389.1| | 2283092 | g52039 | i0 | 91.385 | 127 | 325 | 19 | 100 | 7 | 1 | 316 | 2616571 | 2616895 | MAG: Pyrinomonadaceae bacterium isolate MFD09206.bin.c.1 genome assembly, chromosome: 1 | blastn | 40132 | 436 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 26773015 | 26773015 | PRJNA980587_P_NODE_19221_length_584_cov_1.326810_g18436_i0 | PRJNA980587 | 19221 | 584 | 1.32681 | 7.7485704 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 155 | 1.18e-42 | NR | MDR3737318.1 | 2052142 | g18436 | i0 | 46.9 | 1.00684931506849 | 196 | 93 | 98.1 | 5 | 583 | 11 | 118 | 307 | MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium] | diamond | 588 | 155 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 26836490 | 26836490 | PRJNA980587_P_NODE_74541_length_259_cov_1.655914_g73748_i0 | PRJNA980587 | 74541 | 259 | 1.655914 | 4.28881726 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 45.1 | 0.00692 | NR | MBN8724370.1 | 1978231 | g73748 | i0 | 40 | 0.752895752895753 | 65 | 35 | 71.8 | 2 | 258 | 73 | 480 | 543 | MBN8724370.1 malate synthase A [Acidobacteriota bacterium] | diamond | 195 | 45.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 26994309 | 26994309 | PRJNA980587_P_NODE_62002_length_288_cov_1.432558_g61209_i0 | PRJNA980587 | 62002 | 288 | 1.432558 | 4.12576704 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 74.7 | 3.77e-13 | NR | HZQ71000.1 | 2282142 | g61209 | i0 | 46.9 | 1 | 96 | 49 | 99 | 2 | 3 | 287 | 746 | 840 | HZQ71000.1 Ig-like domain repeat protein [Terriglobales bacterium] | diamond | 288 | 74.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 27474700 | 27474700 | PRJNA980587_P_NODE_33383_length_412_cov_1.834808_g32590_i0 | PRJNA980587 | 33383 | 412 | 1.834808 | 7.55940896 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 130 | 1.11e-33 | NR | MDA0206063.1 | 1978231 | g32590 | i0 | 52 | 13.1359223300971 | 125 | 60 | 91 | 0 | 412 | 38 | 165 | 289 | MDA0206063.1 quinone oxidoreductase [Acidobacteriota bacterium] | diamond | 5412 | 130 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27626665 | 27626665 | PRJNA980587_P_NODE_85484_length_247_cov_0.885057_g84691_i0 | PRJNA980587 | 85484 | 247 | 0.885057 | 2.18609079 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 73.2 | 7.15e-13 | NR | HKR12569.1 | 2283092 | g84691 | i0 | 50.7 | 0.88663967611336 | 73 | 32 | 88.7 | 2 | 224 | 6 | 184 | 252 | HKR12569.1 FAD-dependent oxidoreductase [Pyrinomonadaceae bacterium] | diamond | 219 | 73.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27784588 | 27784588 | PRJNA980587_P_NODE_91444_length_243_cov_0.905882_g90651_i0 | PRJNA980587 | 91444 | 243 | 0.905882 | 2.20129326 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 137 | 5.3199999999999995e-37 | NR | MCD9188357.1 | 2283092 | g90651 | i0 | 87.5 | 1.96296296296296 | 80 | 10 | 98.8 | 0 | 242 | 3 | 129 | 208 | MCD9188357.1 c-type cytochrome [Pyrinomonadaceae bacterium] | diamond | 477 | 137 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27816154 | 27816154 | PRJNA980587_P_NODE_47804_length_333_cov_2.150000_g47011_i0 | PRJNA980587 | 47804 | 333 | 2.15 | 7.1595 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 86.3 | 4.88e-17 | NR | MBX3265733.1 | 1978231 | g47011 | i0 | 38.9 | 2.04504504504505 | 108 | 62 | 94.6 | 3 | 316 | 2 | 125 | 231 | MBX3265733.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 681 | 86.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28011671 | 28011671 | PRJNA980587_P_NODE_77265_length_253_cov_1.622222_g76472_i0 | PRJNA980587 | 77265 | 253 | 1.622222 | 4.10422166 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 117 | 5.43e-30 | NR | HUH63403.1 | 1964191 | g76472 | i0 | 68.7 | 12.7944664031621 | 83 | 26 | 98.4 | 0 | 1 | 249 | 144 | 226 | HUH63403.1 aldolase/citrate lyase family protein [Terracidiphilus sp.] | diamond | 3237 | 118 | 0.991525423728814 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terracidiphilus | Terracidiphilus sp. | ||
| 28289390 | 28289390 | PRJNA980587_P_NODE_88246_length_245_cov_0.895349_g87453_i0 | PRJNA980587 | 88246 | 245 | 0.895349 | 2.19360505 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 60.5 | 2.24e-9 | NR | HEU0175738.1 | 2052146 | g87453 | i0 | 52.3 | 0.538775510204082 | 44 | 21 | 53.9 | 0 | 1 | 132 | 87 | 130 | HEU0175738.1 hypothetical protein [Blastocatellia bacterium] | diamond | 132 | 60.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 28516725 | 28516725 | PRJNA980587_P_NODE_20647_length_558_cov_4.214433_g19859_i0 | PRJNA980587 | 20647 | 558 | 4.214433 | 23.51653614 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 130 | 4.31e-34 | NR | HMG74784.1 | 2283092 | g19859 | i0 | 58.2 | 2.62903225806452 | 98 | 41 | 52.7 | 0 | 536 | 243 | 94 | 191 | HMG74784.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 1467 | 130 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28769173 | 28769173 | PRJNA980587_P_NODE_33427_length_412_cov_1.353982_g32634_i0 | PRJNA980587 | 33427 | 412 | 1.353982 | 5.57840584 | Bacteria | 2 | Bacteria | Bacteria | 182 | 7.749999999999999e-55 | NR | MBS1831214.1 | 1978231 | g32634 | i0 | 65.9 | 19.5145631067961 | 135 | 42 | 98.3 | 1 | 407 | 3 | 54 | 184 | MBS1831214.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 8040 | 182 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29053549 | 29053549 | PRJNA980587_P_NODE_74788_length_259_cov_1.236559_g73995_i0 | PRJNA980587 | 74788 | 259 | 1.236559 | 3.20268781 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 60.8 | 7.95e-9 | NR | MBI3951118.1 | 1978231 | g73995 | i0 | 40.9 | 3.91505791505792 | 66 | 39 | 76.4 | 0 | 206 | 9 | 73 | 138 | MBI3951118.1 PDZ domain-containing protein [Acidobacteriota bacterium] | diamond | 1014 | 60.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29110583 | 29110583 | PRJNA980587_P_NODE_59348_length_295_cov_1.995495_g58555_i0 | PRJNA980587 | 59348 | 295 | 1.995495 | 5.88671025 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 43.9 | 0.0216 | NR | MFN0172054.1 | 2212468 | g58555 | i0 | 37.7 | 0.783050847457627 | 77 | 44 | 75.3 | 2 | 287 | 66 | 139 | 214 | MFN0172054.1 PEP-CTERM sorting domain-containing protein [Bryobacteraceae bacterium] | diamond | 231 | 43.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 29337628 | 29337628 | PRJNA980587_P_NODE_67409_length_275_cov_1.905941_g66616_i0 | PRJNA980587 | 67409 | 275 | 1.905941 | 5.24133775 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 80.1 | 3.26e-15 | NR | MDQ3131979.1 | 1978231 | g66616 | i0 | 45.2 | 2.81454545454545 | 84 | 46 | 91.6 | 0 | 257 | 6 | 34 | 117 | MDQ3131979.1 VWA domain-containing protein [Acidobacteriota bacterium] | diamond | 774 | 80.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29457470 | 29457470 | PRJNA980587_P_NODE_94910_length_241_cov_0.916667_g94117_i0 | PRJNA980587 | 94910 | 241 | 0.916667 | 2.20916747 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 165 | 3.64e-45 | NR | MEW6361357.1 | 1978231 | g94117 | i0 | 100 | 0.995850622406639 | 80 | 0 | 99.6 | 0 | 1 | 240 | 146 | 225 | MEW6361357.1 sigma 54-interacting transcriptional regulator [Acidobacteriota bacterium] | diamond | 240 | 165 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29684581 | 29684581 | PRJNA980587_P_NODE_85270_length_247_cov_0.885057_g84477_i0 | PRJNA980587 | 85270 | 247 | 0.885057 | 2.18609079 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 84.3 | 2.06e-17 | NR | HVF89017.1 | 2052146 | g84477 | i0 | 59.2 | 8.65991902834008 | 71 | 24 | 80.2 | 1 | 247 | 50 | 208 | 278 | HVF89017.1 amidohydrolase family protein [Blastocatellia bacterium] | diamond | 2139 | 84.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 29868293 | 29868293 | PRJNA980587_P_NODE_24631_length_500_cov_1.615925_g23840_i0 | PRJNA980587 | 24631 | 500 | 1.615925 | 8.079625 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 52.4 | 2.16e-4 | NR | MEJ2147214.1 | 1978231 | g23840 | i0 | 45.9 | 1.008 | 61 | 27 | 33 | 2 | 497 | 333 | 131 | 191 | MEJ2147214.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 504 | 52.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30311081 | 30311081 | PRJNA980587_P_NODE_31852_length_424_cov_3.635328_g31059_i0 | PRJNA980587 | 31852 | 424 | 3.635328 | 15.41379072 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 166 | 1.84e-49 | NR | MBI2214083.1 | 1978231 | g31059 | i0 | 74.8 | 2.17924528301887 | 103 | 26 | 72.9 | 0 | 3 | 311 | 63 | 165 | MBI2214083.1 peptidylprolyl isomerase [Acidobacteriota bacterium] | diamond | 924 | 166 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30342692 | 30342692 | PRJNA980587_P_NODE_61652_length_289_cov_1.398148_g60859_i0 | PRJNA980587 | 61652 | 289 | 1.398148 | 4.04064772 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 71.2 | 6.13e-12 | NR | MEM7048688.1 | 1978231 | g60859 | i0 | 37.9 | 1.06920415224913 | 103 | 56 | 98.6 | 2 | 2 | 286 | 383 | 485 | MEM7048688.1 SDR family oxidoreductase [Acidobacteriota bacterium] | diamond | 309 | 71.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30689595 | 30689595 | PRJNA980587_P_NODE_78773_length_251_cov_0.865169_g77980_i0 | PRJNA980587 | 78773 | 251 | 0.865169 | 2.17157419 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 53.9 | 1.95e-6 | NR | HVF92138.1 | 2052146 | g77980 | i0 | 54.8 | 0.50199203187251 | 42 | 19 | 50.2 | 0 | 125 | 250 | 17 | 58 | HVF92138.1 M23 family metallopeptidase [Blastocatellia bacterium] | diamond | 126 | 53.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 30879227 | 30879227 | PRJNA980587_P_NODE_51234_length_321_cov_1.241935_g50441_i0 | PRJNA980587 | 51234 | 321 | 1.241935 | 3.98661135 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 55.8 | 1.97e-6 | NR | HEV7902221.1 | 2283092 | g50441 | i0 | 35.8 | 0.757009345794392 | 81 | 50 | 75.7 | 2 | 2 | 244 | 164 | 242 | HEV7902221.1 S1/P1 nuclease [Pyrinomonadaceae bacterium] | diamond | 243 | 55.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31581025 | 31581025 | PRJNA980587_P_NODE_79236_length_251_cov_0.865169_g78443_i0 | PRJNA980587 | 79236 | 251 | 0.865169 | 2.17157419 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 84 | 3.48e-17 | NR | MCB1050173.1 | 1978231 | g78443 | i0 | 51.9 | 2.98804780876494 | 81 | 38 | 96.8 | 1 | 1 | 243 | 191 | 270 | MCB1050173.1 S-methyl-5'-thioadenosine phosphorylase [Acidobacteriota bacterium] | diamond | 750 | 84 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31992084 | 31992084 | PRJNA980587_P_NODE_79638_length_250_cov_1.740113_g78845_i0 | PRJNA980587 | 79638 | 250 | 1.740113 | 4.3502825 | Bacteria | 2 | Bacteria | Bacteria | 84.7 | 2.72e-17 | NR | MCG6928898.1 | 1978231 | g78845 | i0 | 49.3 | 4.728 | 75 | 37 | 90 | 1 | 225 | 1 | 6 | 79 | MCG6928898.1 Gfo/Idh/MocA family oxidoreductase [Acidobacteriota bacterium] | diamond | 1182 | 84.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32207555 | 32207555 | PRJNA980587_P_NODE_11878_length_792_cov_2.020862_g11160_i0 | PRJNA980587 | 11878 | 792 | 2.020862 | 16.00522704 | Holophagaceae bacterium | 2052165 | Bacteria | Bacteria | 160 | 5.79e-45 | NR | NTW86739.1 | 2052165 | g11160 | i0 | 50 | 2.48484848484848 | 152 | 74 | 57.2 | 2 | 308 | 760 | 36 | 186 | NTW86739.1 peroxiredoxin [Holophagaceae bacterium] | diamond | 1968 | 160 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagales | Holophagaceae | Holophagaceae bacterium | |||
| 32207572 | 32207572 | PRJNA980587_P_NODE_94438_length_241_cov_0.916667_g93645_i0 | PRJNA980587 | 94438 | 241 | 0.916667 | 2.20916747 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 100 | 1.01e-22 | NR | HVT94521.1 | 2212468 | g93645 | i0 | 65.3 | 0.896265560165975 | 72 | 25 | 89.6 | 0 | 21 | 236 | 129 | 200 | HVT94521.1 type VI secretion system baseplate subunit TssK [Bryobacteraceae bacterium] | diamond | 216 | 100 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 32681280 | 32681280 | PRJNA980587_P_NODE_68060_length_274_cov_1.283582_g67267_i0 | PRJNA980587 | 68060 | 274 | 1.283582 | 3.51701468 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 95.1 | 6.9e-22 | NR | MFN2454516.1 | 2283092 | g67267 | i0 | 61.4 | 0.766423357664234 | 70 | 27 | 76.6 | 0 | 6 | 215 | 139 | 208 | MFN2454516.1 carbonate dehydratase [Pyrinomonadaceae bacterium] | diamond | 210 | 95.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae 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);;