RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1120203" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1120203 · 5 ✖

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
1549596 1549596 PRJNA1120203_P_NODE_54622_length_305_cov_3.508621_g53606_i0 PRJNA1120203 54622 305 3.508621 10.70129405 [Mycoplasma] cavipharyngis 92757 Bacteria Bacteria 453 6.67e-123   NTclustered gi|2735171757|gb|CP155569.1| 92757 g53606 i0 93.831 1.00983606557377 308 8 99 6 2 304 801379 801680 [Mycoplasma] cavipharyngis strain 117C chromosome, complete genome blastn 308 453 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Mycoplasmoides [Mycoplasma] cavipharyngis
15577452 15577452 PRJNA1120203_P_NODE_17413_length_650_cov_1.327556_g16419_i0 PRJNA1120203 17413 650 1.327556 8.629114 [Mycoplasma] cavipharyngis 92757 Bacteria Bacteria 922 0   NTclustered gi|2735171757|gb|CP155569.1| 92757 g16419 i0 92.237 1.01076923076923 657 42 100 9 1 650 987895 988549 [Mycoplasma] cavipharyngis strain 117C chromosome, complete genome blastn 657 922 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Mycoplasmoides [Mycoplasma] cavipharyngis
18126540 18126540 PRJNA1120203_P_NODE_39055_length_366_cov_1.313993_g38040_i0 PRJNA1120203 39055 366 1.313993 4.80921438 uncultured Mycoplasmatota bacterium 658143 Bacteria Bacteria 209 1.95e-49   NTclustered gi|2187163482|emb|OV788640.1| 658143 g38040 i0 78.549 5.17213114754098 317 68 87 0 13 329 122486 122802 uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1 blastn 1893 209 1 Bacteria   Bacillati Mycoplasmatota         uncultured Mycoplasmatota bacterium
23227346 23227346 PRJNA1120203_P_NODE_57799_length_296_cov_1.721973_g56783_i0 PRJNA1120203 57799 296 1.721973 5.09704008 uncultured Mycoplasmatota bacterium 658143 Bacteria Bacteria 316 8.83e-82   NTclustered gi|2187163482|emb|OV788640.1| 658143 g56783 i0 92 2.27702702702703 225 18 76 0 61 285 296570 296346 uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1 blastn 674 316 1 Bacteria   Bacillati Mycoplasmatota         uncultured Mycoplasmatota bacterium
26690192 26690192 PRJNA1120203_P_NODE_81301_length_250_cov_0.870056_g80285_i0 PRJNA1120203 81301 250 0.870056 2.17514 Mollicutes bacterium 37628 Bacteria Bacteria 78.6 9.64e-15   NR HHT38371.1 37628 g80285 i0 59.7 0.864 72 26 82.8 2 36 242 392 463 HHT38371.1 DUF5011 domain-containing protein [Mollicutes bacterium] diamond 216 78.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes       Mollicutes bacterium

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