RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA888821" 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

  • PRJNA888821 · 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
18714292 18714292 PRJNA888821_P_NODE_37575_length_245_cov_0.895349_g37492_i0 PRJNA888821 37575 245 0.895349 2.19360505 Mycoplasma yeatsii 51365 Bacteria Bacteria 394 3.189999999999999e-105   NTclustered gi|756767228|gb|CP007520.1| 743967 g37492 i0 96.624 1.93469387755102 237 8 97 0 9 245 307458 307694 Mycoplasma yeatsii GM274B blastn 474 394 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
21264895 21264895 PRJNA888821_P_NODE_37537_length_245_cov_0.895349_g37454_i0 PRJNA888821 37537 245 0.895349 2.19360505 Mycoplasma yeatsii 51365 Bacteria Bacteria 261 3.38e-65   NTclustered gi|756767228|gb|CP007520.1| 743967 g37454 i0 86.008 2.16326530612245 243 34 99 0 3 245 342897 342655 Mycoplasma yeatsii GM274B blastn 530 261 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
21644086 21644086 PRJNA888821_P_NODE_39357_length_241_cov_0.916667_g39274_i0 PRJNA888821 39357 241 0.916667 2.20916747 Mycoplasma 2093 Bacteria Bacteria 268 1.98e-67   NTclustered gi|2294785939|gb|CP103424.1| 51364 g39274 i0 88.053 1.93360995850622 226 27 94 0 14 239 680337 680112 Mycoplasma cottewii strain VIS chromosome, complete genome blastn 466 270 0.992592592592593 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
22539736 22539736 PRJNA888821_P_NODE_37478_length_245_cov_0.895349_g37395_i0 PRJNA888821 37478 245 0.895349 2.19360505 Mycoplasma cottewii 51364 Bacteria Bacteria 364 2.5e-96   NTclustered gi|2294785939|gb|CP103424.1| 51364 g37395 i0 93.469 5.01224489795918 245 16 100 0 1 245 433767 434011 Mycoplasma cottewii strain VIS chromosome, complete genome blastn 1228 364 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii
25088988 25088988 PRJNA888821_P_NODE_35680_length_249_cov_0.875000_g35597_i0 PRJNA888821 35680 249 0.875 2.17875 Mycoplasma yeatsii 51365 Bacteria Bacteria 322 1.56e-83   NTclustered gi|756767228|gb|CP007520.1| 743967 g35597 i0 89.96 2 249 25 100 0 1 249 524718 524470 Mycoplasma yeatsii GM274B blastn 498 322 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma yeatsii
25089051 25089051 PRJNA888821_P_NODE_39460_length_241_cov_0.916667_g39377_i0 PRJNA888821 39460 241 0.916667 2.20916747 Mycoplasma cottewii 51364 Bacteria Bacteria 351 1.91e-92   NTclustered gi|2294785939|gb|CP103424.1| 51364 g39377 i0 92.946 1 241 17 100 0 1 241 522226 522466 Mycoplasma cottewii strain VIS chromosome, complete genome blastn 241 351 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma cottewii

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