RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1195374" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1195374 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
5424950 5424950 PRJNA1195374_P_NODE_50045_length_311_cov_0.970588_g49701_i0 PRJNA1195374 50045 311 0.970588 3.01852868 Pseudodesulfovibrio thermohalotolerans 2880651 Bacteria Bacteria 89.8 2.22e-13   NTclustered gi|2489621199|gb|CP120635.1| 2880651 g49701 i0 94.737 18.5659163987138 57 3 18 0 13 69 1248073 1248129 Pseudodesulfovibrio thermohalotolerans strain MCM B-1480 chromosome, complete genome blastn 5774 89.8 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio thermohalotolerans
11800539 11800539 PRJNA1195374_P_NODE_6230_length_852_cov_5.028241_g5947_i0 PRJNA1195374 6230 852 5.028241 42.84061332 Pseudodesulfovibrio piezophilus 879567 Bacteria Bacteria 69.4 8.52e-7   NTclustered gi|451894361|emb|FO203427.1| 1322246 g5947 i0 78.992 3.25469483568075 119 11 13 10 650 758 2361904 2362018 Desulfovibrio piezophilus C1TLV30 complete genome blastn 2773 69.4 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Pseudodesulfovibrio Pseudodesulfovibrio piezophilus
23274162 23274162 PRJNA1195374_P_NODE_59779_length_280_cov_1.647343_g59435_i0 PRJNA1195374 59779 280 1.647343 4.6125604 Desulfonema magnum 45655 Bacteria Bacteria 73.1 1.98e-8   NTclustered gi|2007135636|gb|CP061800.1| 45655 g59435 i0 95.556 30.0642857142857 45 2 16 0 101 145 7206149 7206105 Desulfonema magnum strain 4be13 chromosome, complete genome blastn 8418 73.1 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobacteria Desulfobacterales Desulfococcaceae Desulfonema Desulfonema magnum

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