RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1041773 · 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
2721339 2721339 PRJNA1041773_P_NODE_81083_length_250_cov_0.864407_g80750_i0 PRJNA1041773 81083 250 0.864407 2.1610175 Haliangium ochraceum 80816 Bacteria Bacteria 124 4.729999999999999e-24   NTclustered gi|262076673|gb|CP001804.1| 502025 g80750 i0 84.496 52.264 129 16 52 4 122 250 3369953 3370077 Haliangium ochraceum DSM 14365, complete genome blastn 13066 124 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae Haliangium Haliangium ochraceum
2721397 2721397 PRJNA1041773_P_NODE_85123_length_248_cov_0.880000_g84790_i0 PRJNA1041773 85123 248 0.88 2.1824 Minicystis rosea 888845 Bacteria Bacteria 222 1.62e-53   NTclustered gi|1127353251|gb|CP016211.1| 888845 g84790 i0 86.058 0.838709677419355 208 27 83 2 1 207 2677826 2677620 Minicystis rosea strain DSM 24000 chromosome, complete genome blastn 208 222 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Minicystis Minicystis rosea
5272953 5272953 PRJNA1041773_P_NODE_30045_length_381_cov_3.737013_g29713_i0 PRJNA1041773 30045 381 3.737013 14.23801953 Anaeromyxobacter dehalogenans 161493 Bacteria Bacteria 211 5.66e-50   NTclustered gi|219952977|gb|CP001359.1| 455488 g29713 i0 81.111 5.72178477690289 270 45 70 5 110 376 4744873 4745139 Anaeromyxobacter dehalogenans 2CP-1 chromosome, complete genome blastn 2180 211 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Anaeromyxobacteraceae Anaeromyxobacter Anaeromyxobacter dehalogenans
17586404 17586404 PRJNA1041773_P_NODE_64094_length_272_cov_1.547739_g63761_i0 PRJNA1041773 64094 272 1.547739 4.20985008 Pseudomonadati 3379134 Bacteria Bacteria 171 6.599999999999999e-38   NTclustered gi|2700865302|gb|CP147913.1| 83455 g63761 i0 78.755 98.4154411764706 273 44 100 11 1 272 1950081 1949822 Myxococcus stipitatus strain KYC2006 chromosome, complete genome blastn 26769 171 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Myxococcus Myxococcus stipitatus
18022937 18022937 PRJNA1041773_P_NODE_94275_length_244_cov_0.900585_g93942_i0 PRJNA1041773 94275 244 0.900585 2.1974274 Anaeromyxobacter sp. Fw109-5 404589 Bacteria Bacteria 152 2.11e-32   NTclustered gi|152026452|gb|CP000769.1| 404589 g93942 i0 82.386 64.8893442622951 176 29 72 2 37 211 806753 806927 Anaeromyxobacter sp. Fw109-5, complete genome blastn 15833 152 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Anaeromyxobacteraceae Anaeromyxobacter Anaeromyxobacter sp. Fw109-5
23122833 23122833 PRJNA1041773_P_NODE_61959_length_276_cov_1.517241_g61626_i0 PRJNA1041773 61959 276 1.517241 4.18758516 Haliangium ochraceum 80816 Bacteria Bacteria 211 3.96e-50   NTclustered gi|262076673|gb|CP001804.1| 502025 g61626 i0 84.332 7.04347826086957 217 32 78 2 61 276 3341019 3340804 Haliangium ochraceum DSM 14365, complete genome blastn 1944 211 1 Bacteria   Pseudomonadati Myxococcota   Haliangiales Kofleriaceae Haliangium Haliangium ochraceum

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