contig_metadata
15 rows where bioproject = "PRJNA1111082", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2296703 | 2296703 | PRJNA1111082_P_NODE_11802_length_246_cov_0.901734_g11757_i0 | PRJNA1111082 | 11802 | 246 | 0.901734 | 2.21826564 | Gemmatimonadetes bacterium T265 | 2839016 | Bacteria | Bacteria | 131 | 2.07e-33 | NR | GJG86145.1 | 2839016 | g11757 | i0 | 82.9 | 1 | 82 | 10 | 100 | 1 | 1 | 246 | 405 | 482 | GJG86145.1 hypothetical protein tb265_13260 [Gemmatimonadetes bacterium T265] | diamond | 246 | 131 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadetes bacterium T265 | |||||
| 2765911 | 2765911 | PRJNA1111082_P_NODE_11103_length_249_cov_1.625000_g11058_i0 | PRJNA1111082 | 11103 | 249 | 1.625 | 4.04625 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 263 | 9.56e-66 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g11058 | i0 | 85.83 | 76.6947791164659 | 247 | 35 | 99 | 0 | 3 | 249 | 4458012 | 4458258 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 19097 | 263 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 4042058 | 4042058 | PRJNA1111082_P_NODE_12044_length_245_cov_0.906977_g11999_i0 | PRJNA1111082 | 12044 | 245 | 0.906977 | 2.22209365 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 261 | 3.38e-65 | NTclustered | gi|2874253789|emb|OY969773.1| | 412054 | g11999 | i0 | 87.179 | 1.9469387755102 | 234 | 24 | 95 | 5 | 12 | 243 | 98961 | 98732 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 | blastn | 477 | 261 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 7868012 | 7868012 | PRJNA1111082_P_NODE_12427_length_243_cov_0.917647_g12382_i0 | PRJNA1111082 | 12427 | 243 | 0.917647 | 2.22988221 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 202 | 2.0599999999999995e-47 | NTclustered | gi|2874253789|emb|OY969773.1| | 412054 | g12382 | i0 | 82.7 | 0.975308641975309 | 237 | 32 | 98 | 7 | 3 | 239 | 1018823 | 1019050 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 | blastn | 237 | 202 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 9142885 | 9142885 | PRJNA1111082_P_NODE_12028_length_245_cov_0.906977_g11983_i0 | PRJNA1111082 | 12028 | 245 | 0.906977 | 2.22209365 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 252 | 2.0299999999999998e-62 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g11983 | i0 | 86.463 | 2.57142857142857 | 229 | 31 | 93 | 0 | 17 | 245 | 3862120 | 3861892 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 630 | 252 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis | |
| 10418691 | 10418691 | PRJNA1111082_P_NODE_11789_length_246_cov_0.901734_g11744_i0 | PRJNA1111082 | 11789 | 246 | 0.901734 | 2.21826564 | Gemmatimonadetes bacterium T265 | 2839016 | Bacteria | Bacteria | 102 | 1.17e-24 | NR | GJG86185.1 | 2839016 | g11744 | i0 | 58.4 | 1.08536585365854 | 89 | 29 | 98.8 | 1 | 3 | 245 | 165 | 253 | GJG86185.1 hypothetical protein tb265_13660 [Gemmatimonadetes bacterium T265] | diamond | 267 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadetes bacterium T265 | |||||
| 14244092 | 14244092 | PRJNA1111082_P_NODE_12232_length_244_cov_0.912281_g12187_i0 | PRJNA1111082 | 12232 | 244 | 0.912281 | 2.22596564 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 200 | 7.4299999999999985e-47 | NTclustered | gi|2874253789|emb|OY969773.1| | 412054 | g12187 | i0 | 91.667 | 0.590163934426229 | 144 | 12 | 59 | 0 | 1 | 144 | 865039 | 865182 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 | blastn | 144 | 200 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 16792408 | 16792408 | PRJNA1111082_P_NODE_12674_length_242_cov_0.923077_g12629_i0 | PRJNA1111082 | 12674 | 242 | 0.923077 | 2.23384634 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 206 | 1.58e-48 | NTclustered | gi|2874253789|emb|OY969773.1| | 412054 | g12629 | i0 | 88.068 | 1.33057851239669 | 176 | 18 | 71 | 3 | 5 | 177 | 1622167 | 1621992 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 | blastn | 322 | 206 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 19341102 | 19341102 | PRJNA1111082_P_NODE_11036_length_250_cov_0.881356_g10991_i0 | PRJNA1111082 | 11036 | 250 | 0.881356 | 2.20339 | Gemmatirosa sp. | 2510638 | Bacteria | Bacteria | 60.1 | 3.14e-8 | NR | HEY0777960.1 | 2510638 | g10991 | i0 | 55.9 | 0.708 | 59 | 24 | 70.8 | 1 | 185 | 9 | 582 | 638 | HEY0777960.1 RHS repeat-associated core domain-containing protein [Gemmatirosa sp.] | diamond | 177 | 60.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa sp. | |
| 19341139 | 19341139 | PRJNA1111082_P_NODE_12696_length_242_cov_0.923077_g12651_i0 | PRJNA1111082 | 12696 | 242 | 0.923077 | 2.23384634 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 82.4 | 2.78e-11 | NTclustered | gi|2874254107|emb|OY970192.1| | 412054 | g12651 | i0 | 87.5 | 0.297520661157025 | 72 | 8 | 29 | 1 | 97 | 167 | 3775024 | 3775095 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1 | blastn | 72 | 82.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 28015466 | 28015466 | PRJNA1111082_P_NODE_12185_length_244_cov_0.912281_g12140_i0 | PRJNA1111082 | 12185 | 244 | 0.912281 | 2.22596564 | Gemmatimonadetes bacterium T265 | 2839016 | Bacteria | Bacteria | 134 | 1.81e-36 | NR | GJG88674.1 | 2839016 | g12140 | i0 | 88.9 | 0.995901639344262 | 81 | 9 | 99.6 | 0 | 2 | 244 | 55 | 135 | GJG88674.1 malonyl CoA-acyl carrier protein transacylase [Gemmatimonadetes bacterium T265] | diamond | 243 | 134 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadetes bacterium T265 | |||||
| 28741537 | 28741537 | PRJNA1111082_P_NODE_2067_length_512_cov_1.835991_g2022_i0 | PRJNA1111082 | 2067 | 512 | 1.835991 | 9.40027392 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 53.1 | 1.23e-4 | NR | HJQ10304.1 | 2026741 | g2022 | i0 | 29.6 | 0.732421875 | 125 | 79 | 70.9 | 4 | 65 | 427 | 349 | 468 | HJQ10304.1 Ig-like domain-containing protein [Gemmatimonadaceae bacterium] | diamond | 375 | 53.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30541685 | 30541685 | PRJNA1111082_P_NODE_11613_length_247_cov_0.896552_g11568_i0 | PRJNA1111082 | 11613 | 247 | 0.896552 | 2.21448344 | Gemmatirosa sp. | 2510638 | Bacteria | Bacteria | 100 | 1.4100000000000001e-22 | NR | HZF67385.1 | 2510638 | g11568 | i0 | 65 | 0.97165991902834 | 80 | 28 | 97.2 | 0 | 4 | 243 | 206 | 285 | HZF67385.1 iron ABC transporter permease [Gemmatirosa sp.] | diamond | 240 | 100 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa sp. | |
| 31490122 | 31490122 | PRJNA1111082_P_NODE_12656_length_242_cov_0.923077_g12611_i0 | PRJNA1111082 | 12656 | 242 | 0.923077 | 2.23384634 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 123 | 1e-34 | NR | MBP6572803.1 | 2448054 | g12611 | i0 | 91.9 | 0.768595041322314 | 62 | 5 | 76.9 | 0 | 240 | 55 | 31 | 92 | MBP6572803.1 hypothetical protein [Gemmatimonadales bacterium] | diamond | 186 | 123 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 32597145 | 32597145 | PRJNA1111082_P_NODE_11540_length_247_cov_0.896552_g11495_i0 | PRJNA1111082 | 11540 | 247 | 0.896552 | 2.21448344 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 69.7 | 1.95e-12 | NR | MBA2707649.1 | 2026741 | g11495 | i0 | 90.9 | 2.40485829959514 | 33 | 3 | 40.1 | 0 | 149 | 247 | 1 | 33 | MBA2707649.1 DNA cytosine methyltransferase [Gemmatimonadaceae bacterium] | diamond | 594 | 69.7 | 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);;