RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA781427", tax_clade = "Sar" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 16 ✖

tax_clade 1

  • Sar · 16 ✖

bioproject 1

  • PRJNA781427 · 16 ✖

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
26619707 26619707 PRJNA781427_P_NODE_86721_length_245_cov_1.720930_g85837_i0 PRJNA781427 86721 245 1.72093 4.2162785 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 103 1.7e-23   NR KAG7389890.1 221518 g85837 i0 57 9.68571428571429 79 34 96.7 0 244 8 135 213 KAG7389890.1 hypothetical protein PHYPSEUDO_009404 [Phytophthora pseudosyringae] diamond 2373 103 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora pseudosyringae
26873356 26873356 PRJNA781427_P_NODE_81541_length_248_cov_0.880000_g80657_i0 PRJNA781427 81541 248 0.88 2.1824 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 47.8 5.51e-4   NR KAJ8552409.1 4785 g80657 i0 95 0.592741935483871 20 1 24.2 0 61 2 181 200 KAJ8552409.1 hypothetical protein ON010_g10137 [Phytophthora cinnamomi] diamond 147 47.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
27717385 27717385 PRJNA781427_P_NODE_75244_length_251_cov_0.865169_g74360_i0 PRJNA781427 75244 251 0.865169 2.17157419 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 78.2 9.63e-15   NR KAJ8576473.1 4785 g74360 i0 90.5 0.50199203187251 42 4 50.2 0 110 235 1 42 KAJ8576473.1 hypothetical protein ON010_g2739 [Phytophthora cinnamomi] diamond 126 78.2 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
29210440 29210440 PRJNA781427_P_NODE_75769_length_251_cov_0.865169_g74885_i0 PRJNA781427 75769 251 0.865169 2.17157419 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 55.1 1.5e-6   NR DAZ99778.1 4803 g74885 i0 50.9 3.72908366533865 57 24 68.1 1 76 246 25 77 DAZ99778.1 TPA: hypothetical protein N0F65_001287, partial [Lagenidium giganteum] diamond 936 55.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
29579577 29579577 PRJNA781427_P_NODE_21630_length_518_cov_1.006742_g20755_i0 PRJNA781427 21630 518 1.006742 5.21492356 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 73.2 1.89e-12   NR GLD92146.1 114742 g20755 i0 33.1 2.92471042471042 163 76 94.4 4 490 2 1 130 GLD92146.1 hypothetical protein PINS_up000679 [Pythium insidiosum] diamond 1515 73.2 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
31042726 31042726 PRJNA781427_P_NODE_84235_length_247_cov_0.885057_g83351_i0 PRJNA781427 84235 247 0.885057 2.18609079 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 62.4 4.63e-9   NR KAF1334840.1 82926 g83351 i0 46.3 2.33198380566802 67 34 78.9 1 198 4 338 404 KAF1334840.1 Rcc1 and btb domain-containing protein, partial [Globisporangium splendens] diamond 576 62.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium Globisporangium splendens
32203274 32203274 PRJNA781427_P_NODE_22658_length_503_cov_1.841860_g21779_i0 PRJNA781427 22658 503 1.84186 9.2645558 Phytophthora idaei 53986 SAR_Eukaryotes SAR_Eukaryotes 49.3 0.00153   NR KAG3079860.1 53986 g21779 i0 51 0.840954274353877 49 22 28 1 303 443 56 104 KAG3079860.1 hypothetical protein PI125_g20606 [Phytophthora idaei] diamond 423 49.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora idaei
32551601 32551601 PRJNA781427_P_NODE_80119_length_249_cov_0.875000_g79235_i0 PRJNA781427 80119 249 0.875 2.17875 Phytophthora lilii 2077276 SAR_Eukaryotes SAR_Eukaryotes 73.9 4.02e-13   NR GMF13333.1 2077276 g79235 i0 54.5 2.40963855421687 66 30 79.5 0 50 247 302 367 GMF13333.1 unnamed protein product [Phytophthora lilii] diamond 600 73.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora lilii

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