contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA473824" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2997081 | 2997081 | PRJNA473824_P_NODE_140743_length_151_cov_5.438596_g140105_i0 | PRJNA473824 | 140743 | 151 | 5.438596 | 8.21227996 | Nannocystis punicea | 2995304 | Bacteria | Bacteria | 60.2 | 7.36e-5 | NTclustered | gi|2415023655|gb|CP114040.1| | 2995304 | g140105 | i0 | 89.362 | 0.311258278145695 | 47 | 5 | 31 | 0 | 105 | 151 | 5258114 | 5258068 | Nannocystis poenicansa strain FL3 chromosome, complete genome | blastn | 47 | 60.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis punicea | |||
| 2997828 | 2997828 | PRJNA473824_P_NODE_55063_length_173_cov_5.772059_g54425_i0 | PRJNA473824 | 55063 | 173 | 5.772059 | 9.98566207 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 54.7 | 0.004 | NTclustered | gi|1338588479|gb|CP012673.1| | 56 | g54425 | i0 | 96.97 | 0.190751445086705 | 33 | 0 | 18 | 1 | 141 | 172 | 12067971 | 12067939 | Sorangium cellulosum strain So ce26 chromosome, complete genome | blastn | 33 | 54.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 3647885 | 3647885 | PRJNA473824_P_NODE_97403_length_173_cov_2.823529_g96765_i0 | PRJNA473824 | 97403 | 173 | 2.823529 | 4.88470517 | Archangiaceae | 39 | Bacteria | Bacteria | 100 | 5.12e-17 | NTclustered | gi|2579656172|gb|CP043491.1| | 43 | g96765 | i0 | 90.667 | 3.2485549132948 | 75 | 7 | 43 | 0 | 1 | 75 | 9940044 | 9939970 | Cystobacter fuscus strain Cbf 10 chromosome, complete genome | blastn | 562 | 100 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Cystobacter | Cystobacter fuscus | ||
| 4273474 | 4273474 | PRJNA473824_P_NODE_15504_length_303_cov_3.759398_g14867_i0 | PRJNA473824 | 15504 | 303 | 3.759398 | 11.39097594 | Archangium violaceum | 83451 | Bacteria | Bacteria | 305 | 1.96e-78 | NTclustered | gi|1985695619|gb|CP069396.1| | 83451 | g14867 | i0 | 84.918 | 23.980198019802 | 305 | 42 | 100 | 4 | 1 | 303 | 931560 | 931258 | Archangium violaceum strain SDU8 chromosome, complete genome | blastn | 7266 | 305 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium violaceum | ||
| 6824096 | 6824096 | PRJNA473824_P_NODE_146426_length_151_cov_4.175439_g145788_i0 | PRJNA473824 | 146426 | 151 | 4.175439 | 6.30491289 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 67.6 | 4.4e-7 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g145788 | i0 | 93.333 | 24.4569536423841 | 45 | 3 | 30 | 0 | 29 | 73 | 1416 | 1372 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 3693 | 67.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 13200677 | 13200677 | PRJNA473824_P_NODE_46711_length_180_cov_2.496503_g46073_i0 | PRJNA473824 | 46711 | 180 | 2.496503 | 4.4937054 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 272 | 1.08e-68 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g46073 | i0 | 93.889 | 181.072222222222 | 180 | 11 | 100 | 0 | 1 | 180 | 3942294 | 3942115 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 32593 | 272 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 14474973 | 14474973 | PRJNA473824_P_NODE_143672_length_151_cov_4.622807_g143034_i0 | PRJNA473824 | 143672 | 151 | 4.622807 | 6.98043857 | Archangium violaceum | 83451 | Bacteria | Bacteria | 60.2 | 7.36e-5 | NTclustered | gi|1985695619|gb|CP069396.1| | 83451 | g143034 | i0 | 92.683 | 0.271523178807947 | 41 | 3 | 27 | 0 | 92 | 132 | 7089457 | 7089497 | Archangium violaceum strain SDU8 chromosome, complete genome | blastn | 41 | 60.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium violaceum | ||
| 14475568 | 14475568 | PRJNA473824_P_NODE_45312_length_182_cov_3.289655_g44674_i0 | PRJNA473824 | 45312 | 182 | 3.289655 | 5.9871721 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 65.8 | 1.99e-6 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g44674 | i0 | 97.368 | 0.208791208791209 | 38 | 1 | 21 | 0 | 145 | 182 | 10138665 | 10138628 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 38 | 65.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 16399189 | 16399189 | PRJNA473824_P_NODE_55573_length_173_cov_5.639706_g54935_i0 | PRJNA473824 | 55573 | 173 | 5.639706 | 9.75669138 | Myxococcales | 29 | Bacteria | Bacteria | 71.3 | 4.01e-8 | NTclustered | gi|2869653495|gb|CP175551.1| | 33 | g54935 | i0 | 97.561 | 9.47976878612717 | 41 | 1 | 24 | 0 | 1 | 41 | 4197684 | 4197724 | Myxococcus fulvus strain KYC1117 chromosome, complete genome | blastn | 1640 | 71.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus fulvus | ||
| 19573078 | 19573078 | PRJNA473824_P_NODE_81936_length_173_cov_3.316176_g81298_i0 | PRJNA473824 | 81936 | 173 | 3.316176 | 5.73698448 | Corallococcus exercitus | 2316736 | Bacteria | Bacteria | 65.8 | 1.87e-6 | NTclustered | gi|2809270164|gb|CP102577.1| | 2316736 | g81298 | i0 | 97.368 | 0.219653179190751 | 38 | 1 | 22 | 0 | 3 | 40 | 8672086 | 8672049 | Corallococcus exercitus strain SDU142 chromosome, complete genome | blastn | 38 | 65.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus exercitus | ||
| 22773646 | 22773646 | PRJNA473824_P_NODE_73438_length_173_cov_3.713235_g72800_i0 | PRJNA473824 | 73438 | 173 | 3.713235 | 6.42389655 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 62.1 | 2.41e-5 | NTclustered | gi|262076673|gb|CP001804.1| | 502025 | g72800 | i0 | 86.667 | 1.09248554913295 | 60 | 2 | 33 | 5 | 13 | 69 | 2953980 | 2954036 | Haliangium ochraceum DSM 14365, complete genome | blastn | 189 | 62.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Haliangium | Haliangium ochraceum | |||
| 23399033 | 23399033 | PRJNA473824_P_NODE_27859_length_225_cov_2.063830_g27221_i0 | PRJNA473824 | 27859 | 225 | 2.06383 | 4.6436175 | Nannocystis punicea | 2995304 | Bacteria | Bacteria | 121 | 5.409999999999999e-23 | NTclustered | gi|2415023655|gb|CP114040.1| | 2995304 | g27221 | i0 | 98.529 | 3.44 | 68 | 1 | 30 | 0 | 156 | 223 | 2589362 | 2589295 | Nannocystis poenicansa strain FL3 chromosome, complete genome | blastn | 774 | 121 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis punicea | |||
| 23399156 | 23399156 | PRJNA473824_P_NODE_36239_length_200_cov_4.030675_g35601_i0 | PRJNA473824 | 36239 | 200 | 4.030675 | 8.06135 | Archangium violaceum | 83451 | Bacteria | Bacteria | 158 | 3.58e-34 | NTclustered | gi|2579675135|gb|CP043493.1| | 83451 | g35601 | i0 | 94.175 | 46.695 | 103 | 6 | 52 | 0 | 98 | 200 | 7364227 | 7364125 | Archangium violaceum strain Cbvi 34 chromosome, complete genome | blastn | 9339 | 158 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium violaceum | ||
| 24673467 | 24673467 | PRJNA473824_P_NODE_9320_length_423_cov_1.720207_g8704_i0 | PRJNA473824 | 9320 | 423 | 1.720207 | 7.27647561 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 532 | 1.1899999999999996e-146 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g8704 | i0 | 90.049 | 220.295508274232 | 412 | 40 | 97 | 1 | 1 | 412 | 3942541 | 3942951 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 93185 | 532 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 25322648 | 25322648 | PRJNA473824_P_NODE_31800_length_212_cov_2.348571_g31162_i0 | PRJNA473824 | 31800 | 212 | 2.348571 | 4.97897052 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 213 | 8.08e-51 | NTclustered | gi|2700865302|gb|CP147913.1| | 83455 | g31162 | i0 | 87.5 | 93.5896226415094 | 184 | 23 | 87 | 0 | 29 | 212 | 1013825 | 1013642 | Myxococcus stipitatus strain KYC2006 chromosome, complete genome | blastn | 19841 | 215 | 0.990697674418605 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus stipitatus |
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);;