contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA681822" and tax_phylum = "Gemmatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3722463 | 3722463 | PRJNA681822_P_NODE_384243_length_251_cov_0.865169_g382754_i0 | PRJNA681822 | 384243 | 251 | 0.865169 | 2.17157419 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 143 | 1.4099999999999999e-40 | NR | HYR10054.1 | 2029185 | g382754 | i0 | 85.7 | 1.00398406374502 | 84 | 11 | 99.2 | 1 | 2 | 250 | 8 | 91 | HYR10054.1 DDE-type integrase/transposase/recombinase [Longimicrobium sp.] | diamond | 252 | 143 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 7032164 | 7032164 | PRJNA681822_P_NODE_256466_length_285_cov_1.292453_g254977_i0 | PRJNA681822 | 256466 | 285 | 1.292453 | 3.68349105 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 135 | 2.2099999999999993e-34 | NR | MBA3892972.1 | 2448054 | g254977 | i0 | 72.3 | 3.95789473684211 | 94 | 23 | 98.9 | 1 | 284 | 3 | 475 | 565 | MBA3892972.1 response regulator [Gemmatimonadales bacterium] | diamond | 1128 | 135 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 8307431 | 8307431 | PRJNA681822_P_NODE_310207_length_271_cov_2.065657_g308718_i0 | PRJNA681822 | 310207 | 271 | 2.065657 | 5.59793047 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 186 | 7.060000000000001e-58 | NR | HET9514801.1 | 2448054 | g308718 | i0 | 100 | 0.996309963099631 | 90 | 0 | 99.6 | 0 | 271 | 2 | 110 | 199 | HET9514801.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 270 | 186 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 9584288 | 9584288 | PRJNA681822_P_NODE_441448_length_245_cov_0.895349_g439959_i0 | PRJNA681822 | 441448 | 245 | 0.895349 | 2.19360505 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 62.8 | 3.09e-9 | NR | PYP53864.1 | 2026742 | g439959 | i0 | 63.6 | 0.538775510204082 | 44 | 15 | 53.9 | 1 | 237 | 106 | 223 | 265 | PYP53864.1 MAG: hypothetical protein DMD45_00580 [Gemmatimonadota bacterium] | diamond | 132 | 62.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 12136032 | 12136032 | PRJNA681822_P_NODE_56550_length_496_cov_2.094563_g55082_i0 | PRJNA681822 | 56550 | 496 | 2.094563 | 10.38903248 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 320 | 6.79e-100 | NR | MEE8596102.1 | 2026742 | g55082 | i0 | 100 | 0.991935483870968 | 164 | 0 | 99.2 | 0 | 494 | 3 | 254 | 417 | MEE8596102.1 amino acid adenylation domain-containing protein [Gemmatimonadota bacterium] | diamond | 492 | 320 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 21054834 | 21054834 | PRJNA681822_P_NODE_16097_length_950_cov_1.670468_g14984_i0 | PRJNA681822 | 16097 | 950 | 1.670468 | 15.869446 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 309 | 3.449999999999999e-99 | NR | HEU5170203.1 | 2448054 | g14984 | i0 | 68.4 | 2.60210526315789 | 212 | 66 | 66.9 | 1 | 949 | 314 | 243 | 453 | HEU5170203.1 acetyl ornithine aminotransferase family protein [Gemmatimonadales bacterium] | diamond | 2472 | 311 | 0.993569131832797 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 23609021 | 23609021 | PRJNA681822_P_NODE_464679_length_243_cov_0.905882_g463189_i0 | PRJNA681822 | 464679 | 243 | 0.905882 | 2.20129326 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 133 | 5.79e-34 | NR | MDX2260556.1 | 2448054 | g463189 | i0 | 76.3 | 1.97530864197531 | 80 | 19 | 98.8 | 0 | 2 | 241 | 485 | 564 | MDX2260556.1 carbamoyl-phosphate synthase large subunit [Gemmatimonadales bacterium] | diamond | 480 | 133 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 26765527 | 26765527 | PRJNA681822_P_NODE_329161_length_266_cov_1.595855_g327672_i0 | PRJNA681822 | 329161 | 266 | 1.595855 | 4.2449743 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 171 | 2.6299999999999996e-47 | NR | MEE8596102.1 | 2026742 | g327672 | i0 | 100 | 0.992481203007519 | 88 | 0 | 99.2 | 0 | 264 | 1 | 154 | 241 | MEE8596102.1 amino acid adenylation domain-containing protein [Gemmatimonadota bacterium] | diamond | 264 | 171 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 26797186 | 26797186 | PRJNA681822_P_NODE_410081_length_248_cov_1.754286_g408592_i0 | PRJNA681822 | 410081 | 248 | 1.754286 | 4.35062928 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 144 | 1.66e-42 | NR | HET9387417.1 | 2448054 | g408592 | i0 | 81.7 | 0.991935483870968 | 82 | 15 | 99.2 | 0 | 1 | 246 | 21 | 102 | HET9387417.1 DinB family protein [Gemmatimonadales bacterium] | diamond | 246 | 144 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 26840869 | 26840869 | PRJNA681822_P_NODE_447161_length_244_cov_3.602339_g445671_i0 | PRJNA681822 | 447161 | 244 | 3.602339 | 8.78970716 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 67.4 | 7.93e-11 | NR | MEJ7760449.1 | 2026741 | g445671 | i0 | 46.9 | 2.86475409836066 | 81 | 41 | 97.1 | 1 | 2 | 238 | 17 | 97 | MEJ7760449.1 SusC/RagA family TonB-linked outer membrane protein [Gemmatimonadaceae bacterium] | diamond | 699 | 67.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 27871625 | 27871625 | PRJNA681822_P_NODE_242545_length_288_cov_1.432558_g241056_i0 | PRJNA681822 | 242545 | 288 | 1.432558 | 4.12576704 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 114 | 5.079999999999999e-31 | NR | HEX7117863.1 | 2910168 | g241056 | i0 | 61.4 | 6.01041666666667 | 83 | 32 | 86.5 | 0 | 253 | 5 | 1 | 83 | HEX7117863.1 ATP synthase F1 subunit epsilon [Longimicrobiales bacterium] | diamond | 1731 | 114 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 28187174 | 28187174 | PRJNA681822_P_NODE_252826_length_286_cov_1.150235_g251337_i0 | PRJNA681822 | 252826 | 286 | 1.150235 | 3.2896721 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 44.3 | 0.0173 | NR | MEI2718846.1 | 2448054 | g251337 | i0 | 57.5 | 0.41958041958042 | 40 | 17 | 42 | 0 | 244 | 125 | 362 | 401 | MEI2718846.1 ATP-binding cassette domain-containing protein [Gemmatimonadales bacterium] | diamond | 120 | 44.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 28661135 | 28661135 | PRJNA681822_P_NODE_395747_length_250_cov_0.870056_g394258_i0 | PRJNA681822 | 395747 | 250 | 0.870056 | 2.17514 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 137 | 1.68e-38 | NR | HEX9939174.1 | 2029185 | g394258 | i0 | 85.9 | 1.884 | 78 | 11 | 93.6 | 0 | 249 | 16 | 120 | 197 | HEX9939174.1 alpha/beta fold hydrolase [Longimicrobium sp.] | diamond | 471 | 137 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 28881957 | 28881957 | PRJNA681822_P_NODE_388528_length_251_cov_0.865169_g387039_i0 | PRJNA681822 | 388528 | 251 | 0.865169 | 2.17157419 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 92.8 | 1.58e-21 | NR | HKP15078.1 | 2026741 | g387039 | i0 | 58.3 | 4.9601593625498 | 84 | 32 | 99.2 | 2 | 3 | 251 | 49 | 130 | HKP15078.1 GNAT family N-acetyltransferase [Gemmatimonadaceae bacterium] | diamond | 1245 | 92.8 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 29008681 | 29008681 | PRJNA681822_P_NODE_315028_length_270_cov_1.563452_g313539_i0 | PRJNA681822 | 315028 | 270 | 1.563452 | 4.2213204 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 109 | 1.39e-25 | NR | HEY4320290.1 | 2448054 | g313539 | i0 | 63.6 | 0.977777777777778 | 88 | 32 | 97.8 | 0 | 264 | 1 | 196 | 283 | HEY4320290.1 DNA ligase D [Gemmatimonadales bacterium] | diamond | 264 | 109 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29702595 | 29702595 | PRJNA681822_P_NODE_460090_length_243_cov_0.905882_g458600_i0 | PRJNA681822 | 460090 | 243 | 0.905882 | 2.20129326 | Longimicrobiaceae bacterium | 3047548 | Bacteria | Bacteria | 113 | 9.76e-30 | NR | HEU0077616.1 | 3047548 | g458600 | i0 | 67.5 | 0.987654320987654 | 80 | 26 | 98.8 | 0 | 3 | 242 | 52 | 131 | HEU0077616.1 hypothetical protein [Longimicrobiaceae bacterium] | diamond | 240 | 113 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobiaceae bacterium | ||
| 29797554 | 29797554 | PRJNA681822_P_NODE_248751_length_287_cov_1.102804_g247262_i0 | PRJNA681822 | 248751 | 287 | 1.102804 | 3.16504748 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 96.7 | 7.27e-22 | NR | HSK21375.1 | 2910168 | g247262 | i0 | 62.1 | 2.90592334494774 | 95 | 36 | 99.3 | 0 | 287 | 3 | 150 | 244 | HSK21375.1 tetratricopeptide repeat protein [Longimicrobiales bacterium] | diamond | 834 | 96.7 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 30347048 | 30347048 | PRJNA681822_P_NODE_333032_length_265_cov_1.604167_g331543_i0 | PRJNA681822 | 333032 | 265 | 1.604167 | 4.25104255 | Bacteria | 2 | Bacteria | Bacteria | 56.6 | 5.58e-7 | NR | HEX5832177.1 | 2026741 | g331543 | i0 | 63.8 | 1.66415094339623 | 47 | 16 | 53.2 | 1 | 265 | 125 | 266 | 311 | HEX5832177.1 formate dehydrogenase accessory sulfurtransferase FdhD [Gemmatimonadaceae bacterium] | diamond | 441 | 56.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30713885 | 30713885 | PRJNA681822_P_NODE_488374_length_234_cov_2.832298_g486884_i0 | PRJNA681822 | 488374 | 234 | 2.832298 | 6.62757732 | Gemmatirosa sp. | 2510638 | Bacteria | Bacteria | 79.3 | 4.26e-15 | NR | HZF69192.1 | 2510638 | g486884 | i0 | 89.1 | 0.58974358974359 | 46 | 5 | 59 | 0 | 232 | 95 | 214 | 259 | HZF69192.1 response regulator [Gemmatirosa sp.] | diamond | 138 | 79.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa sp. | |
| 30935195 | 30935195 | PRJNA681822_P_NODE_416814_length_248_cov_0.880000_g415325_i0 | PRJNA681822 | 416814 | 248 | 0.88 | 2.1824 | Longimicrobiaceae bacterium | 3047548 | Bacteria | Bacteria | 103 | 2.19e-23 | NR | MET0396662.1 | 3047548 | g415325 | i0 | 65 | 1.92338709677419 | 80 | 27 | 96.8 | 1 | 5 | 244 | 525 | 603 | MET0396662.1 amino acid adenylation domain-containing protein [Longimicrobiaceae bacterium] | diamond | 477 | 103 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobiaceae bacterium | ||
| 31009992 | 31009992 | PRJNA681822_P_NODE_358974_length_258_cov_1.248649_g357485_i0 | PRJNA681822 | 358974 | 258 | 1.248649 | 3.22151442 | Bacteria | 2 | Bacteria | Bacteria | 108 | 8.43e-26 | NR | HKG93306.1 | 2026741 | g357485 | i0 | 70 | 9.59302325581395 | 80 | 24 | 93 | 0 | 6 | 245 | 291 | 370 | HKG93306.1 trifunctional transcriptional activator/DNA repair protein Ada/methylated-DNA--[protein]-cysteine S-methyltransferase [Gemmatimonadaceae bacterium] | diamond | 2475 | 109 | 0.990825688073395 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 31061756 | 31061756 | PRJNA681822_P_NODE_437815_length_245_cov_2.529070_g436326_i0 | PRJNA681822 | 437815 | 245 | 2.52907 | 6.1962215 | Longimicrobiales bacterium | 2910168 | Bacteria | Bacteria | 43.9 | 0.015 | NR | HUF76180.1 | 2910168 | g436326 | i0 | 32.1 | 0.955102040816327 | 78 | 50 | 91.8 | 1 | 244 | 20 | 188 | 265 | HUF76180.1 TonB-dependent receptor [Longimicrobiales bacterium] | diamond | 234 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiales bacterium | |||
| 31630588 | 31630588 | PRJNA681822_P_NODE_330676_length_266_cov_1.290155_g329187_i0 | PRJNA681822 | 330676 | 266 | 1.290155 | 3.4318123 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 176 | 1.96e-51 | NR | HSJ76591.1 | 2448054 | g329187 | i0 | 94.3 | 0.992481203007519 | 88 | 5 | 99.2 | 0 | 1 | 264 | 103 | 190 | HSJ76591.1 IS701 family transposase [Gemmatimonadales bacterium] | diamond | 264 | 176 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31788548 | 31788548 | PRJNA681822_P_NODE_267337_length_282_cov_1.473684_g265848_i0 | PRJNA681822 | 267337 | 282 | 1.473684 | 4.15578888 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 146 | 6.42e-40 | NR | MBY0489852.1 | 2026741 | g265848 | i0 | 70.2 | 1 | 94 | 28 | 100 | 0 | 1 | 282 | 89 | 182 | MBY0489852.1 sterol desaturase family protein [Gemmatimonadaceae bacterium] | diamond | 282 | 146 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32768525 | 32768525 | PRJNA681822_P_NODE_247060_length_287_cov_1.439252_g245571_i0 | PRJNA681822 | 247060 | 287 | 1.439252 | 4.13065324 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 79.3 | 2.4e-15 | NR | HKH93424.1 | 2026741 | g245571 | i0 | 47 | 1.78745644599303 | 83 | 44 | 86.8 | 0 | 250 | 2 | 57 | 139 | HKH93424.1 FkbM family methyltransferase [Gemmatimonadaceae bacterium] | diamond | 513 | 79.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae 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);;