contig_metadata
29 rows where analysis = "diamond", bioproject = "PRJNA603943" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 577300 | 577300 | PRJNA603943_P_NODE_4361_length_715_cov_1.199377_g4183_i0 | PRJNA603943 | 4361 | 715 | 1.199377 | 8.57554555 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 379 | 6.1e-129 | NR | RYZ13579.1 | 2484252 | g4183 | i0 | 79.6 | 0.986013986013986 | 235 | 48 | 98.6 | 0 | 9 | 713 | 43 | 277 | RYZ13579.1 MAG: ABC-F family ATP-binding cassette domain-containing protein, partial [Myxococcaceae bacterium] | diamond | 705 | 379 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 10071917 | 10071917 | PRJNA603943_P_NODE_68908_length_242_cov_0.899408_g68716_i0 | PRJNA603943 | 68908 | 242 | 0.899408 | 2.17656736 | Labilithrix | 1524217 | Bacteria | Bacteria | 107 | 5.07e-25 | NR | WP_169927527.1 | 1391654 | g68716 | i0 | 72 | 4.88429752066116 | 82 | 20 | 97.9 | 1 | 240 | 4 | 58 | 139 | WP_169927527.1 diguanylate cyclase [Labilithrix luteola] | diamond | 1182 | 108 | 0.990740740740741 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 12057234 | 12057234 | PRJNA603943_P_NODE_66950_length_243_cov_0.905882_g66758_i0 | PRJNA603943 | 66950 | 243 | 0.905882 | 2.20129326 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 112 | 1.5500000000000002e-26 | NR | HVJ89238.1 | 1971228 | g66758 | i0 | 75 | 3.46913580246914 | 68 | 14 | 80.2 | 1 | 47 | 241 | 65 | 132 | HVJ89238.1 glycosyltransferase family 39 protein [Labilithrix sp.] | diamond | 843 | 112 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 15880676 | 15880676 | PRJNA603943_P_NODE_59833_length_247_cov_0.885057_g59641_i0 | PRJNA603943 | 59833 | 247 | 0.885057 | 2.18609079 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 87.4 | 2.97e-18 | NR | MCA9584421.1 | 2026763 | g59641 | i0 | 51.2 | 0.995951417004049 | 82 | 40 | 99.6 | 0 | 1 | 246 | 18 | 99 | MCA9584421.1 hypothetical protein [Myxococcales bacterium] | diamond | 246 | 87.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 26636723 | 26636723 | PRJNA603943_P_NODE_55901_length_249_cov_1.312500_g55709_i0 | PRJNA603943 | 55901 | 249 | 1.3125 | 3.268125 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 117 | 7.26e-29 | NR | HVZ36904.1 | 2268199 | g55709 | i0 | 84.1 | 1.97590361445783 | 82 | 10 | 98.8 | 1 | 247 | 2 | 66 | 144 | HVZ36904.1 IS66 family transposase [Polyangiaceae bacterium] | diamond | 492 | 117 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 26636730 | 26636730 | PRJNA603943_P_NODE_66801_length_243_cov_0.905882_g66609_i0 | PRJNA603943 | 66801 | 243 | 0.905882 | 2.20129326 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 55.5 | 6.86e-7 | NR | MBK6459719.1 | 2026763 | g66609 | i0 | 44.8 | 0.716049382716049 | 58 | 32 | 71.6 | 0 | 179 | 6 | 137 | 194 | MBK6459719.1 hypothetical protein [Myxococcales bacterium] | diamond | 174 | 55.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27301304 | 27301304 | PRJNA603943_P_NODE_56443_length_249_cov_0.875000_g56251_i0 | PRJNA603943 | 56443 | 249 | 0.875 | 2.17875 | Archangiaceae bacterium | 2684409 | Bacteria | Bacteria | 64.7 | 7.43e-10 | NR | MBM4779431.1 | 2684409 | g56251 | i0 | 54.7 | 0.771084337349398 | 64 | 22 | 77.1 | 3 | 49 | 240 | 1 | 57 | MBM4779431.1 hypothetical protein [Archangiaceae bacterium] | diamond | 192 | 64.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangiaceae bacterium | |||
| 27427845 | 27427845 | PRJNA603943_P_NODE_59523_length_247_cov_0.885057_g59331_i0 | PRJNA603943 | 59523 | 247 | 0.885057 | 2.18609079 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 94.7 | 1.74e-20 | NR | MBK8255090.1 | 2268199 | g59331 | i0 | 54.3 | 1.96761133603239 | 81 | 37 | 98.4 | 0 | 5 | 247 | 236 | 316 | MBK8255090.1 mechanosensitive ion channel [Polyangiaceae bacterium] | diamond | 486 | 94.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27756866 | 27756866 | PRJNA603943_P_NODE_67184_length_243_cov_0.905882_g66992_i0 | PRJNA603943 | 67184 | 243 | 0.905882 | 2.20129326 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 96.7 | 2.8e-21 | NR | RLA95620.1 | 2026735 | g66992 | i0 | 59 | 8.65432098765432 | 78 | 31 | 96.3 | 1 | 236 | 3 | 101 | 177 | RLA95620.1 MAG: peptidase [Deltaproteobacteria bacterium] | diamond | 2103 | 97.1 | 0.995880535530381 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28059034 | 28059034 | PRJNA603943_P_NODE_51505_length_254_cov_1.513812_g51313_i0 | PRJNA603943 | 51505 | 254 | 1.513812 | 3.84508248 | Sandaracinus sp. | 2024858 | Bacteria | Bacteria | 70.5 | 7.71e-13 | NR | MAT24617.1 | 2024858 | g51313 | i0 | 45.8 | 2.59842519685039 | 72 | 39 | 85 | 0 | 18 | 233 | 13 | 84 | MAT24617.1 hypothetical protein [Sandaracinus sp.] | diamond | 660 | 70.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus sp. | |||
| 28279907 | 28279907 | PRJNA603943_P_NODE_29386_length_331_cov_2.984496_g29194_i0 | PRJNA603943 | 29386 | 331 | 2.984496 | 9.87868176 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 86.3 | 1.91e-19 | NR | MBN2798920.1 | 2026735 | g29194 | i0 | 48.3 | 0.788519637462236 | 87 | 45 | 78.9 | 0 | 1 | 261 | 4 | 90 | MBN2798920.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 261 | 86.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28279921 | 28279921 | PRJNA603943_P_NODE_4966_length_675_cov_2.898671_g4784_i0 | PRJNA603943 | 4966 | 675 | 2.898671 | 19.56602925 | Stigmatella hybrida | 394097 | Bacteria | Bacteria | 68.9 | 2.04e-9 | NR | WP_225412049.1 | 394097 | g4784 | i0 | 43.2 | 0.711111111111111 | 81 | 42 | 36 | 1 | 360 | 118 | 1920 | 1996 | WP_225412049.1 RHS repeat-associated core domain-containing protein [Stigmatella hybrida] | diamond | 480 | 68.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Stigmatella | Stigmatella hybrida | ||
| 28640852 | 28640852 | PRJNA603943_P_NODE_62207_length_246_cov_0.890173_g62015_i0 | PRJNA603943 | 62207 | 246 | 0.890173 | 2.18982558 | Sorangium | 39643 | Bacteria | Bacteria | 85.9 | 1.46e-17 | NR | WP_129352675.1 | 56 | g62015 | i0 | 56.3 | 1.9390243902439 | 80 | 35 | 97.6 | 0 | 3 | 242 | 230 | 309 | WP_129352675.1 hybrid sensor histidine kinase/response regulator [Sorangium cellulosum] | diamond | 477 | 86.3 | 0.995365005793743 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 28785115 | 28785115 | PRJNA603943_P_NODE_52607_length_251_cov_0.865169_g52415_i0 | PRJNA603943 | 52607 | 251 | 0.865169 | 2.17157419 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 96.3 | 3.6100000000000005e-21 | NR | MEO6774999.1 | 2212474 | g52415 | i0 | 60.2 | 1.9840637450199201 | 83 | 31 | 99.2 | 2 | 250 | 2 | 255 | 335 | MEO6774999.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 498 | 96.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 29195895 | 29195895 | PRJNA603943_P_NODE_44349_length_278_cov_1.058537_g44157_i0 | PRJNA603943 | 44349 | 278 | 1.058537 | 2.94273286 | Pendulispora albinea | 2741071 | Bacteria | Bacteria | 83.6 | 2.44e-17 | NR | WP_394822069.1 | 2741071 | g44157 | i0 | 51.7 | 2.23381294964029 | 87 | 41 | 92.8 | 1 | 260 | 3 | 4 | 90 | WP_394822069.1 MlaC/ttg2D family ABC transporter substrate-binding protein [Pendulispora albinea] | diamond | 621 | 83.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora albinea | ||
| 29227570 | 29227570 | PRJNA603943_P_NODE_59369_length_247_cov_1.091954_g59177_i0 | PRJNA603943 | 59369 | 247 | 1.091954 | 2.69712638 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 68.2 | 3.78e-11 | NR | MBL8612221.1 | 2026763 | g59177 | i0 | 49.4 | 1.91902834008097 | 79 | 34 | 94.7 | 3 | 246 | 13 | 154 | 227 | MBL8612221.1 PEGA domain-containing protein [Myxococcales bacterium] | diamond | 474 | 68.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29511350 | 29511350 | PRJNA603943_P_NODE_45490_length_274_cov_1.333333_g45298_i0 | PRJNA603943 | 45490 | 274 | 1.333333 | 3.65333242 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 147 | 7.73e-42 | NR | MFO0669622.1 | 2268199 | g45298 | i0 | 83.3 | 1.97080291970803 | 90 | 15 | 98.5 | 0 | 272 | 3 | 66 | 155 | MFO0669622.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 540 | 147 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 29763909 | 29763909 | PRJNA603943_P_NODE_62531_length_245_cov_1.511628_g62339_i0 | PRJNA603943 | 62531 | 245 | 1.511628 | 3.7034886 | Sandaracinus sp. | 2024858 | Bacteria | Bacteria | 141 | 1.9199999999999998e-40 | NR | MFO0711652.1 | 2024858 | g62339 | i0 | 82.7 | 3.95510204081633 | 81 | 14 | 99.2 | 0 | 245 | 3 | 110 | 190 | MFO0711652.1 winged helix-turn-helix domain-containing protein [Sandaracinus sp.] | diamond | 969 | 141 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus sp. | |||
| 29858752 | 29858752 | PRJNA603943_P_NODE_41591_length_286_cov_1.422535_g41399_i0 | PRJNA603943 | 41591 | 286 | 1.422535 | 4.0684501 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 65.5 | 5.27e-10 | NR | MEO7111969.1 | 2268199 | g41399 | i0 | 50.8 | 0.63986013986014 | 61 | 27 | 60.8 | 1 | 175 | 2 | 36 | 96 | MEO7111969.1 S1 family peptidase [Polyangiaceae bacterium] | diamond | 183 | 65.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30838268 | 30838268 | PRJNA603943_P_NODE_66254_length_243_cov_0.905882_g66062_i0 | PRJNA603943 | 66254 | 243 | 0.905882 | 2.20129326 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 97.8 | 1.5300000000000002e-21 | NR | HSO31943.1 | 1971228 | g66062 | i0 | 66.3 | 0.987654320987654 | 80 | 26 | 98.8 | 1 | 3 | 242 | 354 | 432 | HSO31943.1 DUF5682 family protein [Labilithrix sp.] | diamond | 240 | 97.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 31059736 | 31059736 | PRJNA603943_P_NODE_42915_length_282_cov_1.464115_g42723_i0 | PRJNA603943 | 42915 | 282 | 1.464115 | 4.1288043 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 109 | 1.72e-25 | NR | MBL8606167.1 | 2026763 | g42723 | i0 | 55.7 | 0.936170212765957 | 88 | 39 | 93.6 | 0 | 2 | 265 | 823 | 910 | MBL8606167.1 hypothetical protein [Myxococcales bacterium] | diamond | 264 | 109 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31502305 | 31502305 | PRJNA603943_P_NODE_69596_length_241_cov_0.916667_g69404_i0 | PRJNA603943 | 69596 | 241 | 0.916667 | 2.20916747 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 45.1 | 0.00509 | NR | MBX3186330.1 | 1971228 | g69404 | i0 | 41.5 | 0.659751037344398 | 53 | 31 | 66 | 0 | 162 | 4 | 177 | 229 | MBX3186330.1 hypothetical protein [Labilithrix sp.] | diamond | 159 | 45.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 31628562 | 31628562 | PRJNA603943_P_NODE_42816_length_282_cov_2.205742_g42624_i0 | PRJNA603943 | 42816 | 282 | 2.205742 | 6.22019244 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 145 | 1.33e-38 | NR | MDB5213087.1 | 2484252 | g42624 | i0 | 81 | 0.893617021276596 | 84 | 16 | 89.4 | 0 | 3 | 254 | 460 | 543 | MDB5213087.1 regulator of chromosome condensation [Myxococcaceae bacterium] | diamond | 252 | 145 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 32293368 | 32293368 | PRJNA603943_P_NODE_68679_length_242_cov_0.911243_g68487_i0 | PRJNA603943 | 68679 | 242 | 0.911243 | 2.20520806 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 72 | 1.15e-12 | NR | MDB4943484.1 | 1971228 | g68487 | i0 | 57.4 | 1.64876033057851 | 68 | 29 | 84.3 | 0 | 35 | 238 | 35 | 102 | MDB4943484.1 helix-turn-helix protein [Labilithrix sp.] | diamond | 399 | 72 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 32324936 | 32324936 | PRJNA603943_P_NODE_23639_length_360_cov_0.989547_g23447_i0 | PRJNA603943 | 23639 | 360 | 0.989547 | 3.5623692 | Myxococcus llanfairpwllgwyngyllgogerychwyrndrobwllllantysiliogogogochensis | 2590453 | Bacteria | Bacteria | 67 | 1.19e-10 | NR | WP_141648050.1 | 2590453 | g23447 | i0 | 40.2 | 2.14166666666667 | 107 | 48 | 89.2 | 3 | 360 | 40 | 121 | 211 | WP_141648050.1 glycoside hydrolase family 19 protein [Myxococcus llanfairpwllgwyngyllgogerychwyrndrobwllllantysiliogogogochensis] | diamond | 771 | 67 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus llanfairpwllgwyngyllgogerychwyrndrobwllllantysiliogogogochensis | ||
| 32419593 | 32419593 | PRJNA603943_P_NODE_41039_length_288_cov_1.120930_g40847_i0 | PRJNA603943 | 41039 | 288 | 1.12093 | 3.2282784 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 147 | 3.5e-39 | NR | HSO35327.1 | 1971228 | g40847 | i0 | 81.1 | 0.989583333333333 | 95 | 18 | 99 | 0 | 2 | 286 | 199 | 293 | HSO35327.1 ABC transporter ATP-binding protein [Labilithrix sp.] | diamond | 285 | 147 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 32640420 | 32640420 | PRJNA603943_P_NODE_67920_length_242_cov_0.911243_g67728_i0 | PRJNA603943 | 67920 | 242 | 0.911243 | 2.20520806 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 66.6 | 1.45e-10 | NR | MCL2779080.1 | 2268199 | g67728 | i0 | 46.8 | 1.95867768595041 | 79 | 41 | 97.9 | 1 | 239 | 3 | 3550 | 3627 | MCL2779080.1 tetratricopeptide repeat protein [Polyangiaceae bacterium] | diamond | 474 | 66.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32811274 | 32811274 | PRJNA603943_P_NODE_64400_length_244_cov_0.900585_g64208_i0 | PRJNA603943 | 64400 | 244 | 0.900585 | 2.1974274 | Bacteria | 2 | Bacteria | Bacteria | 47.4 | 8.86e-4 | NR | HWL85915.1 | 2268199 | g64208 | i0 | 48.9 | 1.30327868852459 | 45 | 23 | 55.3 | 0 | 5 | 139 | 514 | 558 | HWL85915.1 DEAD/DEAH box helicase [Polyangiaceae bacterium] | diamond | 318 | 47.8 | 0.99163179916318 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32892437 | 32892437 | PRJNA603943_P_NODE_54440_length_250_cov_0.870056_g54248_i0 | PRJNA603943 | 54440 | 250 | 0.870056 | 2.17514 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 127 | 5.219999999999999e-32 | NR | HSO40759.1 | 1971228 | g54248 | i0 | 69.1 | 0.972 | 81 | 25 | 97.2 | 0 | 3 | 245 | 337 | 417 | HSO40759.1 glycosyltransferase family 2 protein [Labilithrix sp.] | diamond | 243 | 127 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix 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);;