contig_metadata
17 rows where bioproject = "PRJNA635874" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1884317 | 1884317 | PRJNA635874_P_NODE_64822_length_244_cov_0.900585_g64675_i0 | PRJNA635874 | 64822 | 244 | 0.900585 | 2.1974274 | Bacteria | 2 | Bacteria | Bacteria | 80.5 | 1.13e-15 | NR | WP_058866807.1 | 458033 | g64675 | i0 | 48.1 | 12.9098360655738 | 81 | 42 | 99.6 | 0 | 243 | 1 | 72 | 152 | WP_058866807.1 radical SAM protein [Chloracidobacterium thermophilum] | diamond | 3150 | 80.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Chloracidobacterium | Chloracidobacterium thermophilum | ||
| 9536814 | 9536814 | PRJNA635874_P_NODE_72948_length_241_cov_0.916667_g72801_i0 | PRJNA635874 | 72948 | 241 | 0.916667 | 2.20916747 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 131 | 9.049999999999999e-35 | NR | HEY0428781.1 | 2283092 | g72801 | i0 | 76.3 | 2.98755186721992 | 80 | 19 | 99.6 | 0 | 2 | 241 | 241 | 320 | HEY0428781.1 radical SAM family heme chaperone HemW [Pyrinomonadaceae bacterium] | diamond | 720 | 131 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 26669189 | 26669189 | PRJNA635874_P_NODE_51481_length_249_cov_0.875000_g51334_i0 | PRJNA635874 | 51481 | 249 | 0.875 | 2.17875 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 85.5 | 3.57e-17 | NR | HMT07525.1 | 2283092 | g51334 | i0 | 60.8 | 0.891566265060241 | 74 | 28 | 89.2 | 1 | 24 | 245 | 25 | 97 | HMT07525.1 choice-of-anchor Q domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 222 | 85.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 26891383 | 26891383 | PRJNA635874_P_NODE_62781_length_245_cov_0.895349_g62634_i0 | PRJNA635874 | 62781 | 245 | 0.895349 | 2.19360505 | Acidobacteriaceae bacterium | 2052142 | Bacteria | Bacteria | 51.6 | 2.8e-5 | NR | HZC43019.1 | 2052142 | g62634 | i0 | 37.3 | 1.88571428571429 | 83 | 45 | 93.1 | 1 | 14 | 241 | 104 | 186 | HZC43019.1 PAS domain-containing protein [Acidobacteriaceae bacterium] | diamond | 462 | 51.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Acidobacteriaceae bacterium | |||
| 28155037 | 28155037 | PRJNA635874_P_NODE_67225_length_243_cov_0.905882_g67078_i0 | PRJNA635874 | 67225 | 243 | 0.905882 | 2.20129326 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 80.1 | 2.6e-15 | NR | HSK62488.1 | 2283092 | g67078 | i0 | 75 | 0.641975308641975 | 52 | 13 | 64.2 | 0 | 86 | 241 | 6 | 57 | HSK62488.1 galactose oxidase early set domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 156 | 80.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28186145 | 28186145 | PRJNA635874_P_NODE_54266_length_248_cov_0.880000_g54119_i0 | PRJNA635874 | 54266 | 248 | 0.88 | 2.1824 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 63.5 | 6.99e-10 | NR | MET0753628.1 | 2283092 | g54119 | i0 | 96.7 | 0.362903225806452 | 30 | 1 | 36.3 | 0 | 247 | 158 | 193 | 222 | MET0753628.1 twin-arginine translocase subunit TatC [Pyrinomonadaceae bacterium] | diamond | 90 | 63.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28280902 | 28280902 | PRJNA635874_P_NODE_12586_length_422_cov_2.246418_g12439_i0 | PRJNA635874 | 12586 | 422 | 2.246418 | 9.47988396 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 51.2 | 1.39e-4 | NR | HYX28426.1 | 2283092 | g12439 | i0 | 31.1 | 1.06635071090047 | 74 | 48 | 52.6 | 2 | 162 | 383 | 129 | 199 | HYX28426.1 saposin domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 450 | 51.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28691815 | 28691815 | PRJNA635874_P_NODE_70447_length_242_cov_0.911243_g70300_i0 | PRJNA635874 | 70447 | 242 | 0.911243 | 2.20520806 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 144 | 4.209999999999999e-40 | NR | MET0754273.1 | 2283092 | g70300 | i0 | 87.5 | 3.96694214876033 | 80 | 10 | 99.2 | 0 | 240 | 1 | 119 | 198 | MET0754273.1 tyrosine-type recombinase/integrase [Pyrinomonadaceae bacterium] | diamond | 960 | 144 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 30143809 | 30143809 | PRJNA635874_P_NODE_72232_length_241_cov_0.916667_g72085_i0 | PRJNA635874 | 72232 | 241 | 0.916667 | 2.20916747 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 140 | 1.1800000000000001e-36 | NR | MBL8241830.1 | 2026791 | g72085 | i0 | 83.3 | 2.09128630705394 | 84 | 10 | 99.6 | 1 | 241 | 2 | 102 | 185 | MBL8241830.1 pyrroloquinoline quinone-dependent dehydrogenase [Bryobacterales bacterium] | diamond | 504 | 140 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 30870839 | 30870839 | PRJNA635874_P_NODE_54194_length_248_cov_0.880000_g54047_i0 | PRJNA635874 | 54194 | 248 | 0.88 | 2.1824 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 119 | 2.39e-30 | NR | HVE56526.1 | 2283092 | g54047 | i0 | 70.7 | 0.991935483870968 | 82 | 24 | 99.2 | 0 | 248 | 3 | 99 | 180 | HVE56526.1 M15 family metallopeptidase [Pyrinomonadaceae bacterium] | diamond | 246 | 119 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 30915086 | 30915086 | PRJNA635874_P_NODE_47814_length_251_cov_0.865169_g47667_i0 | PRJNA635874 | 47814 | 251 | 0.865169 | 2.17157419 | Bacteria | 2 | Bacteria | Bacteria | 52.4 | 1.49e-5 | NR | MBE21253.1 | 1978231 | g47667 | i0 | 65 | 1.01593625498008 | 40 | 14 | 47.8 | 0 | 124 | 5 | 47 | 86 | MBE21253.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 255 | 52.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31060717 | 31060717 | PRJNA635874_P_NODE_61735_length_245_cov_0.895349_g61588_i0 | PRJNA635874 | 61735 | 245 | 0.895349 | 2.19360505 | Holophagae bacterium | 2073116 | Bacteria | Bacteria | 48.9 | 2.59e-4 | NR | PWB68978.1 | 2073116 | g61588 | i0 | 34.2 | 0.96734693877551 | 79 | 50 | 96.7 | 1 | 4 | 240 | 369 | 445 | PWB68978.1 MAG: hypothetical protein C3F15_15745 [Holophagae bacterium] | diamond | 237 | 48.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Holophagae | Holophagae bacterium | |||||
| 31313288 | 31313288 | PRJNA635874_P_NODE_68435_length_243_cov_0.905882_g68288_i0 | PRJNA635874 | 68435 | 243 | 0.905882 | 2.20129326 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 127 | 1.8899999999999998e-34 | NR | MFB3904366.1 | 1978231 | g68288 | i0 | 82.5 | 2.96296296296296 | 80 | 14 | 98.8 | 0 | 241 | 2 | 102 | 181 | MFB3904366.1 TerC family protein [Acidobacteriota bacterium] | diamond | 720 | 127 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31345034 | 31345034 | PRJNA635874_P_NODE_58876_length_246_cov_0.890173_g58729_i0 | PRJNA635874 | 58876 | 246 | 0.890173 | 2.18982558 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 109 | 2.58e-29 | NR | HJX26711.1 | 2651171 | g58729 | i0 | 81.7 | 0.731707317073171 | 60 | 11 | 73.2 | 0 | 245 | 66 | 12 | 71 | HJX26711.1 hypothetical protein [Thermoanaerobaculia bacterium] | diamond | 180 | 109 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 32040916 | 32040916 | PRJNA635874_P_NODE_70798_length_242_cov_0.911243_g70651_i0 | PRJNA635874 | 70798 | 242 | 0.911243 | 2.20520806 | Terriglobus sp. RCC_193 | 3239218 | Bacteria | Bacteria | 42.4 | 0.0497 | NR | WP_371083002.1 | 3239218 | g70651 | i0 | 48.6 | 0.45867768595041303 | 37 | 19 | 45.9 | 0 | 168 | 58 | 184 | 220 | WP_371083002.1 sensor domain-containing diguanylate cyclase [Terriglobus sp. RCC_193] | diamond | 111 | 42.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terriglobus | Terriglobus sp. RCC_193 | ||
| 32798909 | 32798909 | PRJNA635874_P_NODE_49200_length_250_cov_0.870056_g49053_i0 | PRJNA635874 | 49200 | 250 | 0.870056 | 2.17514 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 118 | 3e-29 | NR | MBL8241420.1 | 2026791 | g49053 | i0 | 88.9 | 0.756 | 63 | 7 | 75.6 | 0 | 249 | 61 | 407 | 469 | MBL8241420.1 DUF1501 domain-containing protein [Bryobacterales bacterium] | diamond | 189 | 118 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 32830617 | 32830617 | PRJNA635874_P_NODE_14140_length_403_cov_1.400000_g13993_i0 | PRJNA635874 | 14140 | 403 | 1.4 | 5.642 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 123 | 1.18e-29 | NR | MDQ3816202.1 | 1978231 | g13993 | i0 | 46.6 | 0.990074441687345 | 133 | 71 | 99 | 0 | 2 | 400 | 200 | 332 | MDQ3816202.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 399 | 123 | 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);;