contig_metadata
7 rows where bioproject = "PRJNA911178" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11453785 | 11453785 | PRJNA911178_P_NODE_224789_length_258_cov_2.470270_g222315_i0 | PRJNA911178 | 224789 | 258 | 2.47027 | 6.3732966 | Mycoplasmoidales | 2790996 | Bacteria | Bacteria | 327 | 3.48e-85 | NTclustered | gi|119369652|gb|EF061769.1| | 2097 | g222315 | i0 | 90.4 | 118.34496124031 | 250 | 23 | 97 | 1 | 1 | 250 | 308 | 60 | Mycoplasma genitalium strain ATCC 33530 23S ribosomal RNA gene, partial sequence | blastn | 30533 | 329 | 0.993920972644377 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Mycoplasmoidaceae | Mycoplasmoides | Mycoplasmoides genitalium | |||
| 16196446 | 16196446 | PRJNA911178_P_NODE_88293_length_381_cov_0.987013_g85823_i0 | PRJNA911178 | 88293 | 381 | 0.987013 | 3.76051953 | Malacoplasma muris | 2119 | Bacteria | Bacteria | 544 | 4.92e-150 | NTclustered | gi|299851933|gb|HM135461.1| | 2119 | g85823 | i0 | 92.612 | 124.010498687664 | 379 | 26 | 99 | 2 | 1 | 378 | 883 | 506 | Mycoplasma muris strain ATCC 33757 23S ribosomal RNA gene, partial sequence | blastn | 47248 | 544 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Mycoplasmoidaceae | Malacoplasma | Malacoplasma muris | |||
| 22568524 | 22568524 | PRJNA911178_P_NODE_121678_length_333_cov_1.173077_g119206_i0 | PRJNA911178 | 121678 | 333 | 1.173077 | 3.90634641 | uncultured Mycoplasma sp. | 167967 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|1775571725|gb|MN692881.1| | 167967 | g119206 | i0 | 83.333 | 0.36036036036036 | 60 | 10 | 18 | 0 | 67 | 126 | 701 | 642 | Uncultured Mycoplasma sp. clone 35a 23S ribosomal RNA gene, partial sequence | blastn | 120 | 56.5 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Mycoplasmatales | Mycoplasmataceae | Mycoplasma | uncultured Mycoplasma sp. | ||
| 24201021 | 24201021 | PRJNA911178_P_NODE_107199_length_351_cov_1.104317_g104727_i0 | PRJNA911178 | 107199 | 351 | 1.104317 | 3.87615267 | Mycoplasmoidales | 2790996 | Bacteria | Bacteria | 449 | 1.0099999999999998e-121 | NTclustered | gi|1563789200|emb|LR214962.1| | 2115 | g104727 | i0 | 90.616 | 116.430199430199 | 341 | 29 | 97 | 3 | 13 | 351 | 358293 | 357954 | Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 8 | blastn | 40867 | 449 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Metamycoplasmataceae | Mycoplasmopsis | Mycoplasmopsis fermentans | |||
| 29084703 | 29084703 | PRJNA911178_P_NODE_283348_length_243_cov_0.905882_g280874_i0 | PRJNA911178 | 283348 | 243 | 0.905882 | 2.20129326 | root | 1 | Root_unresolved | Root_unresolved | 99 | 5.46e-22 | NR | WP_206602619.1 | 2094 | g280874 | i0 | 72.6 | 402.851851851852 | 73 | 20 | 90.1 | 0 | 232 | 14 | 336 | 408 | WP_206602619.1 cbb3-type cytochrome c oxidase subunit I [Mycoplasmopsis arginini] | diamond | 97893 | 99.8 | 0.991983967935872 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Metamycoplasmataceae | Mycoplasmopsis | Mycoplasmopsis arginini | |||
| 29266402 | 29266402 | PRJNA911178_P_NODE_115709_length_340_cov_1.209738_g113237_i0 | PRJNA911178 | 115709 | 340 | 1.209738 | 4.1131092 | Malacoplasma muris | 2119 | Bacteria | Bacteria | 41.2 | 0.0474 | NR | WP_412031930.1 | 2119 | g113237 | i0 | 34.4 | 0.564705882352941 | 64 | 32 | 56.5 | 1 | 57 | 248 | 12 | 65 | WP_412031930.1 TM2 domain-containing protein [Malacoplasma muris] | diamond | 192 | 41.2 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mycoplasmoidales | Mycoplasmoidaceae | Malacoplasma | Malacoplasma muris | |||
| 32900099 | 32900099 | PRJNA911178_P_NODE_174140_length_286_cov_2.131455_g171667_i0 | PRJNA911178 | 174140 | 286 | 2.131455 | 6.0959613 | Candidatus Izimaplasma bacterium ZiA1 | 2024899 | Bacteria | Bacteria | 113 | 2.98e-29 | NR | PAT00927.1 | 2024899 | g171667 | i0 | 59.3 | 0.954545454545455 | 91 | 36 | 95.5 | 1 | 285 | 13 | 87 | 176 | PAT00927.1 hypothetical protein CI105_09315 [Candidatus Izimaplasma bacterium ZiA1] | diamond | 273 | 113 | 1 | Bacteria | Bacillati | Mycoplasmatota | Mollicutes | Candidatus Izemoplasmatales | Candidatus Izemoplasmataceae | Candidatus Izemoplasma | Candidatus Izimoplasma sp. ZiA1 |
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);;