RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJEB58983" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 12 ✖

tax_clade 1

bioproject 1

  • PRJEB58983 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
11603692 11603692 PRJEB58983_P_NODE_8110_length_435_cov_2.127072_g7696_i0 PRJEB58983 8110 435 2.127072 9.2527632 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 171 3.31e-51   NR KAJ0392104.1 114742 g7696 i0 64.1 4.40689655172414 128 46 88.3 0 2 385 48 175 KAJ0392104.1 hypothetical protein P43SY_009801 [Pythium insidiosum] diamond 1917 171 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
12878272 12878272 PRJEB58983_P_NODE_13171_length_349_cov_1.413043_g12756_i0 PRJEB58983 13171 349 1.413043 4.93152007 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 149 4.8899999999999997e-39   NR KUF88495.1 4792 g12756 i0 66.7 19.7449856733524 111 37 95.4 0 348 16 543 653 KUF88495.1 3-ketoacyl-CoA thiolase A [Phytophthora nicotianae] diamond 6891 150 0.993333333333333 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
20525694 20525694 PRJEB58983_P_NODE_16817_length_313_cov_2.220833_g16402_i0 PRJEB58983 16817 313 2.220833 6.95120729 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 172 3.98e-50   NR TMW60420.1 41045 g16402 i0 76.7 4.95527156549521 103 24 98.7 0 4 312 169 271 TMW60420.1 hypothetical protein Poli38472_000462 [Pythium oligandrum] diamond 1551 172 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
27406320 27406320 PRJEB58983_P_NODE_6423_length_486_cov_3.186441_g6009_i0 PRJEB58983 6423 486 3.186441 15.48610326 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 106 1.96e-25   NR KAK1947371.1 4793 g6009 i0 42 7.25308641975309 157 84 94.4 2 477 19 32 185 KAK1947371.1 60S ribosomal protein L23a [Phytophthora citrophthora] diamond 3525 107 0.990654205607477 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora citrophthora
28801910 28801910 PRJEB58983_P_NODE_9628_length_402_cov_2.142857_g9214_i0 PRJEB58983 9628 402 2.142857 8.61428514 Phytophthora ramorum 164328 SAR_Eukaryotes SAR_Eukaryotes 75.9 5.87e-13   NR XP_067737212.1 164328 g9214 i0 56.7 4.02985074626866 60 26 44.8 0 401 222 1203 1262 XP_067737212.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94 [Phytophthora ramorum] diamond 1620 75.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum
29552879 29552879 PRJEB58983_P_NODE_22670_length_276_cov_1.458128_g22255_i0 PRJEB58983 22670 276 1.458128 4.02443328 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 90.9 4.6e-19   NR KAG1686551.1 4784 g22255 i0 49.4 14.5217391304348 89 40 96.7 2 267 1 309 392 KAG1686551.1 hypothetical protein DVH05_006453 [Phytophthora capsici] diamond 4008 91.7 0.991275899672846 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
29900599 29900599 PRJEB58983_P_NODE_33071_length_238_cov_2.339394_g32656_i0 PRJEB58983 33071 238 2.339394 5.56775772 root 1 Root_unresolved Root_unresolved 45.8 0.0029   NR KAH9157343.1 100861 g32656 i0 40 5.77310924369748 65 36 81.9 1 200 6 1953 2014 KAH9157343.1 hypothetical protein AeRB84_000815 [Aphanomyces euteiches] diamond 1374 45.8 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
30121467 30121467 PRJEB58983_P_NODE_3132_length_698_cov_2.267200_g2740_i0 PRJEB58983 3132 698 2.2672 15.825056 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 138 5.19e-36   NR KAJ8578052.1 4785 g2740 i0 62.8 2.39828080229226 113 38 46.8 1 74 400 116 228 KAJ8578052.1 hypothetical protein ON010_g1153 [Phytophthora cinnamomi] diamond 1674 138 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
30286777 30286777 PRJEB58983_P_NODE_20352_length_288_cov_1.460465_g19937_i0 PRJEB58983 20352 288 1.460465 4.2061392 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 146 2.16e-38   NR GLD96693.1 114742 g19937 i0 78.1 4 96 21 100 0 288 1 84 179 GLD96693.1 hypothetical protein PINS_up005376 [Pythium insidiosum] diamond 1152 146 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
31006253 31006253 PRJEB58983_P_NODE_24334_length_268_cov_1.594872_g23919_i0 PRJEB58983 24334 268 1.594872 4.27425696 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 49.7 1.85e-4   NR KAF0727981.1 100861 g23919 i0 46.7 3.91791044776119 45 24 50.4 0 264 130 417 461 KAF0727981.1 hypothetical protein Ae201684_014090 [Aphanomyces euteiches] diamond 1050 49.7 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
31265922 31265922 PRJEB58983_P_NODE_29855_length_248_cov_0.891429_g29440_i0 PRJEB58983 29855 248 0.891429 2.21074392 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 102 5.209999999999999e-23   NR KAJ0412271.1 114742 g29440 i0 66.7 7.37903225806452 75 25 90.7 0 229 5 292 366 KAJ0412271.1 hypothetical protein ATCC90586_006657 [Pythium insidiosum] diamond 1830 102 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
31613806 31613806 PRJEB58983_P_NODE_34316_length_229_cov_3.397436_g33901_i0 PRJEB58983 34316 229 3.397436 7.78012844 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 50.1 7.65e-5   NR GLD92577.1 114742 g33901 i0 35.2 0.930131004366812 71 45 93 1 1 213 195 264 GLD92577.1 hypothetical protein PINS_up001136 [Pythium insidiosum] diamond 213 50.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum

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