RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA638138" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA638138 · 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
1885493 1885493 PRJNA638138_P_NODE_18362_length_256_cov_1.683060_g18147_i0 PRJNA638138 18362 256 1.68306 4.3086336 Pendulispora brunnea 2905690 Bacteria Bacteria 239 1.66e-58   NTclustered gi|2698055994|gb|CP089982.1| 2905690 g18147 i0 83.594 478.2109375 256 40 99 2 1 255 9038164 9037910 Pendulispora brunnea strain MSr12523 chromosome, complete genome blastn 122422 239 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora brunnea
2430470 2430470 PRJNA638138_P_NODE_31002_length_244_cov_0.900585_g30787_i0 PRJNA638138 31002 244 0.900585 2.1974274 Archangiaceae 39 Bacteria Bacteria 329 9.08e-86   NTclustered gi|2809295724|gb|CP102578.1| 48 g30787 i0 90.984 42.3360655737705 244 22 100 0 1 244 8267735 8267978 Archangium gephyra strain SDU49 chromosome, complete genome blastn 10330 329 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium gephyra
8262641 8262641 PRJNA638138_P_NODE_26307_length_247_cov_0.885057_g26092_i0 PRJNA638138 26307 247 0.885057 2.18609079 Minicystis rosea 888845 Bacteria Bacteria 124 4.66e-24   NTclustered gi|1127353251|gb|CP016211.1| 888845 g26092 i0 77.232 13.9311740890688 224 43 89 8 21 240 14278547 14278328 Minicystis rosea strain DSM 24000 chromosome, complete genome blastn 3441 124 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Minicystis Minicystis rosea
10083684 10083684 PRJNA638138_P_NODE_11048_length_319_cov_1.565041_g10833_i0 PRJNA638138 11048 319 1.565041 4.99248079 Myxococcia 32015 Bacteria Bacteria 340 5.699999999999999e-89   NTclustered gi|913610804|gb|CP012333.1| 1391654 g10833 i0 86.111 87.4702194357367 324 36 99 8 1 318 7915793 7915473 Labilithrix luteola strain DSM 27648, complete genome blastn 27903 340 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola
19006718 19006718 PRJNA638138_P_NODE_16035_length_274_cov_1.338308_g15820_i0 PRJNA638138 16035 274 1.338308 3.66696392 Pseudomonadati 3379134 Bacteria Bacteria 63.9 1.16e-5   NTclustered gi|913607065|gb|CP012332.1| 1391653 g15820 i0 85.246 14.3649635036496 61 9 22 0 144 204 2745002 2745062 Vulgatibacter incomptus strain DSM 27710, complete genome blastn 3936 63.9 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Vulgatibacteraceae Vulgatibacter Vulgatibacter incomptus
21011899 21011899 PRJNA638138_P_NODE_33337_length_242_cov_0.911243_g33122_i0 PRJNA638138 33337 242 0.911243 2.20520806 Labilithrix luteola 1391654 Bacteria Bacteria 143 1.2599999999999998e-29   NTclustered gi|913610804|gb|CP012333.1| 1391654 g33122 i0 89.474 0.768595041322314 114 11 47 1 43 156 6268215 6268327 Labilithrix luteola strain DSM 27648, complete genome blastn 186 143 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola

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