contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA1089179" and tax_phylum = "Actinomycetota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6572683 | 6572683 | PRJNA1089179_P_NODE_14226_length_252_cov_1.324022_g14208_i0 | PRJNA1089179 | 14226 | 252 | 1.324022 | 3.33653544 | Nocardioidaceae bacterium | 1871072 | Bacteria | Bacteria | 155 | 2.6099999999999993e-43 | NR | HZG97029.1 | 1871072 | g14208 | i0 | 94 | 0.988095238095238 | 83 | 5 | 98.8 | 0 | 251 | 3 | 114 | 196 | HZG97029.1 HRDC domain-containing protein [Nocardioidaceae bacterium] | diamond | 249 | 155 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioidaceae bacterium | |||
| 9122406 | 9122406 | PRJNA1089179_P_NODE_12108_length_271_cov_1.550505_g12090_i0 | PRJNA1089179 | 12108 | 271 | 1.550505 | 4.20186855 | uncultured Friedmanniella sp. | 335381 | Bacteria | Bacteria | 155 | 1.1199999999999996e-43 | NR | WP_375431120.1 | 335381 | g12090 | i0 | 86.5 | 3.9409594095941 | 89 | 12 | 98.5 | 0 | 3 | 269 | 71 | 159 | WP_375431120.1 TadA family conjugal transfer-associated ATPase [uncultured Friedmanniella sp.] | diamond | 1068 | 155 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Friedmanniella | uncultured Friedmanniella sp. | ||
| 11673469 | 11673469 | PRJNA1089179_P_NODE_13130_length_261_cov_35.808511_g13112_i0 | PRJNA1089179 | 13130 | 261 | 35.808511 | 93.46021371 | Janibacter sp. DB-4 | 1870928 | Bacteria | Bacteria | 110 | 4.12e-28 | NR | WP_277454283.1 | 3028808 | g13112 | i0 | 70.1 | 1.58620689655172 | 67 | 20 | 77 | 0 | 228 | 28 | 9 | 75 | WP_277454283.1 DUF2231 domain-containing protein [Janibacter sp. DB-40] | diamond | 414 | 110 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Intrasporangiaceae | Janibacter | Janibacter sp. DB-40 | ||
| 12496344 | 12496344 | PRJNA1089179_P_NODE_18230_length_207_cov_5.044776_g18212_i0 | PRJNA1089179 | 18230 | 207 | 5.044776 | 10.44268632 | Bacteria | 2 | Bacteria | Bacteria | 122 | 2.8e-30 | NR | HYN18101.1 | 1883427 | g18212 | i0 | 91.9 | 10.7826086956522 | 62 | 5 | 89.9 | 0 | 20 | 205 | 159 | 220 | HYN18101.1 sugar phosphate nucleotidyltransferase [Actinomycetes bacterium] | diamond | 2232 | 123 | 0.991869918699187 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetes bacterium | |||||
| 15497394 | 15497394 | PRJNA1089179_P_NODE_10713_length_284_cov_37.227488_g10695_i0 | PRJNA1089179 | 10713 | 284 | 37.227488 | 105.72606592 | uncultured Friedmanniella sp. | 335381 | Bacteria | Bacteria | 147 | 8.93e-39 | NR | WP_294694727.1 | 335381 | g10695 | i0 | 91.3 | 1.69014084507042 | 80 | 7 | 84.5 | 0 | 260 | 21 | 590 | 669 | WP_294694727.1 multifunctional oxoglutarate decarboxylase/oxoglutarate dehydrogenase thiamine pyrophosphate-binding subunit/dihydrolipoyllysine-residue succinyltransferase subunit, partial [uncultured Friedmanniella sp.] | diamond | 480 | 147 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Friedmanniella | uncultured Friedmanniella sp. | ||
| 21419561 | 21419561 | PRJNA1089179_P_NODE_14717_length_250_cov_0.870056_g14699_i0 | PRJNA1089179 | 14717 | 250 | 0.870056 | 2.17514 | Pseudonocardia sp. | 60912 | Bacteria | Bacteria | 114 | 1.89e-27 | NR | HVH22789.1 | 60912 | g14699 | i0 | 76.9 | 0.936 | 78 | 18 | 93.6 | 0 | 17 | 250 | 72 | 149 | HVH22789.1 glycosyltransferase [Pseudonocardia sp.] | diamond | 234 | 114 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Pseudonocardia | Pseudonocardia sp. | ||
| 27121839 | 27121839 | PRJNA1089179_P_NODE_17402_length_240_cov_3.832335_g17384_i0 | PRJNA1089179 | 17402 | 240 | 3.832335 | 9.197604 | Bacteria | 2 | Bacteria | Bacteria | 42.7 | 0.0362 | NR | WP_184836471.1 | 643052 | g17384 | i0 | 45.3 | 1.25 | 53 | 25 | 61.3 | 2 | 171 | 25 | 197 | 249 | WP_184836471.1 DUF2207 family protein [Allocatelliglobosispora scoriae] | diamond | 300 | 43.1 | 0.990719257540603 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Allocatelliglobosispora | Allocatelliglobosispora scoriae | ||
| 27699685 | 27699685 | PRJNA1089179_P_NODE_13004_length_263_cov_1.263158_g12986_i0 | PRJNA1089179 | 13004 | 263 | 1.263158 | 3.32210554 | Micromonosporaceae bacterium | 1873464 | Bacteria | Bacteria | 79 | 4.58e-16 | NR | HEX5595494.1 | 1873464 | g12986 | i0 | 46.2 | 1.75665399239544 | 78 | 42 | 89 | 0 | 27 | 260 | 40 | 117 | HEX5595494.1 hypothetical protein [Micromonosporaceae bacterium] | diamond | 462 | 79 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Micromonosporaceae bacterium | |||
| 28078155 | 28078155 | PRJNA1089179_P_NODE_14725_length_250_cov_0.870056_g14707_i0 | PRJNA1089179 | 14725 | 250 | 0.870056 | 2.17514 | Leifsonia sp. AG29 | 2598860 | Bacteria | Bacteria | 101 | 7.89e-23 | NR | WP_233265485.1 | 2598860 | g14707 | i0 | 55.4 | 0.996 | 83 | 35 | 99.6 | 1 | 250 | 2 | 1332 | 1412 | WP_233265485.1 DEAD/DEAH box helicase [Leifsonia sp. AG29] | diamond | 249 | 101 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Leifsonia | Leifsonia sp. AG29 | ||
| 29301101 | 29301101 | PRJNA1089179_P_NODE_17309_length_241_cov_0.916667_g17291_i0 | PRJNA1089179 | 17309 | 241 | 0.916667 | 2.20916747 | Microlunatus | 29404 | Bacteria | Bacteria | 98.6 | 8.2100000000000005e-22 | NR | WP_183337207.1 | 53388 | g17291 | i0 | 63.3 | 1.96680497925311 | 79 | 29 | 98.3 | 0 | 2 | 238 | 375 | 453 | WP_183337207.1 adenylate/guanylate cyclase domain-containing protein [Microlunatus antarcticus] | diamond | 474 | 98.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Microlunatus | Microlunatus antarcticus | ||
| 29814728 | 29814728 | PRJNA1089179_P_NODE_12691_length_265_cov_13.729167_g12673_i0 | PRJNA1089179 | 12691 | 265 | 13.729167 | 36.38229255 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 110 | 4.0199999999999998e-28 | NR | MDP9071726.1 | 2900548 | g12673 | i0 | 80 | 0.849056603773585 | 75 | 14 | 83.8 | 1 | 23 | 244 | 58 | 132 | MDP9071726.1 hypothetical protein [Actinomycetota bacterium] | diamond | 225 | 110 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 30667832 | 30667832 | PRJNA1089179_P_NODE_15473_length_247_cov_0.885057_g15455_i0 | PRJNA1089179 | 15473 | 247 | 0.885057 | 2.18609079 | Streptomyces lucensis | 67319 | Bacteria | Bacteria | 42.7 | 0.0384 | NR | WP_229815914.1 | 67319 | g15455 | i0 | 40.5 | 0.449392712550607 | 37 | 15 | 36.4 | 1 | 158 | 247 | 310 | 346 | WP_229815914.1 glycosyltransferase 87 family protein [Streptomyces lucensis] | diamond | 111 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces lucensis | ||
| 31236473 | 31236473 | PRJNA1089179_P_NODE_12115_length_271_cov_1.409091_g12097_i0 | PRJNA1089179 | 12115 | 271 | 1.409091 | 3.81863661 | Nocardioidaceae bacterium | 1871072 | Bacteria | Bacteria | 114 | 7.73e-28 | NR | HZG98136.1 | 1871072 | g12097 | i0 | 88 | 0.830258302583026 | 75 | 8 | 83 | 1 | 270 | 46 | 333 | 406 | HZG98136.1 MFS transporter [Nocardioidaceae bacterium] | diamond | 225 | 114 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioidaceae bacterium | |||
| 31268268 | 31268268 | PRJNA1089179_P_NODE_13175_length_261_cov_2.234043_g13157_i0 | PRJNA1089179 | 13175 | 261 | 2.234043 | 5.83085223 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 66.2 | 1.95e-10 | NR | MBW3638459.1 | 2900548 | g13157 | i0 | 53.9 | 1.77011494252874 | 76 | 25 | 82.8 | 2 | 38 | 253 | 211 | 280 | MBW3638459.1 hypothetical protein [Actinomycetota bacterium] | diamond | 462 | 66.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 31616127 | 31616127 | PRJNA1089179_P_NODE_15376_length_247_cov_1.758621_g15358_i0 | PRJNA1089179 | 15376 | 247 | 1.758621 | 4.34379387 | Microlunatus sp. | 39595 | Bacteria | Bacteria | 55.1 | 1.68e-6 | NR | HET9649852.1 | 39595 | g15358 | i0 | 87.1 | 0.376518218623482 | 31 | 4 | 37.7 | 0 | 205 | 113 | 330 | 360 | HET9649852.1 IS110 family transposase [Microlunatus sp.] | diamond | 93 | 55.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Microlunatus | Microlunatus sp. | ||
| 31869113 | 31869113 | PRJNA1089179_P_NODE_15677_length_246_cov_1.456647_g15659_i0 | PRJNA1089179 | 15677 | 246 | 1.456647 | 3.58335162 | Microlunatus elymi | 2596828 | Bacteria | Bacteria | 78.6 | 9.39e-15 | NR | WP_143985258.1 | 2596828 | g15659 | i0 | 52.4 | 1 | 82 | 38 | 98.8 | 1 | 2 | 244 | 486 | 567 | WP_143985258.1 MobF family relaxase [Microlunatus elymi] | diamond | 246 | 78.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Microlunatus | Microlunatus elymi | ||
| 32058993 | 32058993 | PRJNA1089179_P_NODE_16138_length_245_cov_0.895349_g16120_i0 | PRJNA1089179 | 16138 | 245 | 0.895349 | 2.19360505 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 115 | 2.61e-29 | NR | MDP9164744.1 | 2900548 | g16120 | i0 | 75.3 | 0.991836734693878 | 81 | 20 | 99.2 | 0 | 243 | 1 | 192 | 272 | MDP9164744.1 alpha/beta hydrolase [Actinomycetota bacterium] | diamond | 243 | 115 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 32217315 | 32217315 | PRJNA1089179_P_NODE_14438_length_251_cov_0.865169_g14420_i0 | PRJNA1089179 | 14438 | 251 | 0.865169 | 2.17157419 | Calidifontibacter indicus | 419650 | Bacteria | Bacteria | 174 | 6.529999999999999e-52 | NR | WP_115923085.1 | 419650 | g14420 | i0 | 98.8 | 0.99203187250996006 | 83 | 1 | 99.2 | 0 | 249 | 1 | 82 | 164 | WP_115923085.1 acyl-CoA thioester hydrolase/BAAT C-terminal domain-containing protein [Calidifontibacter indicus] | diamond | 249 | 174 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Dermacoccaceae | Calidifontibacter | Calidifontibacter indicus | ||
| 32280753 | 32280753 | PRJNA1089179_P_NODE_15319_length_247_cov_16.459770_g15301_i0 | PRJNA1089179 | 15319 | 247 | 16.45977 | 40.6556319 | Rubrobacter sp. | 2036010 | Bacteria | Bacteria | 92.8 | 7.42e-23 | NR | HVD44812.1 | 2036010 | g15301 | i0 | 100 | 0.522267206477733 | 43 | 0 | 52.2 | 0 | 142 | 14 | 1 | 43 | HVD44812.1 hypothetical protein [Rubrobacter sp.] | diamond | 129 | 92.8 | 1 | Bacteria | Bacillati | Actinomycetota | Rubrobacteria | Rubrobacterales | Rubrobacteraceae | Rubrobacter | Rubrobacter sp. |
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);;