RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA352850" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA352850 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
395078 395078 PRJNA352850_P_NODE_22261_length_602_cov_1.875226_g19471_i0 PRJNA352850 22261 602 1.875226 11.28886052 Labilithrix luteola 1391654 Bacteria Bacteria 863 0   NTclustered gi|913610804|gb|CP012333.1| 1391654 g19471 i0 92.574 118.187707641196 606 38 100 6 1 602 7090094 7090696 Labilithrix luteola strain DSM 27648, complete genome blastn 71149 863 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola
2346593 2346593 PRJNA352850_P_NODE_3982_length_2142_cov_7.124224_g1_i264 PRJNA352850 3982 2142 7.124224 152.60087808 Pseudomonadati 3379134 Bacteria Bacteria 3646 0   NTclustered gi|13959815|gb|AY033407.1| 34 g1 i264 97.064 100.024276377218 2146 59 100 4 1 2142 1581 3726 Myxococcus xanthus USC7-1p and USC7-2p genes, complete cds blastn 214252 3646 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Myxococcus Myxococcus xanthus
11874096 11874096 PRJNA352850_P_NODE_3730_length_2253_cov_207.582577_g1_i252 PRJNA352850 3730 2253 207.582577 4676.83545981 Myxococcus xanthus 34 Bacteria Bacteria 2054 0   NTclustered gi|13959815|gb|AY033407.1| 34 g1 i252 97.813 105.106524633822 1189 24 53 2 1 1187 2580 1392 Myxococcus xanthus USC7-1p and USC7-2p genes, complete cds blastn 236805 2054 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Myxococcus Myxococcus xanthus
14423954 14423954 PRJNA352850_P_NODE_26252_length_536_cov_2.353183_g23429_i0 PRJNA352850 26252 536 2.353183 12.61306088 Labilithrix luteola 1391654 Bacteria Bacteria 771 0   NTclustered gi|913610804|gb|CP012333.1| 1391654 g23429 i0 93.182 162.738805970149 528 31 98 4 1 525 3942690 3942165 Labilithrix luteola strain DSM 27648, complete genome blastn 87228 771 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);;