RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1215813" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 10 ✖

tax_clade 1

bioproject 1

  • PRJNA1215813 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
331609 331609 PRJNA1215813_P_NODE_12421_length_242_cov_0.923077_g12341_i0 PRJNA1215813 12421 242 0.923077 2.23384634 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 75 4.65e-9   NTclustered gi|673054658|ref|XM_008883068.1| 157072 g12341 i0 86.567 1.18181818181818 67 9 28 0 174 240 728 662 Aphanomyces invadans hypothetical protein partial mRNA blastn 286 75 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
331659 331659 PRJNA1215813_P_NODE_3601_length_400_cov_13.626911_g3521_i0 PRJNA1215813 3601 400 13.626911 54.507644 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 281 4.49e-71   NTclustered gi|698807229|ref|XM_009838342.1| 112090 g3521 i0 80.533 84.57 375 65 92 4 19 386 441 68 Aphanomyces astaci polyubiquitin mRNA blastn 33828 281 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
331680 331680 PRJNA1215813_P_NODE_4721_length_353_cov_1.310714_g4641_i0 PRJNA1215813 4721 353 1.310714 4.62682042 Pythium pyrilobum 289602 SAR_Eukaryotes SAR_Eukaryotes 198 4.05e-46   NTclustered gi|442591655|gb|JX115106.1| 289602 g4641 i0 78.287 0.926345609065156 327 57 91 12 33 352 806 487 Pythium pyrilobum voucher CBS:158.64 PF16 gene, partial cds blastn 327 198 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium pyrilobum
2882629 2882629 PRJNA1215813_P_NODE_10983_length_247_cov_0.896552_g10903_i0 PRJNA1215813 10983 247 0.896552 2.21448344 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 215 2.69e-51   NTclustered gi|2795037130|ref|XM_067927279.1| 4785 g10903 i0 83.7 49.6275303643725 227 37 92 0 21 247 977 751 Phytophthora cinnamomi rRNA 2'-O-methyltransferase fibrillarin (IUM83_03289), partial mRNA blastn 12258 215 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
4158740 4158740 PRJNA1215813_P_NODE_1984_length_527_cov_5.792952_g1904_i0 PRJNA1215813 1984 527 5.792952 30.52885704 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 243 2.8600000000000007e-59   NTclustered gi|673019759|ref|XM_008865619.1| 157072 g1904 i0 79.05 15.0379506641366 358 71 68 4 72 427 482 127 Aphanomyces invadans 40S ribosomal protein S23 mRNA blastn 7925 243 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
5434919 5434919 PRJNA1215813_P_NODE_10365_length_249_cov_1.329545_g10285_i0 PRJNA1215813 10365 249 1.329545 3.31056705 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 161 3.59e-35   NTclustered gi|301103136|ref|XM_002900609.1| 403677 g10285 i0 91.453 3.8995983935743 117 10 47 0 131 247 555 439 Phytophthora infestans T30-4 caltractin (PITG_13132), mRNA blastn 971 161 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
9259725 9259725 PRJNA1215813_P_NODE_3768_length_392_cov_1.652038_g3688_i0 PRJNA1215813 3768 392 1.652038 6.47598896 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 65.8 4.81e-6   NTclustered gi|2795057561|ref|XM_067940854.1| 4785 g3688 i0 97.368 0.839285714285714 38 1 10 0 177 214 1051 1088 Phytophthora cinnamomi heterogeneous nuclear ribonucleoprotein 1-like isoform x1 (IUM83_16000), partial mRNA blastn 329 65.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
11810370 11810370 PRJNA1215813_P_NODE_11350_length_246_cov_0.901734_g11270_i0 PRJNA1215813 11350 246 0.901734 2.21826564 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.002   NTclustered gi|2795055637|ref|XM_067944964.1| 4785 g11270 i0 100 0.121951219512195 30 0 12 0 182 211 549 578 Phytophthora cinnamomi Glyceraldehyde-3-phosphate dehydrogenase (IUM83_19895), partial mRNA blastn 30 56.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
22008486 22008486 PRJNA1215813_P_NODE_5998_length_318_cov_1.322449_g5918_i0 PRJNA1215813 5998 318 1.322449 4.20538782 Phytophthora ramorum 164328 SAR_Eukaryotes SAR_Eukaryotes 137 8.000000000000001e-28   NTclustered gi|2794930454|ref|XM_067885800.1| 164328 g5918 i0 78.774 5.34905660377358 212 39 65 6 88 293 1512 1723 Phytophthora ramorum Chaperonin CPN60-2, mitochondrial (KRP23_14921), partial mRNA blastn 1701 137 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum
24557932 24557932 PRJNA1215813_P_NODE_4240_length_371_cov_1.697987_g4160_i0 PRJNA1215813 4240 371 1.697987 6.29953177 Thraustotheca clavata 74557 SAR_Eukaryotes SAR_Eukaryotes 307 6.82e-79   NTclustered gi|59894163|gb|AY729864.1| 74557 g4160 i0 81.843 98.544474393531 369 63 99 4 1 367 860 1226 Thraustotheca clavata heat shock protein 90 gene, partial cds blastn 36560 307 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata

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