RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA340009" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA340009 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
2942834 2942834 PRJNA340009_P_NODE_39783_length_201_cov_64.388158_g39476_i0 PRJNA340009 39783 201 64.388158 129.42019758 Spiroplasma culicicola 216935 Bacteria Bacteria 141 3.63e-29   NTclustered gi|583840421|gb|CP006681.1| 1276246 g39476 i0 80.978 33.7064676616915 184 29 90 6 9 189 402392 402572 Spiroplasma culicicola AES-1, complete genome blastn 6775 141 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Spiroplasmataceae Spiroplasma Spiroplasma culicicola
9998356 9998356 PRJNA340009_P_NODE_80868_length_151_cov_27.823529_g80561_i0 PRJNA340009 80868 151 27.823529 42.01352879 root 1 Root_unresolved Root_unresolved 71.3 3.4e-8   NTclustered gi|38481951|gb|AY374418.1| 2097 g80561 i0 88.136 14.0529801324503 59 7 39 0 93 151 640 698 Mycoplasma genitalium genotype 2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 2122 71.3 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Mycoplasmoidaceae Mycoplasmoides Mycoplasmoides genitalium
10595735 10595735 PRJNA340009_P_NODE_24809_length_246_cov_4.131980_g24502_i0 PRJNA340009 24809 246 4.13198 10.1646708 Candidatus Tyloplasma litorale 3132031 Bacteria Bacteria 91.6 4.71e-14   NTclustered gi|2413215879|dbj|AP027078.1| 3132031 g24502 i0 87.342 3.04878048780488 79 10 32 0 41 119 559736 559814 MAG: Candidatus Tyloplasma litorale Fukuoka2020 DNA, complete genome blastn 750 91.6 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Candidatus Hepatoplasmataceae Candidatus Tyloplasma Candidatus Tyloplasma litorale
15695172 15695172 PRJNA340009_P_NODE_72673_length_162_cov_19.106195_g72366_i0 PRJNA340009 72673 162 19.106195 30.9520359 Candidatus Izimoplasma sp. HR1 1541959 Bacteria Bacteria 52.8 0.013   NTclustered gi|685629397|gb|CP009415.1| 1541959 g72366 i0 100 0.172839506172839 28 0 17 0 1 28 832274 832301 Candidatus Izimaplasma bacterium HR1 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Candidatus Izemoplasmatales Candidatus Izemoplasmataceae Candidatus Izemoplasma Candidatus Izimoplasma sp. HR1
20196249 20196249 PRJNA340009_P_NODE_73416_length_162_cov_1.389381_g73109_i0 PRJNA340009 73416 162 1.389381 2.25079722 Mesoplasma 46239 Bacteria Bacteria 115 1.7e-21   NTclustered gi|1359432926|gb|CP022507.1| 2149 g73109 i0 97.059 15.537037037037 68 2 42 0 66 133 87658 87725 Mesoplasma entomophilum strain W17 chromosome blastn 2517 115 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Entomoplasmatales Entomoplasmataceae Mesoplasma Mesoplasma entomophilum
24618250 24618250 PRJNA340009_P_NODE_33740_length_216_cov_2.095808_g33433_i0 PRJNA340009 33740 216 2.095808 4.52694528 Acholeplasmataceae bacterium 1898209 Bacteria Bacteria 108 4.01e-19   NTclustered gi|2621784701|emb|OY781159.1| 1898209 g33433 i0 92.105 26.8240740740741 76 6 35 0 2 77 1557764 1557689 MAG: Acholeplasmataceae bacterium isolate b77914f2-8fec-49c8-ab37-f01becaaac15 genome assembly, chromosome: 1 blastn 5794 108 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Acholeplasmatales Acholeplasmataceae   Acholeplasmataceae 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);;