RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA1068513" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1068513 · 7 ✖

tax_clade 0

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
6559715 6559715 PRJNA1068513_S_NODE_11766_length_256_cov_2.464481_g11720_i0 PRJNA1068513 11766 256 2.464481 6.30907136 Mesoplasma entomophilum 2149 Bacteria Bacteria 52.8 0.023   NTclustered gi|1359432926|gb|CP022507.1| 2149 g11720 i0 100 0.328125 28 0 11 0 162 189 434124 434097 Mesoplasma entomophilum strain W17 chromosome blastn 84 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Entomoplasmataceae Mesoplasma Mesoplasma entomophilum
9109442 9109442 PRJNA1068513_S_NODE_6508_length_358_cov_2.315789_g6462_i0 PRJNA1068513 6508 358 2.315789 8.29052462 Mycoplasmatota bacterium WC30 3075149 Bacteria Bacteria 52.8 0.034   NTclustered gi|2877983046|gb|CP134495.1| 3075149 g6462 i0 100 0.0782122905027933 28 0 8 0 72 99 816940 816967 Mycoplasmatota bacterium WC30 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota         Mycoplasmatota bacterium WC30
10385184 10385184 PRJNA1068513_S_NODE_6529_length_358_cov_0.975439_g6483_i0 PRJNA1068513 6529 358 0.975439 3.49207162 Mycoplasma sp. 1654_15 2725994 Bacteria Bacteria 56.5 0.003   NTclustered gi|1832581539|gb|CP051214.1| 2725994 g6483 i0 97.059 0.0949720670391061 34 0 9 1 37 70 766149 766181 Mycoplasma sp. 1654_15 chromosome, complete genome blastn 34 56.5 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma sp. 1654_15
11660462 11660462 PRJNA1068513_S_NODE_12870_length_246_cov_1.352601_g12824_i0 PRJNA1068513 12870 246 1.352601 3.32739846 Spiroplasma endosymbiont of Virgichneumon dumeticola 3139323 Bacteria Bacteria 52.8 0.022   NTclustered gi|2806755735|emb|OZ183478.1| 3139323 g12824 i0 100 0.113821138211382 28 0 11 0 42 69 394438 394465 Spiroplasma endosymbiont of Virgichneumon dumeticola isolate 1d0b8646-e6ec-424d-883d-cc2662152a42 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma endosymbiont of Virgichneumon dumeticola
16758766 16758766 PRJNA1068513_S_NODE_2134_length_559_cov_1.288066_g2092_i0 PRJNA1068513 2134 559 1.288066 7.20028894 Mycoplasmatota bacterium WC44 3076018 Bacteria Bacteria 56.5 0.004   NTclustered gi|2878023906|gb|CP134881.1| 3076018 g2092 i0 94.444 0.0644007155635063 36 2 6 0 348 383 2015778 2015813 Mycoplasmatota bacterium WC44 chromosome, complete genome blastn 36 56.5 1 Bacteria   Bacillati Mycoplasmatota         Mycoplasmatota bacterium WC44
24407703 24407703 PRJNA1068513_S_NODE_12720_length_247_cov_1.649425_g12674_i0 PRJNA1068513 12720 247 1.649425 4.07407975 Mycoplasmopsis bovis 28903 Bacteria Bacteria 52.8 0.022   NTclustered gi|1951470321|gb|CP058446.1| 28903 g12674 i0 100 0.11336032388664 28 0 11 0 161 188 208535 208562 Mycoplasmopsis bovis strain Mb166 chromosome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis bovis
32122278 32122278 PRJNA1068513_S_NODE_10638_length_273_cov_2.235000_g10592_i0 PRJNA1068513 10638 273 2.235 6.10155 Candidatus Malacoplasma girerdii 1318617 Bacteria Bacteria 47.4 0.00124   NR ASJ88972.1 1318617 g10592 i0 37.2 1.59340659340659 78 40 80.2 3 246 28 261 334 ASJ88972.1 MAG: GTPase Obg [Candidatus Malacoplasma girerdii] diamond 435 47.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Malacoplasma Candidatus Malacoplasma girerdii

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;