contig_metadata
21 rows where bioproject = "PRJNA902848", tax_clade = "FCB group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4710566 | 4710566 | PRJNA902848_P_NODE_18064_length_245_cov_0.906977_g18014_i0 | PRJNA902848 | 18064 | 245 | 0.906977 | 2.22209365 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 261 | 3.38e-65 | NTclustered | gi|2874253978|emb|OY970303.1| | 412054 | g18014 | i0 | 86.066 | 99.2571428571429 | 244 | 32 | 99 | 2 | 1 | 243 | 1359119 | 1359361 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1 | blastn | 24318 | 261 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 5075128 | 5075128 | PRJNA902848_P_NODE_18904_length_244_cov_0.912281_g18854_i0 | PRJNA902848 | 18904 | 244 | 0.912281 | 2.22596564 | FCB group | 1783270 | Bacteria | Bacteria | 136 | 4.77e-36 | NR | HEX6536236.1 | 2026741 | g18854 | i0 | 75.3 | 21.9098360655738 | 81 | 20 | 99.6 | 0 | 1 | 243 | 85 | 165 | HEX6536236.1 multicopper oxidase family protein [Gemmatimonadaceae bacterium] | diamond | 5346 | 137 | 0.992700729927007 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 11085521 | 11085521 | PRJNA902848_P_NODE_13589_length_252_cov_0.871508_g13539_i0 | PRJNA902848 | 13589 | 252 | 0.871508 | 2.19620016 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 128 | 4.62e-36 | NR | HRZ10354.1 | 2448054 | g13539 | i0 | 98.4 | 0.738095238095238 | 62 | 1 | 73.8 | 0 | 65 | 250 | 1 | 62 | HRZ10354.1 NAD(P)-binding domain-containing protein [Gemmatimonadales bacterium] | diamond | 186 | 128 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 17460076 | 17460076 | PRJNA902848_P_NODE_13174_length_253_cov_0.866667_g13124_i0 | PRJNA902848 | 13174 | 253 | 0.866667 | 2.19266751 | Gemmatimonadetes bacterium SCN 7 | 1660163 | Bacteria | Bacteria | 158 | 5.36e-44 | NR | ODT04656.1 | 1660163 | g13124 | i0 | 97.6 | 0.99604743083004 | 84 | 2 | 99.6 | 0 | 252 | 1 | 332 | 415 | ODT04656.1 MAG: hypothetical protein ABS52_03395 [Gemmatimonadetes bacterium SCN 70-22] | diamond | 252 | 158 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadetes bacterium SCN 70-22 | |||||
| 18733384 | 18733384 | PRJNA902848_P_NODE_14435_length_251_cov_0.876404_g14385_i0 | PRJNA902848 | 14435 | 251 | 0.876404 | 2.19977404 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 129 | 1.09e-32 | NR | MFN8668002.1 | 2026741 | g14385 | i0 | 79.5 | 0.99203187250996006 | 83 | 17 | 99.2 | 0 | 249 | 1 | 322 | 404 | MFN8668002.1 AAA family ATPase [Gemmatimonadaceae bacterium] | diamond | 249 | 129 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 20008520 | 20008520 | PRJNA902848_P_NODE_13856_length_252_cov_0.871508_g13806_i0 | PRJNA902848 | 13856 | 252 | 0.871508 | 2.19620016 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 198 | 2.77e-46 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g13806 | i0 | 81.893 | 1.97222222222222 | 243 | 36 | 95 | 8 | 2 | 240 | 4156739 | 4156501 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 497 | 198 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 28161484 | 28161484 | PRJNA902848_P_NODE_18405_length_245_cov_0.906977_g18355_i0 | PRJNA902848 | 18405 | 245 | 0.906977 | 2.22209365 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 99.4 | 4.62e-22 | NR | MCC6319373.1 | 2026741 | g18355 | i0 | 63 | 0.991836734693878 | 81 | 30 | 99.2 | 0 | 3 | 245 | 58 | 138 | MCC6319373.1 response regulator [Gemmatimonadaceae bacterium] | diamond | 243 | 99.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 28540411 | 28540411 | PRJNA902848_P_NODE_14887_length_250_cov_0.881356_g14837_i0 | PRJNA902848 | 14887 | 250 | 0.881356 | 2.20339 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 127 | 7.48e-35 | NR | HWP38926.1 | 2448054 | g14837 | i0 | 77.1 | 0.996 | 83 | 19 | 99.6 | 0 | 2 | 250 | 46 | 128 | HWP38926.1 cation transporter [Gemmatimonadales bacterium] | diamond | 249 | 127 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29108631 | 29108631 | PRJNA902848_P_NODE_12968_length_253_cov_0.866667_g12918_i0 | PRJNA902848 | 12968 | 253 | 0.866667 | 2.19266751 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 152 | 5.22e-42 | NR | HOX21243.1 | 2448054 | g12918 | i0 | 86.9 | 0.99604743083004 | 84 | 11 | 99.6 | 0 | 2 | 253 | 50 | 133 | HOX21243.1 DUF2779 domain-containing protein [Gemmatimonadales bacterium] | diamond | 252 | 152 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29487198 | 29487198 | PRJNA902848_P_NODE_10570_length_278_cov_1.468293_g10520_i0 | PRJNA902848 | 10570 | 278 | 1.468293 | 4.08185454 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 120 | 1.7900000000000002e-33 | NR | HOX20784.1 | 2448054 | g10520 | i0 | 85.5 | 1.48920863309353 | 69 | 10 | 74.5 | 0 | 276 | 70 | 22 | 90 | HOX20784.1 MoaD/ThiS family protein [Gemmatimonadales bacterium] | diamond | 414 | 120 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29581776 | 29581776 | PRJNA902848_P_NODE_19290_length_243_cov_0.917647_g19240_i0 | PRJNA902848 | 19290 | 243 | 0.917647 | 2.22988221 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 132 | 1.49e-33 | NR | MCE9603221.1 | 2026742 | g19240 | i0 | 82.5 | 0.987654320987654 | 80 | 14 | 98.8 | 0 | 3 | 242 | 1381 | 1460 | MCE9603221.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 240 | 132 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 29803067 | 29803067 | PRJNA902848_P_NODE_20351_length_242_cov_0.923077_g20301_i0 | PRJNA902848 | 20351 | 242 | 0.923077 | 2.23384634 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 144 | 1.78e-41 | NR | HET9465202.1 | 2448054 | g20301 | i0 | 95 | 0.991735537190083 | 80 | 4 | 99.2 | 0 | 242 | 3 | 121 | 200 | HET9465202.1 phosphoribosylglycinamide formyltransferase [Gemmatimonadales bacterium] | diamond | 240 | 144 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 29929676 | 29929676 | PRJNA902848_P_NODE_14471_length_251_cov_0.876404_g14421_i0 | PRJNA902848 | 14471 | 251 | 0.876404 | 2.19977404 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 144 | 1.93e-39 | NR | TFG46727.1 | 2448054 | g14421 | i0 | 92.7 | 0.9800796812749 | 82 | 6 | 98 | 0 | 1 | 246 | 334 | 415 | TFG46727.1 MAG: ATP-dependent Clp protease ATP-binding subunit ClpX [Gemmatimonadales bacterium] | diamond | 246 | 144 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 30277388 | 30277388 | PRJNA902848_P_NODE_16192_length_248_cov_0.891429_g16142_i0 | PRJNA902848 | 16192 | 248 | 0.891429 | 2.21074392 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 117 | 3.41e-30 | NR | HEX6966268.1 | 2026741 | g16142 | i0 | 70.7 | 1.98387096774194 | 82 | 24 | 99.2 | 0 | 2 | 247 | 43 | 124 | HEX6966268.1 sugar kinase [Gemmatimonadaceae bacterium] | diamond | 492 | 117 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30372207 | 30372207 | PRJNA902848_P_NODE_17972_length_245_cov_0.906977_g17922_i0 | PRJNA902848 | 17972 | 245 | 0.906977 | 2.22209365 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 120 | 1.99e-30 | NR | MBK6845210.1 | 2026742 | g17922 | i0 | 100 | 0.722448979591837 | 59 | 0 | 72.2 | 0 | 67 | 243 | 1 | 59 | MBK6845210.1 hypothetical protein [Gemmatimonadota bacterium] | diamond | 177 | 120 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30561147 | 30561147 | PRJNA902848_P_NODE_19913_length_242_cov_0.923077_g19863_i0 | PRJNA902848 | 19913 | 242 | 0.923077 | 2.23384634 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 152 | 1.1599999999999999e-42 | NR | MBL8989908.1 | 2026742 | g19863 | i0 | 96.3 | 0.991735537190083 | 80 | 3 | 99.2 | 0 | 3 | 242 | 116 | 195 | MBL8989908.1 GAF domain-containing sensor histidine kinase [Gemmatimonadota bacterium] | diamond | 240 | 152 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30592878 | 30592878 | PRJNA902848_P_NODE_18473_length_245_cov_0.901163_g18423_i0 | PRJNA902848 | 18473 | 245 | 0.901163 | 2.20784935 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 85.5 | 4.45e-18 | NR | HUF90176.1 | 2026742 | g18423 | i0 | 48.8 | 0.979591836734694 | 80 | 41 | 98 | 0 | 4 | 243 | 119 | 198 | HUF90176.1 phytanoyl-CoA dioxygenase family protein [Gemmatimonadota bacterium] | diamond | 240 | 85.5 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30751024 | 30751024 | PRJNA902848_P_NODE_13214_length_253_cov_0.866667_g13164_i0 | PRJNA902848 | 13214 | 253 | 0.866667 | 2.19266751 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 119 | 5.37e-29 | NR | MCI0432222.1 | 2026742 | g13164 | i0 | 66.3 | 1.94466403162055 | 83 | 28 | 98.4 | 0 | 1 | 249 | 504 | 586 | MCI0432222.1 BamA/TamA family outer membrane protein [Gemmatimonadota bacterium] | diamond | 492 | 119 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 31636039 | 31636039 | PRJNA902848_P_NODE_20436_length_242_cov_0.875740_g20386_i0 | PRJNA902848 | 20436 | 242 | 0.87574 | 2.1192908 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 166 | 2.39e-51 | NR | HOX19346.1 | 2448054 | g20386 | i0 | 96.3 | 0.991735537190083 | 80 | 3 | 99.2 | 0 | 3 | 242 | 28 | 107 | HOX19346.1 4a-hydroxytetrahydrobiopterin dehydratase [Gemmatimonadales bacterium] | diamond | 240 | 166 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32181611 | 32181611 | PRJNA902848_P_NODE_11498_length_268_cov_1.292308_g11448_i0 | PRJNA902848 | 11498 | 268 | 1.292308 | 3.46338544 | Bacteria | 2 | Bacteria | Bacteria | 108 | 4.7199999999999995e-25 | NR | HEY5022424.1 | 2026741 | g11448 | i0 | 62.5 | 13.1194029850746 | 80 | 28 | 89.6 | 1 | 6 | 245 | 518 | 595 | HEY5022424.1 glycoside hydrolase family 3 N-terminal domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 3516 | 108 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32332455 | 32332455 | PRJNA902848_P_NODE_15259_length_250_cov_0.881356_g15209_i0 | PRJNA902848 | 15259 | 250 | 0.881356 | 2.20339 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 125 | 3.16e-31 | NR | HOX20743.1 | 2448054 | g15209 | i0 | 87.8 | 0.984 | 82 | 10 | 98.4 | 0 | 248 | 3 | 632 | 713 | HOX20743.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 246 | 125 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales 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);;