RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA896554" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA896554 · 5 ✖

analysis 1

  • blastn · 5 ✖

tax_kingdom 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
870500 870500 PRJNA896554_P_NODE_149921_length_251_cov_0.865169_g142381_i0 PRJNA896554 149921 251 0.865169 2.17157419 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 58.4 4.89e-4   NTclustered gi|698801807|ref|XM_009835631.1| 112090 g142381 i0 94.595 0.147410358565737 37 2 15 0 70 106 3098 3062 Aphanomyces astaci isoleucine-tRNA ligase mRNA blastn 37 58.4 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
7249860 7249860 PRJNA896554_P_NODE_55786_length_586_cov_4.621832_g48304_i0 PRJNA896554 55786 586 4.621832 27.08393552 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 281 6.78e-71   NTclustered gi|698807229|ref|XM_009838342.1| 112090 g48304 i0 80.533 57.7269624573379 375 65 63 4 22 389 68 441 Aphanomyces astaci polyubiquitin mRNA blastn 33828 281 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
7621906 7621906 PRJNA896554_P_NODE_86026_length_375_cov_1.178808_g78486_i0 PRJNA896554 86026 375 1.178808 4.42053 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 211 5.56e-50   NTclustered gi|937408816|ref|NC_027966.1| 114742 g78486 i0 79.739 87.858666666666707 306 51 80 10 67 366 9797 10097 Pythium insidiosum mitochondrial DNA, complete genome blastn 32947 213 0.990610328638498 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
11073956 11073956 PRJNA896554_P_NODE_148109_length_253_cov_1.100000_g140569_i0 PRJNA896554 148109 253 1.1 2.783 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 89.8 1.75e-13   NTclustered gi|166039189|emb|CU355239.1| 100861 g140569 i0 89.855 5.39525691699605 69 7 27 0 185 253 744 676 Aphanomyces euteiches cDNA blastn 1365 89.8 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
11076130 11076130 PRJNA896554_P_NODE_93609_length_349_cov_1.619565_g86069_i0 PRJNA896554 93609 349 1.619565 5.65228185 Lagenidium giganteum 4803 SAR_Eukaryotes SAR_Eukaryotes 263 1.4e-65   NTclustered gi|1219685856|gb|KY965925.1| 1440116 g86069 i0 80.501 32.323782234957 359 56 100 13 1 349 327 681 Lagenidium giganteum f. caninum isolate UF15-01 heat shock protein 90 (hsp90) gene, partial cds blastn 11281 263 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum

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