RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1111146" and tax_phylum = "Thermodesulfobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermodesulfobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1111146 · 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
1490961 1490961 PRJNA1111146_P_NODE_299302_length_187_cov_1.410448_g298164_i0 PRJNA1111146 299302 187 1.410448 2.63753776 Nitratidesulfovibrio liaohensis 2604158 Bacteria Bacteria 115 2.01e-21   NTclustered gi|2575677524|gb|CP133659.1| 2604158 g298164 i0 82.014 4.40641711229947 139 21 73 4 43 179 2071890 2071754 Nitratidesulfovibrio liaohensis strain KPS chromosome, complete genome blastn 824 115 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Nitratidesulfovibrio Nitratidesulfovibrio liaohensis
7399847 7399847 PRJNA1111146_P_NODE_401526_length_179_cov_0.904762_g400388_i0 PRJNA1111146 401526 179 0.904762 1.61952398 Desulfohalobium 45662 Bacteria Bacteria 148 1.8799999999999999e-31   NTclustered gi|470484951|ref|NR_076677.1| 45663 g400388 i0 82.222 23.9608938547486 180 25 100 6 1 179 1517 1690 Desulfohalobium retbaense strain DSM 5692 23S ribosomal RNA gene, complete sequence blastn 4289 148 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfohalobiaceae Desulfohalobium Desulfohalobium retbaense
18067590 18067590 PRJNA1111146_P_NODE_216535_length_203_cov_1.360000_g215397_i0 PRJNA1111146 216535 203 1.36 2.7608 Candidatus Electrothrix scaldis 3082418 Bacteria Bacteria 106 1.34e-18   NTclustered gi|2620278315|gb|CP138355.1| 3082418 g215397 i0 93.056 0.354679802955665 72 5 35 0 58 129 4243104 4243033 MAG: Candidatus Electrothrix scaldis isolate GW3-3 chromosome, complete genome blastn 72 106 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfobulbia Desulfobulbales Desulfobulbaceae Candidatus Electrothrix Candidatus Electrothrix scaldis
23169039 23169039 PRJNA1111146_P_NODE_389499_length_180_cov_0.881890_g388361_i0 PRJNA1111146 389499 180 0.88189 1.587402 Oceanidesulfovibrio marinus 370038 Bacteria Bacteria 106 1.16e-18   NTclustered gi|1841667704|gb|CP039543.1| 370038 g388361 i0 87.097 0.516666666666667 93 12 52 0 85 177 4377757 4377849 Oceanidesulfovibrio marinus strain CS1 chromosome, complete genome blastn 93 106 1 Bacteria   Pseudomonadati Thermodesulfobacteriota Desulfovibrionia Desulfovibrionales Desulfovibrionaceae Oceanidesulfovibrio Oceanidesulfovibrio marinus

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