contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA772154" and tax_phylum = "Myxococcota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10951543 | 10951543 | PRJNA772154_P_NODE_22169_length_243_cov_0.917647_g21984_i0 | PRJNA772154 | 22169 | 243 | 0.917647 | 2.22988221 | Archangium | 47 | Bacteria | Bacteria | 132 | 6.16e-36 | NR | MDP1821831.1 | 1872627 | g21984 | i0 | 83.1 | 2.91358024691358 | 77 | 13 | 95.1 | 0 | 231 | 1 | 26 | 102 | MDP1821831.1 hypothetical protein [Archangium sp.] | diamond | 708 | 132 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 22424906 | 22424906 | PRJNA772154_P_NODE_8638_length_395_cov_1.500000_g8453_i0 | PRJNA772154 | 8638 | 395 | 1.5 | 5.925 | Myxococcia | 32015 | Bacteria | Bacteria | 146 | 8.23e-38 | NR | MBX3186075.1 | 1971228 | g8453 | i0 | 53.1 | 8.89367088607595 | 130 | 61 | 98.7 | 0 | 393 | 4 | 718 | 847 | MBX3186075.1 AAA family ATPase [Labilithrix sp.] | diamond | 3513 | 146 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 26673125 | 26673125 | PRJNA772154_P_NODE_14721_length_284_cov_0.928910_g14536_i0 | PRJNA772154 | 14721 | 284 | 0.92891 | 2.6381044 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 52 | 3.26e-5 | NR | MDR2443685.1 | 2026735 | g14536 | i0 | 33.3 | 1.04577464788732 | 99 | 56 | 94 | 1 | 267 | 1 | 184 | 282 | MDR2443685.1 transposase [Deltaproteobacteria bacterium] | diamond | 297 | 52 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27179528 | 27179528 | PRJNA772154_P_NODE_18462_length_251_cov_0.876404_g18277_i0 | PRJNA772154 | 18462 | 251 | 0.876404 | 2.19977404 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 175 | 2.1099999999999998e-54 | NR | MEZ4280774.1 | 2818507 | g18277 | i0 | 100 | 0.99203187250996006 | 83 | 0 | 99.2 | 0 | 2 | 250 | 68 | 150 | MEZ4280774.1 transcriptional repressor [Myxococcota bacterium] | diamond | 249 | 175 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 28158971 | 28158971 | PRJNA772154_P_NODE_21785_length_244_cov_0.912281_g21600_i0 | PRJNA772154 | 21785 | 244 | 0.912281 | 2.22596564 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 152 | 1.34e-44 | NR | HSC85711.1 | 2268199 | g21600 | i0 | 92.6 | 0.995901639344262 | 81 | 6 | 99.6 | 0 | 244 | 2 | 33 | 113 | HSC85711.1 methyltransferase domain-containing protein [Polyangiaceae bacterium] | diamond | 243 | 152 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28569120 | 28569120 | PRJNA772154_P_NODE_13287_length_302_cov_1.362445_g13102_i0 | PRJNA772154 | 13287 | 302 | 1.362445 | 4.1145839 | Archangium sp. | 1872627 | Bacteria | Bacteria | 144 | 1.98e-40 | NR | MFT3708157.1 | 1872627 | g13102 | i0 | 76 | 0.993377483443709 | 100 | 24 | 99.3 | 0 | 2 | 301 | 136 | 235 | MFT3708157.1 hypothetical protein [Archangium sp.] | diamond | 300 | 144 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 28569121 | 28569121 | PRJNA772154_P_NODE_17667_length_253_cov_0.866667_g17482_i0 | PRJNA772154 | 17667 | 253 | 0.866667 | 2.19266751 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 169 | 3.7999999999999997e-47 | NR | MEZ4282972.1 | 2818507 | g17482 | i0 | 100 | 0.99604743083004 | 84 | 0 | 99.6 | 0 | 1 | 252 | 327 | 410 | MEZ4282972.1 DUF3604 domain-containing protein [Myxococcota bacterium] | diamond | 252 | 169 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 28578845 | 28578845 | PRJNA772154_P_NODE_17967_length_252_cov_0.871508_g17782_i0 | PRJNA772154 | 17967 | 252 | 0.871508 | 2.19620016 | Myxococcia | 32015 | Bacteria | Bacteria | 120 | 1.27e-29 | NR | HEX3475790.1 | 2212474 | g17782 | i0 | 57.8 | 1.97619047619048 | 83 | 35 | 98.8 | 0 | 3 | 251 | 94 | 176 | HEX3475790.1 arabinan endo-1,5-alpha-L-arabinosidase [Kofleriaceae bacterium] | diamond | 498 | 120 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 28727084 | 28727084 | PRJNA772154_P_NODE_18287_length_252_cov_0.871508_g18102_i0 | PRJNA772154 | 18287 | 252 | 0.871508 | 2.19620016 | Archangium sp. | 1872627 | Bacteria | Bacteria | 132 | 9.42e-34 | NR | MDP3153305.1 | 1872627 | g18102 | i0 | 79.8 | 2.98809523809524 | 84 | 17 | 100 | 0 | 252 | 1 | 1153 | 1236 | MDP3153305.1 transglutaminase domain-containing protein [Archangium sp.] | diamond | 753 | 132 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 28894364 | 28894364 | PRJNA772154_P_NODE_20068_length_248_cov_0.891429_g19883_i0 | PRJNA772154 | 20068 | 248 | 0.891429 | 2.21074392 | Bacteria | 2 | Bacteria | Bacteria | 73.2 | 7.65e-13 | NR | MCC7382989.1 | 2026735 | g19883 | i0 | 50.6 | 1.91129032258065 | 79 | 39 | 95.6 | 0 | 245 | 9 | 603 | 681 | MCC7382989.1 MFS transporter [Deltaproteobacteria bacterium] | diamond | 474 | 73.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28916275 | 28916275 | PRJNA772154_P_NODE_19628_length_249_cov_0.886364_g19443_i0 | PRJNA772154 | 19628 | 249 | 0.886364 | 2.20704636 | Archangium sp. | 1872627 | Bacteria | Bacteria | 94 | 4.7500000000000005e-21 | NR | MBL8910636.1 | 1872627 | g19443 | i0 | 60.3 | 0.759036144578313 | 63 | 25 | 75.9 | 0 | 191 | 3 | 115 | 177 | MBL8910636.1 hypothetical protein [Archangium sp.] | diamond | 189 | 94 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 29705433 | 29705433 | PRJNA772154_P_NODE_19970_length_248_cov_0.891429_g19785_i0 | PRJNA772154 | 19970 | 248 | 0.891429 | 2.21074392 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 60.1 | 2.88e-8 | NR | MBI3543061.1 | 2026735 | g19785 | i0 | 40.3 | 0.931451612903226 | 77 | 44 | 93.1 | 1 | 240 | 10 | 153 | 227 | MBI3543061.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 231 | 60.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30558602 | 30558602 | PRJNA772154_P_NODE_20893_length_246_cov_0.901734_g20708_i0 | PRJNA772154 | 20893 | 246 | 0.901734 | 2.21826564 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 102 | 3.509999999999999e-23 | NR | MBX3228340.1 | 1971228 | g20708 | i0 | 75.4 | 0.792682926829268 | 65 | 16 | 79.3 | 0 | 2 | 196 | 371 | 435 | MBX3228340.1 hypothetical protein [Labilithrix sp.] | diamond | 195 | 102 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 31317223 | 31317223 | PRJNA772154_P_NODE_22155_length_243_cov_0.917647_g21970_i0 | PRJNA772154 | 22155 | 243 | 0.917647 | 2.22988221 | Archangium gephyra | 48 | Bacteria | Bacteria | 68.2 | 4.19e-11 | NR | PZR05792.1 | 48 | g21970 | i0 | 44.9 | 1.91358024691358 | 78 | 41 | 96.3 | 2 | 239 | 6 | 4837 | 4912 | PZR05792.1 MAG: hypothetical protein DI536_31570 [Archangium gephyra] | diamond | 465 | 68.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium gephyra | ||
| 31548429 | 31548429 | PRJNA772154_P_NODE_8276_length_406_cov_1.705706_g8091_i0 | PRJNA772154 | 8276 | 406 | 1.705706 | 6.92516636 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 140 | 3.39e-36 | NR | WP_309896008.1 | 1872627 | g8091 | i0 | 47.3 | 9.80541871921182 | 148 | 63 | 98.3 | 1 | 6 | 404 | 403 | 550 | WP_309896008.1 LysM peptidoglycan-binding domain-containing protein [Archangium sp.] | diamond | 3981 | 141 | 0.99290780141844 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 31823161 | 31823161 | PRJNA772154_P_NODE_14137_length_290_cov_1.396313_g13952_i0 | PRJNA772154 | 14137 | 290 | 1.396313 | 4.0493077 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 94 | 5.1e-20 | NR | MDB4946204.1 | 1971228 | g13952 | i0 | 60.4 | 0.993103448275862 | 96 | 38 | 99.3 | 0 | 3 | 290 | 28 | 123 | MDB4946204.1 integrase family protein [Labilithrix sp.] | diamond | 288 | 94 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 32171535 | 32171535 | PRJNA772154_P_NODE_20458_length_247_cov_0.896552_g20273_i0 | PRJNA772154 | 20458 | 247 | 0.896552 | 2.21448344 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 57.4 | 2.35e-7 | NR | WP_146654229.1 | 1391654 | g20273 | i0 | 59.6 | 1.1417004048583 | 47 | 19 | 57.1 | 0 | 1 | 141 | 259 | 305 | WP_146654229.1 hypothetical protein [Labilithrix luteola] | diamond | 282 | 57.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 32771405 | 32771405 | PRJNA772154_P_NODE_18580_length_251_cov_0.876404_g18395_i0 | PRJNA772154 | 18580 | 251 | 0.876404 | 2.19977404 | Archangium sp. | 1872627 | Bacteria | Bacteria | 154 | 2.2499999999999994e-42 | NR | MDP3151341.1 | 1872627 | g18395 | i0 | 75.9 | 2.97609561752988 | 83 | 20 | 99.2 | 0 | 250 | 2 | 73 | 155 | MDP3151341.1 sigma-54-dependent Fis family transcriptional regulator [Archangium sp.] | diamond | 747 | 154 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium 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);;