RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA827593 · 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
821203 821203 PRJNA827593_P_NODE_35421_length_344_cov_1.623616_g35122_i0 PRJNA827593 35421 344 1.623616 5.58523904 Achlya hypogyna 1202772 SAR_Eukaryotes SAR_Eukaryotes 217 1.09e-51   NTclustered gi|542687346|ref|NC_022178.1| 1202772 g35122 i0 82.52 4.61627906976744 246 43 72 0 2 247 46499 46744 Achlya hypogyna mitochondrion, complete genome blastn 1588 217 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya hypogyna
2097108 2097108 PRJNA827593_P_NODE_60962_length_251_cov_1.713483_g60663_i0 PRJNA827593 60962 251 1.713483 4.30084233 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 58.4 4.89e-4   NTclustered gi|698779808|ref|XM_009824646.1| 112090 g60663 i0 97.059 0.135458167330677 34 1 14 0 198 231 578 545 Aphanomyces astaci hypothetical protein mRNA blastn 34 58.4 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
3780189 3780189 PRJNA827593_P_NODE_13143_length_600_cov_5.106262_g12849_i0 PRJNA827593 13143 600 5.106262 30.637572 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 159 3.4e-34   NTclustered gi|93139321|gb|DQ361206.1| 127442 g12849 i0 86.395 16.9683333333333 147 19 25 1 407 553 614 469 Phytophthora insolita strain MG 41-3 NADH dehydrogenase subunit 1 (ND1) gene, partial cds; mitochondrial blastn 10181 159 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora insolita
19947758 19947758 PRJNA827593_P_NODE_3876_length_1171_cov_2.469035_g3661_i0 PRJNA827593 3876 1171 2.469035 28.91239985 Nothophytophthora sp. 2853999 SAR_Eukaryotes SAR_Eukaryotes 263 5.070000000000001e-65   NTclustered gi|2240249467|gb|MW648547.1| 2853999 g3661 i0 81.677 23.6618274978651 322 54 27 5 5 325 10091 10408 Nothophytophthora sp. culture ICMP:18719 mitochondrion, complete genome blastn 27708 263 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Nothophytophthora Nothophytophthora sp.
21223390 21223390 PRJNA827593_P_NODE_46077_length_296_cov_36.085202_g45778_i0 PRJNA827593 46077 296 36.085202 106.81219792 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 508 1.36e-139   NTclustered gi|325194239|emb|FR825095.1| 890382 g45778 i0 98.611 102.060810810811 288 3 97 1 1 288 1176 890 Albugo laibachii Nc14, genomic contig CONTIG_1625_NC14_v4_1818_619 blastn 30210 508 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
25047966 25047966 PRJNA827593_P_NODE_64160_length_246_cov_1.786127_g63861_i0 PRJNA827593 64160 246 1.786127 4.39387242 Phytopythium vexans 907947 SAR_Eukaryotes SAR_Eukaryotes 399 6.889999999999999e-107   NTclustered gi|90655144|gb|DQ361265.1| 907947 g63861 i0 95.935 100 246 10 100 0 1 246 520 275 Pythium vexans large subunit ribosomal RNA gene, partial sequence blastn 24600 399 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Phytopythium Phytopythium vexans

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