RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA1103784" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 19 ✖

tax_clade 1

bioproject 1

  • PRJNA1103784 · 19 ✖

analysis 1

  • diamond · 19 ✖

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
1486791 1486791 PRJNA1103784_P_NODE_2742_length_326_cov_1.893281_g2687_i0 PRJNA1103784 2742 326 1.893281 6.17209606 Aphanomyces stellatus 120398 SAR_Eukaryotes SAR_Eukaryotes 194 1.1e-57   NR KAF0685004.1 120398 g2687 i0 94.1 2.76993865030675 101 6 92.9 0 3 305 378 478 KAF0685004.1 hypothetical protein As57867_022962 [Aphanomyces stellatus] diamond 903 194 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
1486811 1486811 PRJNA1103784_P_NODE_3922_length_284_cov_1.592417_g3867_i0 PRJNA1103784 3922 284 1.592417 4.52246428 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 99.4 3.42e-22   NR CAI5723418.1 162125 g3867 i0 83.6 2.29225352112676 55 9 58.1 0 284 120 352 406 CAI5723418.1 unnamed protein product [Hyaloperonospora brassicae] diamond 651 100 0.994 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Hyaloperonospora Hyaloperonospora brassicae
1486872 1486872 PRJNA1103784_P_NODE_7542_length_242_cov_0.911243_g7487_i0 PRJNA1103784 7542 242 0.911243 2.20520806 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 145 3.8399999999999997e-38   NR KAH9112904.1 100861 g7487 i0 86.8 6.60743801652893 76 10 94.2 0 242 15 1454 1529 KAH9112904.1 hypothetical protein AeMF1_012834 [Aphanomyces euteiches] diamond 1599 146 0.993150684931507 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
2762872 2762872 PRJNA1103784_P_NODE_6263_length_248_cov_0.880000_g6208_i0 PRJNA1103784 6263 248 0.88 2.1824 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 85.1 1.69e-18   NR TMW64003.1 41045 g6208 i0 61.7 2.95161290322581 81 24 96.8 2 247 8 71 145 TMW64003.1 hypothetical protein Poli38472_014708 [Pythium oligandrum] diamond 732 85.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
4038924 4038924 PRJNA1103784_P_NODE_6004_length_249_cov_1.386364_g5949_i0 PRJNA1103784 6004 249 1.386364 3.45204636 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 158 1.16e-44   NR XP_009839950.1 112090 g5949 i0 95.2 4 83 4 100 0 1 249 320 402 XP_009839950.1 hypothetical protein H257_13946 [Aphanomyces astaci] diamond 996 159 0.993710691823899 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
9139703 9139703 PRJNA1103784_P_NODE_2048_length_368_cov_1.044068_g1993_i0 PRJNA1103784 2048 368 1.044068 3.84217024 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 203 2.78e-62   NR KAF0740755.1 100861 g1993 i0 95.1 0.839673913043478 103 5 84 0 366 58 232 334 KAF0740755.1 hypothetical protein Ae201684_003886 [Aphanomyces euteiches] diamond 309 203 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
9139744 9139744 PRJNA1103784_P_NODE_4828_length_266_cov_1.316062_g4773_i0 PRJNA1103784 4828 266 1.316062 3.50072492 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 161 1.09e-48   NR KAF0749215.1 112090 g4773 i0 96.3 1.81578947368421 82 3 92.5 0 21 266 1 82 KAF0749215.1 hypothetical protein AaE_007106 [Aphanomyces astaci] diamond 483 161 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
19337956 19337956 PRJNA1103784_P_NODE_5476_length_253_cov_2.111111_g5421_i0 PRJNA1103784 5476 253 2.111111 5.34111083 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 132 1.02e-36   NR KAH9123902.1 100861 g5421 i0 76.8 3.90118577075099 82 19 97.2 0 7 252 35 116 KAH9123902.1 hypothetical protein AeMF1_005244, partial [Aphanomyces euteiches] diamond 987 132 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
27541707 27541707 PRJNA1103784_P_NODE_6404_length_247_cov_1.758621_g6349_i0 PRJNA1103784 6404 247 1.758621 4.34379387 Achlya hypogyna 1202772 SAR_Eukaryotes SAR_Eukaryotes 129 1.05e-34   NR OQR89863.1 1202772 g6349 i0 87.8 3.98380566801619 82 10 99.6 0 247 2 77 158 OQR89863.1 3-hydroxyisobutyrate dehydrogenase [Achlya hypogyna] diamond 984 129 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya hypogyna
28930979 28930979 PRJNA1103784_P_NODE_4748_length_267_cov_1.489691_g4693_i0 PRJNA1103784 4748 267 1.489691 3.97747497 Aphanomyces stellatus 120398 SAR_Eukaryotes SAR_Eukaryotes 102 2.32e-25   NR KAF0696683.1 120398 g4693 i0 70.8 1.84269662921348 65 19 73 0 3 197 49 113 KAF0696683.1 hypothetical protein As57867_012532 [Aphanomyces stellatus] diamond 492 102 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
29372970 29372970 PRJNA1103784_P_NODE_6969_length_245_cov_0.895349_g6914_i0 PRJNA1103784 6969 245 0.895349 2.19360505 Aphanomyces cochlioides 112091 SAR_Eukaryotes SAR_Eukaryotes 145 5.23e-40   NR KAG9413300.1 112091 g6914 i0 87.7 0.991836734693878 81 10 99.2 0 245 3 21 101 KAG9413300.1 hypothetical protein AC1031_012513 [Aphanomyces cochlioides] diamond 243 145 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces cochlioides
29656699 29656699 PRJNA1103784_P_NODE_6110_length_249_cov_0.875000_g6055_i0 PRJNA1103784 6110 249 0.875 2.17875 Aphanomyces cochlioides 112091 SAR_Eukaryotes SAR_Eukaryotes 142 2.97e-38   NR KAG9415159.1 112091 g6055 i0 84.6 0.939759036144578 78 12 94 0 1 234 225 302 KAG9415159.1 hypothetical protein AC1031_008585 [Aphanomyces cochlioides] diamond 234 142 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces cochlioides
30036137 30036137 PRJNA1103784_P_NODE_2691_length_329_cov_1.203125_g2636_i0 PRJNA1103784 2691 329 1.203125 3.95828125 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 114 2.16e-30   NR KAF0741110.1 100861 g2636 i0 98.1 0.474164133738602 52 1 47.4 0 308 153 1 52 KAF0741110.1 hypothetical protein Ae201684_003678 [Aphanomyces euteiches] diamond 156 114 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
30572961 30572961 PRJNA1103784_P_NODE_5913_length_250_cov_0.870056_g5858_i0 PRJNA1103784 5913 250 0.870056 2.17514 Aphanomyces stellatus 120398 SAR_Eukaryotes SAR_Eukaryotes 105 3.15e-24   NR KAF0717085.1 120398 g5858 i0 65 1.908 80 22 93.6 2 2 235 415 490 KAF0717085.1 hypothetical protein As57867_002497 [Aphanomyces stellatus] diamond 477 105 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
31015547 31015547 PRJNA1103784_P_NODE_6715_length_246_cov_0.890173_g6660_i0 PRJNA1103784 6715 246 0.890173 2.18982558 Aphanomyces stellatus 120398 SAR_Eukaryotes SAR_Eukaryotes 71.2 4.79e-13   NR KAF0685047.1 120398 g6660 i0 100 0.378048780487805 31 0 37.8 0 244 152 121 151 KAF0685047.1 hypothetical protein As57867_023005 [Aphanomyces stellatus] diamond 93 71.2 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
31742698 31742698 PRJNA1103784_P_NODE_1877_length_381_cov_1.590909_g1822_i0 PRJNA1103784 1877 381 1.590909 6.06136329 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 186 2.13e-56   NR KAF0742167.1 100861 g1822 i0 69.8 0.992125984251969 126 38 99.2 0 380 3 31 156 KAF0742167.1 hypothetical protein Ae201684_002835 [Aphanomyces euteiches] diamond 378 186 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
31797168 31797168 PRJNA1103784_P_NODE_7397_length_243_cov_0.905882_g7342_i0 PRJNA1103784 7397 243 0.905882 2.20129326 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 80.5 1.82e-15   NR KAH9143027.1 100861 g7342 i0 69.4 2.33333333333333 49 13 58 1 197 57 473 521 KAH9143027.1 hypothetical protein AeRB84_012936 [Aphanomyces euteiches] diamond 567 80.9 0.995055624227441 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
32113868 32113868 PRJNA1103784_P_NODE_5838_length_250_cov_0.870056_g5783_i0 PRJNA1103784 5838 250 0.870056 2.17514 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 121 3.4499999999999998e-31   NR KAH9123724.1 100861 g5783 i0 68.7 8.952 83 26 99.6 0 250 2 209 291 KAH9123724.1 hypothetical protein AeMF1_005377 [Aphanomyces euteiches] diamond 2238 121 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
32588464 32588464 PRJNA1103784_P_NODE_5779_length_250_cov_1.740113_g5724_i0 PRJNA1103784 5779 250 1.740113 4.3502825 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 167 4.799999999999999e-46   NR KAH9107486.1 100861 g5724 i0 96.4 12.948 83 3 99.6 0 249 1 273 355 KAH9107486.1 hypothetical protein AeMF1_017177 [Aphanomyces euteiches] diamond 3237 167 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches

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