RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA781427" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 8 ✖

tax_clade 1

bioproject 1

  • PRJNA781427 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
4589119 4589119 PRJNA781427_P_NODE_48764_length_324_cov_0.900398_g47881_i0 PRJNA781427 48764 324 0.900398 2.91728952 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 571 1.8899999999999993e-158   NTclustered gi|2795028942|ref|XM_067942968.1| 4785 g47881 i0 98.457 36.141975308642 324 5 100 0 1 324 343 20 Phytophthora cinnamomi uncharacterized protein (IUM83_17995), partial mRNA blastn 11710 571 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
5865151 5865151 PRJNA781427_P_NODE_81585_length_248_cov_0.880000_g80701_i0 PRJNA781427 81585 248 0.88 2.1824 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 363 9.119999999999997e-96   NTclustered gi|2795061338|ref|XM_067943727.1| 4785 g80701 i0 95.964 1.63306451612903 223 9 90 0 1 223 67 289 Phytophthora cinnamomi uncharacterized protein (IUM83_18717), partial mRNA blastn 405 363 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
9690138 9690138 PRJNA781427_P_NODE_82048_length_248_cov_0.880000_g81164_i0 PRJNA781427 82048 248 0.88 2.1824 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 137 6.019999999999999e-28   NTclustered gi|2795042171|ref|XM_067924356.1| 4785 g81164 i0 86.885 24.6572580645161 122 16 49 0 125 246 845 724 Phytophthora cinnamomi RuvB-like 1 (IUM83_00575), partial mRNA blastn 6115 137 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
12691508 12691508 PRJNA781427_P_NODE_57790_length_293_cov_1.322727_g56906_i0 PRJNA781427 57790 293 1.322727 3.87559011 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 542 1.32e-149   NTclustered gi|2651589115|gb|PP108238.1| 4785 g56906 i0 100 99.6382252559727 293 0 100 0 1 293 5405 5113 Phytophthora cinnamomi strain CT09CHAP1 mitochondrion, complete genome blastn 29194 542 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
18613245 18613245 PRJNA781427_P_NODE_79715_length_249_cov_0.875000_g78831_i0 PRJNA781427 79715 249 0.875 2.17875 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 342 1.1899999999999999e-89   NTclustered gi|2795040952|ref|XM_067932626.1| 4785 g78831 i0 91.87 29.1004016064257 246 19 98 1 1 245 2071 2316 Phytophthora cinnamomi reverse transcriptase (IUM83_08263), partial mRNA blastn 7246 342 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
18613624 18613624 PRJNA781427_P_NODE_95215_length_241_cov_1.642857_g94331_i0 PRJNA781427 95215 241 1.642857 3.95928537 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 392 1.1299999999999999e-104   NTclustered gi|2795020529|ref|XM_067931603.1| 4785 g94331 i0 96.61 1.70954356846473 236 8 98 0 1 236 689 924 Phytophthora cinnamomi reverse transcriptase (IUM83_07317), partial mRNA blastn 412 392 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
19063151 19063151 PRJNA781427_P_NODE_11955_length_754_cov_6.812041_g11184_i0 PRJNA781427 11955 754 6.812041 51.36278914 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 239 5.41e-58   NTclustered gi|2795048880|ref|XM_067943659.1| 4785 g11184 i0 77.694 5.99071618037135 399 84 52 4 250 644 42 439 Phytophthora cinnamomi Calmodulin (IUM83_18649), partial mRNA blastn 4517 239 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
21614326 21614326 PRJNA781427_P_NODE_88297_length_245_cov_0.895349_g87413_i0 PRJNA781427 88297 245 0.895349 2.19360505 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 453 5.1900000000000006e-123   NTclustered gi|2651589115|gb|PP108238.1| 4785 g87413 i0 100 99.9265306122449 245 0 100 0 1 245 36129 36373 Phytophthora cinnamomi strain CT09CHAP1 mitochondrion, complete genome blastn 24482 453 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi

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