RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJEB3181" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 17 ✖

tax_clade 1

bioproject 1

  • PRJEB3181 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
18840532 18840532 PRJEB3181_S_NODE_1415_length_414_cov_374.131926_g1127_i0 PRJEB3181 1415 414 374.131926 1548.90617364 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 102 1.82e-22   NR OQS07615.1 74557 g1127 i0 81 1.26086956521739 58 11 42 0 414 241 450 507 OQS07615.1 thioredoxin reductase [Thraustotheca clavata] diamond 522 102 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
24281896 24281896 PRJEB3181_S_NODE_2300_length_354_cov_6.442006_g2007_i0 PRJEB3181 2300 354 6.442006 22.80470124 Pythiaceae 4782 SAR_Eukaryotes SAR_Eukaryotes 90.9 1.64e-20   NR TMW64892.1 41045 g2007 i0 80 3.72881355932203 55 11 46.6 0 2 166 94 148 TMW64892.1 hypothetical protein Poli38472_009059 [Pythium oligandrum] diamond 1320 90.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
27254435 27254435 PRJEB3181_S_NODE_11303_length_191_cov_2.153846_g11010_i0 PRJEB3181 11303 191 2.153846 4.11384586 [Pythium] brassicae (nom. inval.) 1485010 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00154   NR TYZ57660.1 1485010 g11010 i0 64.5 0.973821989528796 31 11 48.7 0 1 93 743 773 TYZ57660.1 hypothetical protein PybrP1_012513 [[Pythium] brassicae (nom. inval.)] diamond 186 45.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium [Pythium] brassicae (nom. inval.)
27343071 27343071 PRJEB3181_P_NODE_19923_length_184_cov_3.202614_g19659_i0 PRJEB3181 19923 184 3.202614 5.89280976 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 51.2 3.29e-6   NR KAF0682728.1 120398 g19659 i0 76.9 4.23913043478261 26 6 42.4 0 180 103 92 117 KAF0682728.1 hypothetical protein As57867_025101 [Aphanomyces stellatus] diamond 780 51.2 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
27847904 27847904 PRJEB3181_S_NODE_10024_length_201_cov_0.993976_g9731_i0 PRJEB3181 10024 201 0.993976 1.99789176 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 62 1.48e-10   NR KAF0729344.1 100861 g9731 i0 64.9 1.1044776119403 37 13 55.2 0 6 116 59 95 KAF0729344.1 hypothetical protein Ae201684_013089 [Aphanomyces euteiches] diamond 222 62.4 0.993589743589744 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
28454697 28454697 PRJEB3181_S_NODE_15486_length_165_cov_1.530769_g15193_i0 PRJEB3181 15486 165 1.530769 2.52576885 Aphanomyces cochlioides 112091 SAR_Eukaryotes SAR_Eukaryotes 41.2 0.0324   NR KAG9399323.1 112091 g15193 i0 63.9 0.654545454545455 36 11 61.8 1 3 104 135 170 KAG9399323.1 hypothetical protein AC1031_011670 [Aphanomyces cochlioides] diamond 108 41.2 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces cochlioides
28517735 28517735 PRJEB3181_P_NODE_27307_length_153_cov_1.803279_g27042_i0 PRJEB3181 27307 153 1.803279 2.75901687 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 51.2 1.99e-6   NR XP_008874596.1 157072 g27042 i0 73.3 0.588235294117647 30 8 58.8 0 152 63 88 117 XP_008874596.1 hypothetical protein H310_10110 [Aphanomyces invadans] diamond 90 51.2 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
29180903 29180903 PRJEB3181_S_NODE_12369_length_183_cov_2.554054_g12076_i0 PRJEB3181 12369 183 2.554054 4.67391882 Aphanomyces cochlioides 112091 SAR_Eukaryotes SAR_Eukaryotes 102 1.31e-24   NR KAG9410527.1 112091 g12076 i0 96.3 1.77049180327869 54 2 88.5 0 3 164 237 290 KAG9410527.1 hypothetical protein AC1031_018567 [Aphanomyces cochlioides] diamond 324 102 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces cochlioides
29963645 29963645 PRJEB3181_P_NODE_14211_length_224_cov_1.518135_g13947_i0 PRJEB3181 14211 224 1.518135 3.4006224 root 1 Root_unresolved Root_unresolved 126 4.7e-35   NR RHY29645.1 157072 g13947 i0 70.3 51.8035714285714 74 22 99.1 0 223 2 92 165 RHY29645.1 hypothetical protein DYB32_004989 [Aphanomyces invadans] diamond 11604 126 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
30633425 30633425 PRJEB3181_P_NODE_2733_length_442_cov_2.119221_g2525_i0 PRJEB3181 2733 442 2.119221 9.36695682 Aphanomyces cochlioides 112091 SAR_Eukaryotes SAR_Eukaryotes 136 3.23e-36   NR KAG9410527.1 112091 g2525 i0 94.2 0.468325791855204 69 4 46.8 0 440 234 222 290 KAG9410527.1 hypothetical protein AC1031_018567 [Aphanomyces cochlioides] diamond 207 136 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces cochlioides
30753487 30753487 PRJEB3181_P_NODE_4434_length_376_cov_9.046377_g4186_i0 PRJEB3181 4434 376 9.046377 34.01437752 Viridiplantae 33090 SAR_Eukaryotes SAR_Eukaryotes 122 4.79e-31   NR KAG9404282.1 112091 g4186 i0 70.2 5.36968085106383 84 25 67 0 3 254 240 323 KAG9404282.1 Guanine nucleotide-binding protein subunit beta-2-like 1 [Aphanomyces cochlioides] diamond 2019 122 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces cochlioides
31044696 31044696 PRJEB3181_P_NODE_15035_length_217_cov_2.682796_g14771_i0 PRJEB3181 15035 217 2.682796 5.82166732 Pythium oligandrum 41045 SAR_Eukaryotes SAR_Eukaryotes 93.6 1.66e-20   NR TMW60420.1 41045 g14771 i0 77.2 27.2350230414747 57 13 78.8 0 25 195 85 141 TMW60420.1 hypothetical protein Poli38472_000462 [Pythium oligandrum] diamond 5910 93.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
31385715 31385715 PRJEB3181_P_NODE_7196_length_312_cov_4.633452_g6935_i0 PRJEB3181 7196 312 4.633452 14.45637024 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 149 4.79e-43   NR XP_024574530.1 4781 g6935 i0 96.2 155.278846153846 78 3 75 0 17 250 36 113 XP_024574530.1 ubiquitin-40s ribosomal protein s27a [Plasmopara halstedii] diamond 48447 149 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Plasmopara Plasmopara halstedii
31543822 31543822 PRJEB3181_P_NODE_15676_length_212_cov_1.850829_g15412_i0 PRJEB3181 15676 212 1.850829 3.92375748 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 54.3 2.04e-6   NR XP_024586721.1 4781 g15412 i0 80 6.04245283018868 25 5 35.4 0 1 75 471 495 XP_024586721.1 glutathione reductase [Plasmopara halstedii] diamond 1281 54.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Plasmopara Plasmopara halstedii
32113232 32113232 PRJEB3181_S_NODE_1618_length_398_cov_30.234160_g1328_i0 PRJEB3181 1618 398 30.23416 120.3319568 Viridiplantae 33090 SAR_Eukaryotes SAR_Eukaryotes 121 2.5199999999999997e-30   NR KAG9404282.1 112091 g1328 i0 70.7 3.71608040201005 82 24 61.8 0 3 248 242 323 KAG9404282.1 Guanine nucleotide-binding protein subunit beta-2-like 1 [Aphanomyces cochlioides] diamond 1479 121 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces cochlioides
32309841 32309841 PRJEB3181_P_NODE_15199_length_216_cov_1.632432_g14935_i0 PRJEB3181 15199 216 1.632432 3.52605312 Nothophytophthora sp. Chile5 2483409 SAR_Eukaryotes SAR_Eukaryotes 52.8 7.3e-6   NR RLN88511.1 2483409 g14935 i0 66.7 1.83333333333333 33 11 45.8 0 9 107 346 378 RLN88511.1 hypothetical protein BBJ28_00024215 [Nothophytophthora sp. Chile5] diamond 396 52.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Nothophytophthora Nothophytophthora sp. Chile5
32372979 32372979 PRJEB3181_P_NODE_13159_length_233_cov_3.356436_g12895_i0 PRJEB3181 13159 233 3.356436 7.82049588 Albugo laibachii Nc14 890382 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.0037   NR CCA14227.1 890382 g12895 i0 54.7 0.682403433476395 53 22 65.7 1 229 77 153 205 CCA14227.1 60S ribosomal protein L13 putative [Albugo laibachii Nc14] diamond 159 45.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii

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