contig_metadata
8 rows where bioproject = "PRJNA594101" and tax_phylum = "Mycoplasmatota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 567267 | 567267 | PRJNA594101_S_NODE_6801_length_626_cov_2.016275_g6505_i0 | PRJNA594101 | 6801 | 626 | 2.016275 | 12.6218815 | Mycoplasmatota bacterium | 2231116 | Bacteria | Bacteria | 69.4 | 6.17e-7 | NTclustered | gi|2040452726|gb|CP074573.1| | 2231116 | g6505 | i0 | 88.333 | 0.579872204472843 | 60 | 4 | 9 | 3 | 355 | 413 | 1911996 | 1912053 | Tenericutes bacterium strain zrk4 chromosome, complete genome | blastn | 363 | 69.4 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmatota bacterium | ||||||
| 7517288 | 7517288 | PRJNA594101_S_NODE_23626_length_347_cov_1.631387_g23324_i0 | PRJNA594101 | 23626 | 347 | 1.631387 | 5.66091289 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.033 | NTclustered | gi|1563789200|emb|LR214962.1| | 2115 | g23324 | i0 | 100 | 0.726224783861671 | 28 | 0 | 8 | 0 | 205 | 232 | 509845 | 509872 | Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 8 | blastn | 252 | 52.8 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Metamycoplasmataceae | Mycoplasmopsis | Mycoplasmopsis fermentans | |||
| 27016417 | 27016417 | PRJNA594101_S_NODE_48822_length_251_cov_1.022472_g48520_i0 | PRJNA594101 | 48822 | 251 | 1.022472 | 2.56640472 | Mycoplasmatota bacterium | 2231116 | Bacteria | Bacteria | 92 | 7.81e-20 | NR | MDO5393127.1 | 2231116 | g48520 | i0 | 57 | 0.944223107569721 | 79 | 34 | 94.4 | 0 | 3 | 239 | 124 | 202 | MDO5393127.1 AAA family ATPase [Mycoplasmatota bacterium] | diamond | 237 | 92 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmatota bacterium | ||||||
| 28406252 | 28406252 | PRJNA594101_S_NODE_27746_length_323_cov_1.240000_g27444_i0 | PRJNA594101 | 27746 | 323 | 1.24 | 4.0052 | [Mycoplasma] falconis | 92403 | Bacteria | Bacteria | 48.5 | 8.88e-4 | NR | WP_140781537.1 | 92403 | g27444 | i0 | 52.3 | 2.06191950464396 | 44 | 17 | 37.2 | 1 | 84 | 203 | 636 | 679 | WP_140781537.1 endopeptidase La [[Mycoplasma] falconis] | diamond | 666 | 48.5 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Metamycoplasmataceae | Metamycoplasma | [Mycoplasma] falconis | |||
| 28911049 | 28911049 | PRJNA594101_S_NODE_1328_length_1276_cov_3.039069_g1189_i0 | PRJNA594101 | 1328 | 1276 | 3.039069 | 38.77852044 | Acholeplasmataceae bacterium | 1898209 | Bacteria | Bacteria | 99.4 | 3.05e-20 | NR | NMA05705.1 | 1898209 | g1189 | i0 | 60.6 | 1.27899686520376 | 71 | 28 | 16.7 | 0 | 976 | 764 | 75 | 145 | NMA05705.1 DUF1343 domain-containing protein [Acholeplasmataceae bacterium] | diamond | 1632 | 99.4 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Acholeplasmatales | Acholeplasmataceae | Acholeplasmataceae bacterium | |||
| 28924647 | 28924647 | PRJNA594101_S_NODE_38708_length_279_cov_1.519417_g38406_i0 | PRJNA594101 | 38708 | 279 | 1.519417 | 4.23917343 | Bacteria | 2 | Bacteria | Bacteria | 47.8 | 8.68e-4 | NR | HHU80306.1 | 1898209 | g38406 | i0 | 33.3 | 2.12903225806452 | 81 | 50 | 82.8 | 1 | 235 | 5 | 77 | 157 | HHU80306.1 peptide chain release factor N(5)-glutamine methyltransferase [Acholeplasmataceae bacterium] | diamond | 594 | 47.8 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Acholeplasmatales | Acholeplasmataceae | Acholeplasmataceae bacterium | |||
| 29542742 | 29542742 | PRJNA594101_S_NODE_16130_length_414_cov_1.580645_g15828_i0 | PRJNA594101 | 16130 | 414 | 1.580645 | 6.5438703 | Mycoplasmopsis arginini | 2094 | Bacteria | Bacteria | 59.7 | 2.6e-7 | NR | WP_129694494.1 | 2094 | g15828 | i0 | 35.1 | 1.40579710144928 | 97 | 60 | 70.3 | 2 | 395 | 105 | 65 | 158 | WP_129694494.1 ribosome biogenesis GTPase Der [Mycoplasmopsis arginini] | diamond | 582 | 59.7 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Metamycoplasmataceae | Mycoplasmopsis | Mycoplasmopsis arginini | |||
| 31452195 | 31452195 | PRJNA594101_S_NODE_8616_length_558_cov_1.105155_g8316_i0 | PRJNA594101 | 8616 | 558 | 1.105155 | 6.1667649 | FCB group | 1783270 | Bacteria | Bacteria | 60.1 | 4.4e-7 | NR | AIV03421.1 | 1318617 | g8316 | i0 | 63.6 | 1.38172043010753 | 44 | 16 | 23.7 | 0 | 291 | 422 | 67 | 110 | AIV03421.1 ABC transporter ATP-binding protein [Candidatus Malacoplasma girerdii] | diamond | 771 | 60.5 | 0.993388429752066 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Mycoplasmoidaceae | Malacoplasma | Candidatus Malacoplasma girerdii |
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);;