RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA603943" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA603943 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
1853650 1853650 PRJNA603943_P_NODE_6262_length_613_cov_12.059259_g6076_i0 PRJNA603943 6262 613 12.059259 73.92325767 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 243 3.3600000000000007e-59   NTclustered gi|673019759|ref|XM_008865619.1| 157072 g6076 i0 79.05 13.6933115823817 358 71 58 4 104 459 482 127 Aphanomyces invadans 40S ribosomal protein S23 mRNA blastn 8394 243 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
8229875 8229875 PRJNA603943_P_NODE_20427_length_380_cov_1.003257_g20235_i0 PRJNA603943 20427 380 1.003257 3.8123766 Thraustotheca clavata 74557 SAR_Eukaryotes SAR_Eukaryotes 246 1.55e-60   NTclustered gi|59894163|gb|AY729864.1| 74557 g20235 i0 78.904 86.7868421052632 365 75 96 2 17 380 1307 944 Thraustotheca clavata heat shock protein 90 gene, partial cds blastn 32979 246 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
14605985 14605985 PRJNA603943_P_NODE_35052_length_309_cov_1.305085_g34860_i0 PRJNA603943 35052 309 1.305085 4.03271265 Phytophthora nicotianae 4792 SAR_Eukaryotes SAR_Eukaryotes 252 2.65e-62   NTclustered gi|675210554|ref|XM_008915914.1| 761204 g34860 i0 81.494 72.7281553398058 308 55 99 2 2 308 571 877 Phytophthora parasitica INRA-310 ATP-dependent RNA helicase eIF4A partial mRNA blastn 22473 252 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
16445923 16445923 PRJNA603943_P_NODE_5333_length_656_cov_2.355060_g5151_i0 PRJNA603943 5333 656 2.35506 15.4491936 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 488 4.199999999999999e-133   NTclustered gi|9858457|gb|AF085344.1|AF085344 82926 g5151 i0 86.057 67.7256097560976 459 59 70 4 50 506 28 483 Pythium splendens calmodulin mRNA, complete cds blastn 44428 492 0.991869918699187 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium Globisporangium splendens
17154864 17154864 PRJNA603943_P_NODE_37994_length_299_cov_0.902655_g37802_i0 PRJNA603943 37994 299 0.902655 2.69893845 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 191 5.65e-44   NTclustered gi|301114940|ref|XM_002999194.1| 403677 g37802 i0 79.699 11.3979933110368 266 52 89 2 35 299 854 590 Phytophthora infestans T30-4 pyrophosphate-energized vacuolar membrane proton pump, putative (PITG_05615), partial mRNA blastn 3408 191 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
20978687 20978687 PRJNA603943_P_NODE_10697_length_491_cov_8.131579_g10506_i0 PRJNA603943 10697 491 8.131579 39.92605289 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 281 5.61e-71   NTclustered gi|698807229|ref|XM_009838342.1| 112090 g10506 i0 80.533 68.8146639511202 375 65 75 4 121 488 441 68 Aphanomyces astaci polyubiquitin mRNA blastn 33788 281 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci

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