contig_metadata
14 rows where bioproject = "PRJNA1237347" and tax_phylum = "Calditrichota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20741760 | 20741760 | PRJNA1237347_P_NODE_287257_length_343_cov_1.600000_g280684_i0 | PRJNA1237347 | 287257 | 343 | 1.6 | 5.488 | Calditrichota bacterium | 2212469 | Bacteria | Bacteria | 137 | 2.81e-37 | NR | MCB0280215.1 | 2212469 | g280684 | i0 | 62.3 | 0.997084548104956 | 114 | 40 | 99.7 | 1 | 2 | 343 | 70 | 180 | MCB0280215.1 3-hydroxybutyryl-CoA dehydrogenase [Calditrichota bacterium] | diamond | 342 | 137 | 1 | Bacteria | Pseudomonadati | Calditrichota | Calditrichota bacterium | ||||||
| 26692922 | 26692922 | PRJNA1237347_P_NODE_146201_length_533_cov_1.532609_g139654_i0 | PRJNA1237347 | 146201 | 533 | 1.532609 | 8.16880597 | Calditrichota bacterium | 2212469 | Bacteria | Bacteria | 50.1 | 0.00155 | NR | KAA3654828.1 | 2212469 | g139654 | i0 | 26.3 | 1.00750469043152 | 179 | 115 | 95.1 | 5 | 508 | 2 | 185 | 356 | KAA3654828.1 MAG: hypothetical protein DWQ10_17540 [Calditrichota bacterium] | diamond | 537 | 50.1 | 1 | Bacteria | Pseudomonadati | Calditrichota | Calditrichota bacterium | ||||||
| 27104467 | 27104467 | PRJNA1237347_P_NODE_288222_length_342_cov_2.215613_g281649_i0 | PRJNA1237347 | 288222 | 342 | 2.215613 | 7.57739646 | Caldithrix abyssi | 187145 | Bacteria | Bacteria | 102 | 1.96e-22 | NR | HGY55116.1 | 187145 | g281649 | i0 | 44.2 | 0.991228070175439 | 113 | 62 | 98.2 | 1 | 338 | 3 | 110 | 222 | HGY55116.1 amino acid adenylation domain-containing protein [Caldithrix abyssi] | diamond | 339 | 102 | 1 | Bacteria | Pseudomonadati | Calditrichota | Calditrichia | Calditrichales | Calditrichaceae | Caldithrix | Caldithrix abyssi | ||
| 27673208 | 27673208 | PRJNA1237347_P_NODE_122104_length_599_cov_2.066540_g115587_i0 | PRJNA1237347 | 122104 | 599 | 2.06654 | 12.3785746 | Calditrichota bacterium | 2212469 | Bacteria | Bacteria | 84.3 | 4.86e-15 | NR | RMF60661.1 | 2212469 | g115587 | i0 | 27.1 | 2.52420701168614 | 166 | 102 | 73.6 | 3 | 3 | 443 | 640 | 805 | RMF60661.1 MAG: hypothetical protein D6748_03635 [Calditrichota bacterium] | diamond | 1512 | 84.3 | 1 | Bacteria | Pseudomonadati | Calditrichota | Calditrichota bacterium | ||||||
| 27944517 | 27944517 | PRJNA1237347_P_NODE_519225_length_245_cov_1.343023_g512652_i0 | PRJNA1237347 | 519225 | 245 | 1.343023 | 3.29040635 | Bacteria | 2 | Bacteria | Bacteria | 114 | 3.42e-27 | NR | MCB0276867.1 | 2212469 | g512652 | i0 | 56.8 | 1.98367346938776 | 81 | 35 | 99.2 | 0 | 245 | 3 | 233 | 313 | MCB0276867.1 PAS domain S-box protein [Calditrichota bacterium] | diamond | 486 | 114 | 1 | Bacteria | Pseudomonadati | Calditrichota | Calditrichota bacterium | ||||||
| 28291637 | 28291637 | PRJNA1237347_P_NODE_84326_length_760_cov_2.094614_g78157_i0 | PRJNA1237347 | 84326 | 760 | 2.094614 | 15.9190664 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 106 | 4.600000000000001e-22 | NR | MEL6823102.1 | 2212469 | g78157 | i0 | 50 | 1.89078947368421 | 110 | 53 | 42.6 | 1 | 326 | 3 | 130 | 239 | MEL6823102.1 GMC family oxidoreductase N-terminal domain-containing protein [Calditrichota bacterium] | diamond | 1437 | 106 | 1 | Bacteria | Pseudomonadati | Calditrichota | Calditrichota bacterium | ||||||
| 29220861 | 29220861 | PRJNA1237347_P_NODE_526849_length_244_cov_1.350877_g520276_i0 | PRJNA1237347 | 526849 | 244 | 1.350877 | 3.29613988 | Calditrichaceae bacterium | 2614252 | Bacteria | Bacteria | 108 | 1.26e-26 | NR | MBN1408227.1 | 2614252 | g520276 | i0 | 62.8 | 0.959016393442623 | 78 | 29 | 95.9 | 0 | 9 | 242 | 71 | 148 | MBN1408227.1 Dam family site-specific DNA-(adenine-N6)-methyltransferase [Calditrichaceae bacterium] | diamond | 234 | 108 | 1 | Bacteria | Pseudomonadati | Calditrichota | Calditrichia | Calditrichales | Calditrichaceae | Calditrichaceae bacterium | |||
| 29946882 | 29946882 | PRJNA1237347_P_NODE_406131_length_277_cov_1.392157_g399558_i0 | PRJNA1237347 | 406131 | 277 | 1.392157 | 3.85627489 | Calditrichaceae bacterium | 2614252 | Bacteria | Bacteria | 99 | 4.3399999999999996e-23 | NR | MBN2423826.1 | 2614252 | g399558 | i0 | 57.3 | 0.888086642599278 | 82 | 32 | 85.6 | 1 | 237 | 1 | 1 | 82 | MBN2423826.1 FkbM family methyltransferase [Calditrichaceae bacterium] | diamond | 246 | 99 | 1 | Bacteria | Pseudomonadati | Calditrichota | Calditrichia | Calditrichales | Calditrichaceae | Calditrichaceae bacterium | |||
| 30502371 | 30502371 | PRJNA1237347_P_NODE_528833_length_244_cov_0.900585_g522260_i0 | PRJNA1237347 | 528833 | 244 | 0.900585 | 2.1974274 | Caldithrix | 187144 | Bacteria | Bacteria | 45.1 | 0.00247 | NR | TDI86137.1 | 1962856 | g522260 | i0 | 37.7 | 1.69672131147541 | 69 | 40 | 84.8 | 1 | 20 | 226 | 73 | 138 | TDI86137.1 MAG: gamma-glutamylcyclotransferase [Caldithrix sp.] | diamond | 414 | 45.1 | 1 | Bacteria | Pseudomonadati | Calditrichota | Calditrichia | Calditrichales | Calditrichaceae | Caldithrix | Caldithrix sp. | ||
| 30547204 | 30547204 | PRJNA1237347_P_NODE_475313_length_251_cov_0.865169_g468740_i0 | PRJNA1237347 | 475313 | 251 | 0.865169 | 2.17157419 | Caldithrix sp. | 1962856 | Bacteria | Bacteria | 43.5 | 0.0226 | NR | MBD3226233.1 | 1962856 | g468740 | i0 | 47.8 | 0.549800796812749 | 46 | 21 | 55 | 1 | 147 | 10 | 817 | 859 | MBD3226233.1 T9SS type A sorting domain-containing protein [Caldithrix sp.] | diamond | 138 | 43.5 | 1 | Bacteria | Pseudomonadati | Calditrichota | Calditrichia | Calditrichales | Calditrichaceae | Caldithrix | Caldithrix sp. | ||
| 31146748 | 31146748 | PRJNA1237347_P_NODE_221375_length_405_cov_2.533133_g214803_i0 | PRJNA1237347 | 221375 | 405 | 2.533133 | 10.25918865 | Calditrichota bacterium | 2212469 | Bacteria | Bacteria | 132 | 5.700000000000001e-34 | NR | KAA3610150.1 | 2212469 | g214803 | i0 | 48.5 | 3.03703703703704 | 136 | 69 | 100 | 1 | 1 | 405 | 49 | 184 | KAA3610150.1 MAG: diaminopimelate decarboxylase [Calditrichota bacterium] | diamond | 1230 | 132 | 1 | Bacteria | Pseudomonadati | Calditrichota | Calditrichota bacterium | ||||||
| 31400599 | 31400599 | PRJNA1237347_P_NODE_425976_length_269_cov_1.178571_g419403_i0 | PRJNA1237347 | 425976 | 269 | 1.178571 | 3.17035599 | Calditrichota bacterium | 2212469 | Bacteria | Bacteria | 93.6 | 1.09e-20 | NR | MCZ6819923.1 | 2212469 | g419403 | i0 | 47.2 | 0.992565055762082 | 89 | 46 | 98.1 | 1 | 268 | 5 | 106 | 194 | MCZ6819923.1 alpha/beta fold hydrolase [Calditrichota bacterium] | diamond | 267 | 93.6 | 1 | Bacteria | Pseudomonadati | Calditrichota | Calditrichota bacterium | ||||||
| 31640206 | 31640206 | PRJNA1237347_P_NODE_68916_length_865_cov_1.609848_g63150_i0 | PRJNA1237347 | 68916 | 865 | 1.609848 | 13.9251852 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 85.9 | 5.32e-15 | NR | MCB1060596.1 | 2212469 | g63150 | i0 | 34.9 | 1.02312138728324 | 149 | 97 | 51.7 | 0 | 408 | 854 | 7 | 155 | MCB1060596.1 FIST C-terminal domain-containing protein [Calditrichota bacterium] | diamond | 885 | 85.9 | 1 | Bacteria | Pseudomonadati | Calditrichota | Calditrichota bacterium | ||||||
| 32872491 | 32872491 | PRJNA1237347_P_NODE_113820_length_627_cov_2.990975_g107337_i0 | PRJNA1237347 | 113820 | 627 | 2.990975 | 18.75341325 | Bacteria | 2 | Bacteria | Bacteria | 84.7 | 4.43e-15 | NR | MCB0276467.1 | 2212469 | g107337 | i0 | 52 | 1.17224880382775 | 75 | 36 | 35.9 | 0 | 398 | 622 | 7 | 81 | MCB0276467.1 PD40 domain-containing protein [Calditrichota bacterium] | diamond | 735 | 84.7 | 1 | Bacteria | Pseudomonadati | Calditrichota | Calditrichota 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);;