contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA1087264" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1468626 | 1468626 | PRJNA1087264_P_NODE_12202_length_181_cov_1.159091_g12120_i0 | PRJNA1087264 | 12202 | 181 | 1.159091 | 2.09795471 | Arthrobacter | 1663 | Bacteria | Bacteria | 95.9 | 1.07e-22 | NR | MBO9705187.1 | 1667 | g12120 | i0 | 80 | 13.6740331491713 | 60 | 12 | 99.4 | 0 | 2 | 181 | 132 | 191 | MBO9705187.1 SDR family NAD(P)-dependent oxidoreductase [Arthrobacter sp.] | diamond | 2475 | 95.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | Arthrobacter sp. | ||
| 11220874 | 11220874 | PRJNA1087264_P_NODE_3249_length_366_cov_1.624606_g3168_i0 | PRJNA1087264 | 3249 | 366 | 1.624606 | 5.94605796 | Propionibacteriaceae bacterium | 2021380 | Bacteria | Bacteria | 176 | 4.979999999999999e-54 | NR | MCP3885490.1 | 2021380 | g3168 | i0 | 70.1 | 0.959016393442623 | 117 | 33 | 95.9 | 1 | 355 | 5 | 3 | 117 | MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] | diamond | 351 | 176 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Propionibacteriaceae bacterium | |||
| 18045724 | 18045724 | PRJNA1087264_P_NODE_1395_length_566_cov_2.100580_g1319_i0 | PRJNA1087264 | 1395 | 566 | 2.10058 | 11.8892828 | Propionibacteriaceae bacterium | 2021380 | Bacteria | Bacteria | 220 | 2.16e-70 | NR | MCP3885490.1 | 2021380 | g1319 | i0 | 71.8 | 0.789752650176678 | 149 | 42 | 79 | 0 | 535 | 89 | 3 | 151 | MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] | diamond | 447 | 220 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Propionibacteriaceae bacterium | |||
| 25243776 | 25243776 | PRJNA1087264_P_NODE_10960_length_191_cov_1.007042_g10878_i0 | PRJNA1087264 | 10960 | 191 | 1.007042 | 1.92345022 | Propionibacteriaceae bacterium | 2021380 | Bacteria | Bacteria | 107 | 5.27e-28 | NR | MCP3885490.1 | 2021380 | g10878 | i0 | 79.4 | 0.989528795811518 | 63 | 13 | 99 | 0 | 190 | 2 | 45 | 107 | MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] | diamond | 189 | 107 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Propionibacteriaceae bacterium | |||
| 27067444 | 27067444 | PRJNA1087264_P_NODE_3422_length_355_cov_1.803922_g3341_i0 | PRJNA1087264 | 3422 | 355 | 1.803922 | 6.4039231 | Solirubrobacteraceae bacterium | 2586742 | Bacteria | Bacteria | 75.9 | 1.62e-13 | NR | MEA2130725.1 | 2586742 | g3341 | i0 | 39.4 | 1.5887323943662 | 94 | 57 | 79.4 | 0 | 355 | 74 | 216 | 309 | MEA2130725.1 hypothetical protein [Solirubrobacteraceae bacterium] | diamond | 564 | 75.9 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacteraceae | Solirubrobacteraceae bacterium | |||
| 27248603 | 27248603 | PRJNA1087264_P_NODE_9363_length_206_cov_1.210191_g9281_i0 | PRJNA1087264 | 9363 | 206 | 1.210191 | 2.49299346 | Bacteria | 2 | Bacteria | Bacteria | 45.1 | 0.00276 | NR | GAA1886603.1 | 391736 | g9281 | i0 | 37.5 | 2.76699029126214 | 48 | 30 | 69.9 | 0 | 45 | 188 | 52 | 99 | GAA1886603.1 hypothetical protein GCM10009773_13650 [Williamsia serinedens] | diamond | 570 | 45.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Williamsia | Williamsia serinedens | ||
| 27627795 | 27627795 | PRJNA1087264_P_NODE_16404_length_166_cov_0.871795_g16322_i0 | PRJNA1087264 | 16404 | 166 | 0.871795 | 1.4471797 | Nocardioides | 1839 | Bacteria | Bacteria | 95.1 | 4.19e-21 | NR | MFA6575476.1 | 35761 | g16322 | i0 | 83.6 | 2.98192771084337 | 55 | 9 | 99.4 | 0 | 165 | 1 | 131 | 185 | MFA6575476.1 DnaB-like helicase C-terminal domain-containing protein [Nocardioides sp.] | diamond | 495 | 95.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides sp. | ||
| 27731221 | 27731221 | PRJNA1087264_P_NODE_6304_length_254_cov_0.619512_g6222_i0 | PRJNA1087264 | 6304 | 254 | 0.619512 | 1.57356048 | Streptosporangiaceae bacterium | 2339230 | Bacteria | Bacteria | 42.7 | 0.041 | NR | HEY3902701.1 | 2339230 | g6222 | i0 | 35.3 | 0.602362204724409 | 51 | 31 | 57.9 | 1 | 19 | 165 | 296 | 346 | HEY3902701.1 hypothetical protein [Streptosporangiaceae bacterium] | diamond | 153 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Streptosporangiaceae | Streptosporangiaceae bacterium | |||
| 27880212 | 27880212 | PRJNA1087264_P_NODE_18905_length_163_cov_1.342105_g18823_i0 | PRJNA1087264 | 18905 | 163 | 1.342105 | 2.18763115 | Bacteria | 2 | Bacteria | Bacteria | 94.7 | 5.95e-21 | NR | MCB1271004.1 | 2497627 | g18823 | i0 | 81.5 | 21.8650306748466 | 54 | 10 | 99.4 | 0 | 163 | 2 | 229 | 282 | MCB1271004.1 phosphoenolpyruvate carboxykinase (GTP) [Microthrixaceae bacterium] | diamond | 3564 | 95.5 | 0.991623036649215 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Microthrixaceae | Microthrixaceae bacterium | |||
| 28172865 | 28172865 | PRJNA1087264_P_NODE_5526_length_272_cov_0.914798_g5444_i0 | PRJNA1087264 | 5526 | 272 | 0.914798 | 2.48825056 | Microbacteriaceae bacterium | 1873462 | Bacteria | Bacteria | 48.9 | 1.8e-4 | NR | MBX9717868.1 | 1873462 | g5444 | i0 | 34.8 | 0.761029411764706 | 69 | 40 | 70.6 | 1 | 27 | 218 | 1 | 69 | MBX9717868.1 hypothetical protein [Microbacteriaceae bacterium] | diamond | 207 | 48.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacteriaceae bacterium | |||
| 28678301 | 28678301 | PRJNA1087264_P_NODE_8307_length_219_cov_1.141176_g8225_i0 | PRJNA1087264 | 8307 | 219 | 1.141176 | 2.49917544 | Conexibacter woesei | 191495 | Bacteria | Bacteria | 62 | 3.98e-9 | NR | WP_012934830.1 | 191495 | g8225 | i0 | 47 | 5.41095890410959 | 66 | 35 | 90.4 | 0 | 206 | 9 | 22 | 87 | WP_012934830.1 ubiquitin family protein [Conexibacter woesei] | diamond | 1185 | 62 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Conexibacteraceae | Conexibacter | Conexibacter woesei | ||
| 28732775 | 28732775 | PRJNA1087264_P_NODE_20127_length_162_cov_0.902655_g20045_i0 | PRJNA1087264 | 20127 | 162 | 0.902655 | 1.4623011 | Bacteria | 2 | Bacteria | Bacteria | 63.9 | 4.25e-11 | NR | HEY8406337.1 | 2838783 | g20045 | i0 | 56.6 | 7.62962962962963 | 53 | 23 | 98.1 | 0 | 1 | 159 | 56 | 108 | HEY8406337.1 GNAT family N-acetyltransferase [Gaiellaceae bacterium] | diamond | 1236 | 63.9 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Gaiellales | Gaiellaceae | Gaiellaceae bacterium | |||
| 29057136 | 29057136 | PRJNA1087264_P_NODE_21728_length_161_cov_0.910714_g21646_i0 | PRJNA1087264 | 21728 | 161 | 0.910714 | 1.46624954 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 45.8 | 9.89e-4 | NR | MDP1878021.1 | 2900548 | g21646 | i0 | 56.8 | 0.819875776397516 | 44 | 18 | 82 | 1 | 30 | 161 | 178 | 220 | MDP1878021.1 glycerate kinase [Actinomycetota bacterium] | diamond | 132 | 45.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 29404378 | 29404378 | PRJNA1087264_P_NODE_11789_length_184_cov_0.851852_g11707_i0 | PRJNA1087264 | 11789 | 184 | 0.851852 | 1.56740768 | Micromonospora arida | 2203715 | Bacteria | Bacteria | 42.7 | 0.0173 | NR | WP_341869921.1 | 2203715 | g11707 | i0 | 52.9 | 0.554347826086957 | 34 | 16 | 55.4 | 0 | 126 | 25 | 32 | 65 | WP_341869921.1 HNH endonuclease signature motif containing protein [Micromonospora arida] | diamond | 102 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Micromonospora | Micromonospora arida | ||
| 30193789 | 30193789 | PRJNA1087264_P_NODE_16512_length_165_cov_1.422414_g16430_i0 | PRJNA1087264 | 16512 | 165 | 1.422414 | 2.3469831 | Rubrobacter sp. | 2036010 | Bacteria | Bacteria | 61.2 | 1.2e-10 | NR | MEJ7815551.1 | 2036010 | g16430 | i0 | 85.7 | 0.636363636363636 | 35 | 4 | 61.8 | 1 | 105 | 4 | 32 | 66 | MEJ7815551.1 hypothetical protein [Rubrobacter sp.] | diamond | 105 | 61.2 | 1 | Bacteria | Bacillati | Actinomycetota | Rubrobacteria | Rubrobacterales | Rubrobacteraceae | Rubrobacter | Rubrobacter sp. | ||
| 30257431 | 30257431 | PRJNA1087264_P_NODE_2472_length_426_cov_1.175066_g2391_i0 | PRJNA1087264 | 2472 | 426 | 1.175066 | 5.00578116 | Solirubrobacter deserti | 2282478 | Bacteria | Bacteria | 45.8 | 0.0181 | NR | WP_202957815.1 | 2282478 | g2391 | i0 | 35 | 0.704225352112676 | 100 | 48 | 65.5 | 4 | 286 | 8 | 257 | 346 | WP_202957815.1 MFS transporter [Solirubrobacter deserti] | diamond | 300 | 45.8 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacteraceae | Solirubrobacter | Solirubrobacter deserti | ||
| 30352428 | 30352428 | PRJNA1087264_P_NODE_8932_length_211_cov_0.759259_g8850_i0 | PRJNA1087264 | 8932 | 211 | 0.759259 | 1.60203649 | Nocardioides sp. AX2bis | 2653157 | Bacteria | Bacteria | 44.3 | 0.00663 | NR | WP_160006012.1 | 2653157 | g8850 | i0 | 44.8 | 0.824644549763033 | 58 | 25 | 76.8 | 3 | 46 | 207 | 158 | 212 | WP_160006012.1 GNAT family N-acetyltransferase [Nocardioides sp. AX2bis] | diamond | 174 | 44.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides sp. AX2bis | ||
| 30352429 | 30352429 | PRJNA1087264_P_NODE_972_length_673_cov_1.705128_g902_i0 | PRJNA1087264 | 972 | 673 | 1.705128 | 11.47551144 | uncultured Actinomycetospora sp. | 1135996 | Bacteria | Bacteria | 44.3 | 0.0263 | NR | CAA9243484.1 | 1135996 | g902 | i0 | 46.8 | 0.343239227340267 | 77 | 33 | 31.2 | 3 | 88 | 297 | 7 | 82 | CAA9243484.1 MAG: WhiB-like transcription regulator, partial [uncultured Actinomycetospora sp.] | diamond | 231 | 44.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Actinomycetospora | uncultured Actinomycetospora sp. | ||
| 30509834 | 30509834 | PRJNA1087264_P_NODE_19233_length_163_cov_0.894737_g19151_i0 | PRJNA1087264 | 19233 | 163 | 0.894737 | 1.45842131 | Fodinicola feengrottensis | 435914 | Bacteria | Bacteria | 42 | 0.00275 | NR | WP_344307536.1 | 435914 | g19151 | i0 | 45.9 | 0.680981595092024 | 37 | 20 | 68.1 | 0 | 159 | 49 | 19 | 55 | WP_344307536.1 hypothetical protein [Fodinicola feengrottensis] | diamond | 111 | 42 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Fodinicola | Fodinicola feengrottensis | |||
| 31132906 | 31132906 | PRJNA1087264_P_NODE_10655_length_193_cov_1.784722_g10573_i0 | PRJNA1087264 | 10655 | 193 | 1.784722 | 3.44451346 | Bacteria | 2 | Bacteria | Bacteria | 42.7 | 0.0184 | NR | WP_172461504.1 | 672460 | g10573 | i0 | 60 | 4.15025906735751 | 30 | 12 | 46.6 | 0 | 3 | 92 | 310 | 339 | WP_172461504.1 alcohol dehydrogenase AdhP [Branchiibius hedensis] | diamond | 801 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Dermacoccaceae | Branchiibius | Branchiibius hedensis | ||
| 31553142 | 31553142 | PRJNA1087264_P_NODE_18756_length_164_cov_0.886957_g18674_i0 | PRJNA1087264 | 18756 | 164 | 0.886957 | 1.45460948 | Frankia umida | 573489 | Bacteria | Bacteria | 45.4 | 0.00142 | NR | WP_248827075.1 | 573489 | g18674 | i0 | 56.3 | 0.585365853658537 | 32 | 14 | 58.5 | 0 | 152 | 57 | 308 | 339 | WP_248827075.1 hypothetical protein [Frankia umida] | diamond | 96 | 45.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Frankiales | Frankiaceae | Frankia | Frankia umida | ||
| 32058979 | 32058979 | PRJNA1087264_P_NODE_18678_length_164_cov_0.886957_g18596_i0 | PRJNA1087264 | 18678 | 164 | 0.886957 | 1.45460948 | Nesterenkonia lacusekhoensis | 150832 | Bacteria | Bacteria | 107 | 2.12e-25 | NR | WP_210048060.1 | 150832 | g18596 | i0 | 100 | 0.98780487804878 | 54 | 0 | 98.8 | 0 | 164 | 3 | 282 | 335 | WP_210048060.1 HelD family protein [Nesterenkonia lacusekhoensis] | diamond | 162 | 107 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Nesterenkonia | Nesterenkonia lacusekhoensis | ||
| 32280740 | 32280740 | PRJNA1087264_P_NODE_19179_length_163_cov_0.894737_g19097_i0 | PRJNA1087264 | 19179 | 163 | 0.894737 | 1.45842131 | Micrococcus sp. NPDC | 1271 | Bacteria | Bacteria | 70.5 | 2.03e-12 | NR | WP_366370635.1 | 3154960 | g19097 | i0 | 100 | 1.25153374233129 | 34 | 0 | 62.6 | 0 | 163 | 62 | 134 | 167 | WP_366370635.1 hypothetical protein [Micrococcus sp. NPDC078436] | diamond | 204 | 70.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Micrococcus | Micrococcus sp. NPDC078436 | ||
| 32367025 | 32367025 | PRJNA1087264_P_NODE_19699_length_163_cov_0.894737_g19617_i0 | PRJNA1087264 | 19699 | 163 | 0.894737 | 1.45842131 | Bacillati | 1783272 | Bacteria | Bacteria | 51.6 | 9.19e-6 | NR | WP_168115718.1 | 689768 | g19617 | i0 | 45.1 | 1.85889570552147 | 51 | 28 | 93.9 | 0 | 2 | 154 | 261 | 311 | WP_168115718.1 aldo/keto reductase [Planosporangium mesophilum] | diamond | 303 | 52 | 0.992307692307692 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Planosporangium | Planosporangium mesophilum | ||
| 32461860 | 32461860 | PRJNA1087264_P_NODE_6459_length_250_cov_1.268657_g6377_i0 | PRJNA1087264 | 6459 | 250 | 1.268657 | 3.1716425 | Streptomyces | 1883 | Bacteria | Bacteria | 60.5 | 2.41e-8 | NR | WP_345667937.1 | 1274988 | g6377 | i0 | 42.1 | 3.66 | 76 | 44 | 91.2 | 0 | 228 | 1 | 608 | 683 | WP_345667937.1 amino acid adenylation domain-containing protein [Streptomyces similanensis] | diamond | 915 | 60.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces similanensis | ||
| 32871603 | 32871603 | PRJNA1087264_P_NODE_6340_length_253_cov_0.906863_g6258_i0 | PRJNA1087264 | 6340 | 253 | 0.906863 | 2.29436339 | Streptomyces | 1883 | Bacteria | Bacteria | 42.7 | 0.00988 | NR | WP_059042734.1 | 42234 | g6258 | i0 | 35.7 | 2.09881422924901 | 56 | 35 | 66.4 | 1 | 252 | 85 | 4 | 58 | WP_059042734.1 hypothetical protein [Streptomyces acidiscabies] | diamond | 531 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces acidiscabies |
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);;