contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA891846" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1243012 | 1243012 | PRJNA891846_P_NODE_13241_length_416_cov_0.897959_g13022_i0 | PRJNA891846 | 13241 | 416 | 0.897959 | 3.73550944 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 231 | 3.54e-75 | NR | NCZ58376.1 | 2900548 | g13022 | i0 | 99.2 | 0.865384615384615 | 120 | 1 | 86.5 | 0 | 360 | 1 | 1 | 120 | NCZ58376.1 bifunctional pyr operon transcriptional regulator/uracil phosphoribosyltransferase PyrR [Actinomycetota bacterium] | diamond | 360 | 231 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 4695944 | 4695944 | PRJNA891846_P_NODE_45524_length_243_cov_0.905882_g45304_i0 | PRJNA891846 | 45524 | 243 | 0.905882 | 2.20129326 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 122 | 2.58e-32 | NR | NBP49988.1 | 2900548 | g45304 | i0 | 95.5 | 0.827160493827161 | 67 | 3 | 82.7 | 0 | 241 | 41 | 189 | 255 | NBP49988.1 electron transfer flavoprotein beta subunit/FixA family protein [Actinomycetota bacterium] | diamond | 201 | 122 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 13620982 | 13620982 | PRJNA891846_P_NODE_37691_length_250_cov_0.870056_g37471_i0 | PRJNA891846 | 37691 | 250 | 0.870056 | 2.17514 | Acidimicrobiia bacterium | 2080302 | Bacteria | Bacteria | 150 | 4.68e-43 | NR | MFM8266324.1 | 2080302 | g37471 | i0 | 92.7 | 0.984 | 82 | 3 | 98.4 | 1 | 3 | 248 | 148 | 226 | MFM8266324.1 AMP-binding protein [Acidimicrobiia bacterium] | diamond | 246 | 150 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium | |||||
| 16170325 | 16170325 | PRJNA891846_P_NODE_8153_length_517_cov_0.968468_g7938_i0 | PRJNA891846 | 8153 | 517 | 0.968468 | 5.00697956 | root | 1 | Root_unresolved | Root_unresolved | 166 | 7.379999999999999e-47 | NR | MES6521686.1 | 1747 | g7938 | i0 | 66.7 | 8.35589941972921 | 120 | 40 | 69.6 | 0 | 363 | 4 | 51 | 170 | MES6521686.1 reverse transcriptase family protein [Cutibacterium acnes] | diamond | 4320 | 166 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 17820696 | 17820696 | PRJNA891846_P_NODE_44434_length_244_cov_0.900585_g44214_i0 | PRJNA891846 | 44434 | 244 | 0.900585 | 2.1974274 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 159 | 1.4699999999999999e-43 | NR | MEN9758324.1 | 2900548 | g44214 | i0 | 98.8 | 4.91803278688525 | 80 | 1 | 98.4 | 0 | 242 | 3 | 271 | 350 | MEN9758324.1 hypothetical protein [Actinomycetota bacterium] | diamond | 1200 | 159 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 23819454 | 23819454 | PRJNA891846_P_NODE_36859_length_251_cov_0.865169_g36639_i0 | PRJNA891846 | 36859 | 251 | 0.865169 | 2.17157419 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 147 | 7.369999999999999e-43 | NR | MEY4226318.1 | 2900548 | g36639 | i0 | 92.3 | 0.932270916334661 | 78 | 6 | 93.2 | 0 | 251 | 18 | 111 | 188 | MEY4226318.1 hypothetical protein [Actinomycetota bacterium] | diamond | 234 | 147 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 25093423 | 25093423 | PRJNA891846_P_NODE_41860_length_246_cov_0.890173_g41640_i0 | PRJNA891846 | 41860 | 246 | 0.890173 | 2.18982558 | Bacteria | 2 | Bacteria | Bacteria | 159 | 3.55e-45 | NR | TEX51193.1 | 1962179 | g41640 | i0 | 96.3 | 2.96341463414634 | 81 | 3 | 98.8 | 0 | 245 | 3 | 148 | 228 | TEX51193.1 MAG: cysteine desulfurase NifS [Actinomycetales bacterium mxb001] | diamond | 729 | 160 | 0.99375 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetales | Actinomycetales bacterium mxb001 | ||||
| 26675412 | 26675412 | PRJNA891846_P_NODE_17301_length_365_cov_1.332192_g17082_i0 | PRJNA891846 | 17301 | 365 | 1.332192 | 4.8625008 | Myceligenerans indicum | 2593663 | Bacteria | Bacteria | 43.9 | 0.0236 | NR | WP_201851174.1 | 2593663 | g17082 | i0 | 42.9 | 0.517808219178082 | 63 | 32 | 51.8 | 2 | 360 | 172 | 94 | 152 | WP_201851174.1 VapA/VapB family virulence-associated protein [Myceligenerans indicum] | diamond | 189 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Promicromonosporaceae | Myceligenerans | Myceligenerans indicum | ||
| 26707105 | 26707105 | PRJNA891846_P_NODE_39861_length_248_cov_0.880000_g39641_i0 | PRJNA891846 | 39861 | 248 | 0.88 | 2.1824 | Actinomycetes bacterium | 1883427 | Bacteria | Bacteria | 137 | 5.469999999999999e-37 | NR | MFN7802175.1 | 1883427 | g39641 | i0 | 74.4 | 0.991935483870968 | 82 | 21 | 99.2 | 0 | 248 | 3 | 141 | 222 | MFN7802175.1 transketolase [Actinomycetes bacterium] | diamond | 246 | 137 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetes bacterium | |||||
| 27118567 | 27118567 | PRJNA891846_P_NODE_47602_length_241_cov_0.916667_g47382_i0 | PRJNA891846 | 47602 | 241 | 0.916667 | 2.20916747 | Candidatus Nanopelagicaceae bacterium | 2518609 | Bacteria | Bacteria | 164 | 3.72e-48 | NR | MBU3753199.1 | 2518609 | g47382 | i0 | 97.5 | 0.983402489626556 | 79 | 2 | 98.3 | 0 | 3 | 239 | 25 | 103 | MBU3753199.1 threonylcarbamoyl-AMP synthase [Candidatus Nanopelagicaceae bacterium] | diamond | 237 | 164 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Candidatus Nanopelagicales | Candidatus Nanopelagicaceae | Candidatus Nanopelagicaceae bacterium | |||
| 27435058 | 27435058 | PRJNA891846_P_NODE_28703_length_285_cov_1.325472_g28484_i0 | PRJNA891846 | 28703 | 285 | 1.325472 | 3.7775952 | Nocardia sp. NPDC | 1821 | Bacteria | Bacteria | 46.2 | 0.00343 | NR | WP_379430397.1 | 3346777 | g28484 | i0 | 34.4 | 0.642105263157895 | 61 | 33 | 56.8 | 1 | 275 | 114 | 288 | 348 | WP_379430397.1 hypothetical protein [Nocardia sp. NPDC059228] | diamond | 183 | 46.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Nocardia | Nocardia sp. NPDC059228 | ||
| 27442900 | 27442900 | PRJNA891846_P_NODE_36943_length_251_cov_0.865169_g36723_i0 | PRJNA891846 | 36943 | 251 | 0.865169 | 2.17157419 | Bacteria | 2 | Bacteria | Bacteria | 169 | 9.91e-51 | NR | KRO43633.1 | 1655569 | g36723 | i0 | 98.8 | 4.9601593625498 | 83 | 1 | 99.2 | 0 | 1 | 249 | 29 | 111 | KRO43633.1 MAG: 6-phosphofructokinase, partial [Actinobacteria bacterium BACL2 MAG-120813-bin23] | diamond | 1245 | 170 | 0.994117647058824 | Bacteria | ac1 cluster | Bacillati | Actinomycetota | Actinomycetes | Actinobacteria bacterium BACL2 MAG-120813-bin23 | ||||
| 28192375 | 28192375 | PRJNA891846_P_NODE_47546_length_241_cov_0.916667_g47326_i0 | PRJNA891846 | 47546 | 241 | 0.916667 | 2.20916747 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 173 | 2.06e-49 | NR | MCX6417527.1 | 2900548 | g47326 | i0 | 100 | 1.99170124481328 | 80 | 0 | 99.6 | 0 | 1 | 240 | 289 | 368 | MCX6417527.1 urocanate hydratase [Actinomycetota bacterium] | diamond | 480 | 173 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 29210925 | 29210925 | PRJNA891846_P_NODE_47429_length_241_cov_0.916667_g47209_i0 | PRJNA891846 | 47429 | 241 | 0.916667 | 2.20916747 | Bacteria | 2 | Bacteria | Bacteria | 144 | 3.12e-40 | NR | MFM8521170.1 | 2024894 | g47209 | i0 | 100 | 5.30290456431535 | 71 | 0 | 88.4 | 0 | 1 | 213 | 261 | 331 | MFM8521170.1 M18 family aminopeptidase [Acidimicrobiaceae bacterium] | diamond | 1278 | 144 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiaceae | Acidimicrobiaceae bacterium | |||
| 29834460 | 29834460 | PRJNA891846_P_NODE_43451_length_245_cov_0.895349_g43231_i0 | PRJNA891846 | 43451 | 245 | 0.895349 | 2.19360505 | Actinomycetales bacterium | 1911520 | Bacteria | Bacteria | 164 | 1.88e-49 | NR | MBU6255610.1 | 1911520 | g43231 | i0 | 100 | 0.991836734693878 | 81 | 0 | 99.2 | 0 | 1 | 243 | 84 | 164 | MBU6255610.1 copper resistance protein CopC [Actinomycetales bacterium] | diamond | 243 | 164 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetales | Actinomycetales bacterium | ||||
| 30442664 | 30442664 | PRJNA891846_P_NODE_36753_length_251_cov_0.865169_g36533_i0 | PRJNA891846 | 36753 | 251 | 0.865169 | 2.17157419 | Bacteria | 2 | Bacteria | Bacteria | 131 | 7.93e-34 | NR | MCE2854875.1 | 2497619 | g36533 | i0 | 86.4 | 1.9601593625498 | 81 | 11 | 96.8 | 0 | 1 | 243 | 56 | 136 | MCE2854875.1 YifB family Mg chelatase-like AAA ATPase [Ilumatobacteraceae bacterium] | diamond | 492 | 131 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Ilumatobacteraceae | Ilumatobacteraceae bacterium | |||
| 30971984 | 30971984 | PRJNA891846_P_NODE_41954_length_246_cov_0.890173_g41734_i0 | PRJNA891846 | 41954 | 246 | 0.890173 | 2.18982558 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 64.3 | 3.45e-10 | NR | MEY2763277.1 | 2900548 | g41734 | i0 | 40.7 | 3.13414634146341 | 86 | 47 | 100 | 1 | 1 | 246 | 50 | 135 | MEY2763277.1 hypothetical protein [Actinomycetota bacterium] | diamond | 771 | 64.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 31168999 | 31168999 | PRJNA891846_P_NODE_38955_length_249_cov_0.875000_g38735_i0 | PRJNA891846 | 38955 | 249 | 0.875 | 2.17875 | Bacteria | 2 | Bacteria | Bacteria | 159 | 1.08e-43 | NR | MBU6164157.1 | 1911520 | g38735 | i0 | 100 | 3.95180722891566 | 82 | 0 | 98.8 | 0 | 247 | 2 | 32 | 113 | MBU6164157.1 penicillin-binding protein [Actinomycetales bacterium] | diamond | 984 | 159 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetales | Actinomycetales bacterium | ||||
| 31319480 | 31319480 | PRJNA891846_P_NODE_44115_length_244_cov_0.900585_g43895_i0 | PRJNA891846 | 44115 | 244 | 0.900585 | 2.1974274 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 134 | 6.19e-35 | NR | MEY3257042.1 | 2900548 | g43895 | i0 | 94 | 0.823770491803279 | 67 | 4 | 82.4 | 0 | 6 | 206 | 424 | 490 | MEY3257042.1 hypothetical protein [Actinomycetota bacterium] | diamond | 201 | 134 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 31319483 | 31319483 | PRJNA891846_P_NODE_5295_length_630_cov_1.486535_g5085_i0 | PRJNA891846 | 5295 | 630 | 1.486535 | 9.3651705 | Patulibacter sp. | 1912859 | Bacteria | Bacteria | 49.3 | 0.00456 | NR | MFA4930227.1 | 1912859 | g5085 | i0 | 57.6 | 0.157142857142857 | 33 | 14 | 15.7 | 0 | 425 | 327 | 235 | 267 | MFA4930227.1 hypothetical protein [Patulibacter sp.] | diamond | 99 | 49.3 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Patulibacteraceae | Patulibacter | Patulibacter sp. | ||
| 32300563 | 32300563 | PRJNA891846_P_NODE_36639_length_251_cov_0.865169_g36419_i0 | PRJNA891846 | 36639 | 251 | 0.865169 | 2.17157419 | Actinomycetes bacterium | 1883427 | Bacteria | Bacteria | 160 | 7.72e-46 | NR | GDX18301.1 | 1883427 | g36419 | i0 | 98.8 | 0.99203187250996006 | 83 | 1 | 99.2 | 0 | 251 | 3 | 115 | 197 | GDX18301.1 AI-2E family transporter [Actinomycetes bacterium] | diamond | 249 | 160 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetes 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);;