RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJEB28062", 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

  • PRJEB28062 · 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
2262288 2262288 PRJEB28062_P_NODE_114602_length_274_cov_2.029851_g112239_i0 PRJEB28062 114602 274 2.029851 5.56179174 root 1 Root_unresolved Root_unresolved 501 2.08e-137   NTclustered gi|166046558|emb|CU367675.1| 100861 g112239 i0 99.635 103.748175182482 274 1 100 0 1 274 693 420 Aphanomyces euteiches cDNA blastn 28427 501 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
2262314 2262314 PRJEB28062_P_NODE_118242_length_265_cov_1.333333_g115879_i0 PRJEB28062 118242 265 1.333333 3.53333245 root 1 Root_unresolved Root_unresolved 457 4.39e-124   NTclustered gi|166046538|emb|CU367655.1| 100861 g115879 i0 100 18.6415094339623 247 0 93 0 19 265 452 698 Aphanomyces euteiches cDNA blastn 4940 457 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
3538178 3538178 PRJEB28062_P_NODE_51723_length_494_cov_7.391924_g49372_i0 PRJEB28062 51723 494 7.391924 36.51610456 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 708 0   NTclustered gi|33520214|gb|AY273959.1| 162095 g49372 i0 95.133 91.0728744939271 452 15 91 6 26 474 357 804 Peronospora pulveracea large subunit ribosomal RNA gene, partial sequence blastn 44990 708 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora pulveracea
6402166 6402166 PRJEB28062_P_NODE_132466_length_235_cov_2.518519_g130102_i0 PRJEB28062 132466 235 2.518519 5.91851965 Peronospora pulveracea 162095 SAR_Eukaryotes SAR_Eukaryotes 379 8.509999999999998e-101   NTclustered gi|1359853439|gb|MH057164.1| 162095 g130102 i0 99.057 87.1191489361702 212 1 90 1 20 231 620 830 Peronospora pulveracea strain 16-1687 large subunit ribosomal RNA gene, partial sequence blastn 20473 379 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora pulveracea
7677816 7677816 PRJEB28062_P_NODE_81667_length_371_cov_22.050336_g79305_i0 PRJEB28062 81667 371 22.050336 81.80674656 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 311 5.27e-80   NTclustered gi|325195470|emb|FR826264.1| 890382 g79305 i0 91.556 0.606469002695418 225 19 61 0 24 248 225 1 Albugo laibachii Nc14, genomic contig CONTIG_3390_NC14_v4_382_47 blastn 225 311 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
11190324 11190324 PRJEB28062_P_NODE_120529_length_259_cov_2.758065_g118165_i0 PRJEB28062 120529 259 2.758065 7.14338835 root 1 Root_unresolved Root_unresolved 422 1.56e-113   NTclustered gi|166046519|emb|CU367636.1| 100861 g118165 i0 100 88.1081081081081 228 0 88 0 10 237 658 431 Aphanomyces euteiches cDNA blastn 22820 422 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
16600902 16600902 PRJEB28062_P_NODE_135354_length_222_cov_6.026846_g132990_i0 PRJEB28062 135354 222 6.026846 13.37959812 Saprolegnia ferax 4770 SAR_Eukaryotes SAR_Eukaryotes 337 4.85e-88   NTclustered gi|50261276|ref|NC_005984.1| 4770 g132990 i0 97.462 99.3063063063063 197 5 89 0 26 222 9744 9940 Saprolegnia ferax mitochondrion, complete genome blastn 22046 337 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia ferax
20114451 20114451 PRJEB28062_P_NODE_91876_length_339_cov_4.048872_g89514_i0 PRJEB28062 91876 339 4.048872 13.72567608 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 392 1.66e-104   NTclustered gi|2440150|emb|X75631.1| 4788 g89514 i0 93.233 66.4719764011799 266 18 95 0 74 339 3623 3358 P.megasperma gene for 28S ribosomal RNA blastn 22534 392 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora megasperma
27279696 27279696 PRJEB28062_P_NODE_124603_length_250_cov_3.209040_g122239_i0 PRJEB28062 124603 250 3.20904 8.0226 Peronospora 70742 SAR_Eukaryotes SAR_Eukaryotes 150 2.34e-40   NR CAI5730607.1 86335 g122239 i0 93.4 1.824 76 5 91.2 0 3 230 482 557 CAI5730607.1 unnamed protein product [Peronospora destructor] diamond 456 150 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora destructor
27595606 27595606 PRJEB28062_P_NODE_72644_length_402_cov_1.854103_g70283_i0 PRJEB28062 72644 402 1.854103 7.45349406 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 141 2.95e-40   NR OQS00817.1 74557 g70283 i0 62.3 10.2611940298507 114 43 85.1 0 383 42 22 135 OQS00817.1 60S ribosomal protein L32-1 [Thraustotheca clavata] diamond 4125 141 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
28195162 28195162 PRJEB28062_P_NODE_57086_length_466_cov_1.157761_g54732_i0 PRJEB28062 57086 466 1.157761 5.39516626 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 134 1.53e-35   NR KAG1703260.1 4784 g54732 i0 64 10.9957081545064 100 36 64.4 0 162 461 1 100 KAG1703260.1 hypothetical protein DVH05_008170 [Phytophthora capsici] diamond 5124 134 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
28612345 28612345 PRJEB28062_P_NODE_83247_length_366_cov_11.430034_g80885_i0 PRJEB28062 83247 366 11.430034 41.83392444 Peronospora destructor 86335 SAR_Eukaryotes SAR_Eukaryotes 132 8.78e-37   NR CAI5745261.1 86335 g80885 i0 82.2 0.598360655737705 73 13 59.8 0 18 236 59 131 CAI5745261.1 unnamed protein product [Peronospora destructor] diamond 219 132 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora destructor
28833268 28833268 PRJEB28062_P_NODE_44208_length_542_cov_8.946695_g41869_i0 PRJEB28062 44208 542 8.946695 48.4910869 Peronospora effusa 542832 SAR_Eukaryotes SAR_Eukaryotes 186 2.6699999999999993e-52   NR RQM14400.1 542832 g41869 i0 72.7 3.76937269372694 132 31 70.3 1 27 407 461 592 RQM14400.1 hypothetical protein DD237_004691 [Peronospora effusa] diamond 2043 186 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora effusa
28928028 28928028 PRJEB28062_P_NODE_94028_length_333_cov_1.184615_g91666_i0 PRJEB28062 94028 333 1.184615 3.94476795 Peronospora belbahrii 622444 SAR_Eukaryotes SAR_Eukaryotes 76.3 1.78e-13   NR CAH0517189.1 622444 g91666 i0 47.3 0.837837837837838 93 48 83.8 1 281 3 394 485 CAH0517189.1 unnamed protein product [Peronospora belbahrii] diamond 279 76.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora belbahrii
29395196 29395196 PRJEB28062_P_NODE_131589_length_238_cov_4.842424_g129225_i0 PRJEB28062 131589 238 4.842424 11.52496912 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 103 1.43e-26   NR ETK85160.1 4792 g129225 i0 71.2 1.66386554621849 66 19 83.2 0 11 208 47 112 ETK85160.1 peptidyl-prolyl isomerase FKBP12 [Phytophthora nicotianae] diamond 396 103 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
31771540 31771540 PRJEB28062_P_NODE_39597_length_578_cov_49.803960_g37264_i0 PRJEB28062 39597 578 49.80396 287.8668888 Aphanomyces stellatus 120398 SAR_Eukaryotes SAR_Eukaryotes 80.9 5.92e-14   NR KAF0719010.1 120398 g37264 i0 39.5 1.07958477508651 114 69 59.2 0 222 563 416 529 KAF0719010.1 hypothetical protein As57867_001329, partial [Aphanomyces stellatus] diamond 624 80.9 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus

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