contig_metadata
17 rows where bioproject = "PRJNA1186363", tax_kingdom = "Fungi" and tax_phylum = "Cryptomycota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 319786 | 319786 | PRJNA1186363_P_NODE_21361_length_405_cov_2.472892_g20473_i0 | PRJNA1186363 | 21361 | 405 | 2.472892 | 10.0152126 | Fungi | 4751 | Fungi | Fungi | 157 | 5.99e-46 | NR | RKP21274.1 | 988480 | g20473 | i0 | 73.6 | 3.9037037037037 | 106 | 26 | 78.5 | 1 | 320 | 3 | 22 | 125 | RKP21274.1 40S ribosomal protein S11 [Rozella allomycis CSF55] | diamond | 1581 | 158 | 0.993670886075949 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 4146630 | 4146630 | PRJNA1186363_P_NODE_27444_length_339_cov_2.932331_g26556_i0 | PRJNA1186363 | 27444 | 339 | 2.932331 | 9.94060209 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 150 | 8.919999999999999e-45 | NR | RKP19843.1 | 988480 | g26556 | i0 | 69.6 | 0.902654867256637 | 102 | 31 | 90.3 | 0 | 337 | 32 | 7 | 108 | RKP19843.1 40S ribosomal protein S26-like protein [Rozella allomycis CSF55] | diamond | 306 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 10523317 | 10523317 | PRJNA1186363_P_NODE_13389_length_551_cov_1.813808_g12505_i0 | PRJNA1186363 | 13389 | 551 | 1.813808 | 9.99408208 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 225 | 1.16e-72 | NR | PJF19022.1 | 1246581 | g12505 | i0 | 81.5 | 4.96007259528131 | 130 | 24 | 70.8 | 0 | 419 | 30 | 1 | 130 | PJF19022.1 40S ribosomal protein S15a-4 [Paramicrosporidium saccamoebae] | diamond | 2733 | 225 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 26597202 | 26597202 | PRJNA1186363_P_NODE_32581_length_295_cov_1.391892_g31693_i0 | PRJNA1186363 | 32581 | 295 | 1.391892 | 4.1060814 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 44.3 | 0.00887 | NR | RKP16182.1 | 988480 | g31693 | i0 | 38 | 1.3728813559322 | 50 | 31 | 50.8 | 0 | 162 | 13 | 20 | 69 | RKP16182.1 hypothetical protein ROZALSC1DRAFT_17914, partial [Rozella allomycis CSF55] | diamond | 405 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 26806597 | 26806597 | PRJNA1186363_P_NODE_23481_length_380_cov_1.097720_g22593_i0 | PRJNA1186363 | 23481 | 380 | 1.09772 | 4.171336 | Eukaryota | 2759 | Fungi | Fungi | 120 | 9.87e-31 | NR | EPZ34874.1 | 988480 | g22593 | i0 | 50.4 | 4.95 | 125 | 58 | 97.9 | 2 | 7 | 378 | 145 | 266 | EPZ34874.1 Surfeit locus 4 domain-containing protein [Rozella allomycis CSF55] | diamond | 1881 | 121 | 0.991735537190083 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 27736008 | 27736008 | PRJNA1186363_P_NODE_20984_length_410_cov_2.537092_g20096_i0 | PRJNA1186363 | 20984 | 410 | 2.537092 | 10.4020772 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 144 | 2.04e-41 | NR | PJF18950.1 | 1246581 | g20096 | i0 | 85.1 | 0.636585365853659 | 87 | 13 | 63.7 | 0 | 315 | 55 | 1 | 87 | PJF18950.1 hypothetical protein PSACC_01223 [Paramicrosporidium saccamoebae] | diamond | 261 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 29251103 | 29251103 | PRJNA1186363_P_NODE_9249_length_687_cov_1.802932_g8387_i0 | PRJNA1186363 | 9249 | 687 | 1.802932 | 12.38614284 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 186 | 3.0599999999999993e-52 | NR | EPZ36981.1 | 988480 | g8387 | i0 | 44.7 | 0.995633187772926 | 228 | 84 | 98.3 | 3 | 12 | 686 | 138 | 326 | EPZ36981.1 hypothetical protein O9G_001426 [Rozella allomycis CSF55] | diamond | 684 | 186 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 29409096 | 29409096 | PRJNA1186363_P_NODE_7869_length_751_cov_3.160767_g7050_i0 | PRJNA1186363 | 7869 | 751 | 3.160767 | 23.73736017 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 132 | 3.8e-33 | NR | PJF19047.1 | 1246581 | g7050 | i0 | 37.7 | 0.826897470039947 | 207 | 124 | 81.9 | 3 | 640 | 26 | 18 | 221 | PJF19047.1 Carbohydrate esterase family 4 protein [Paramicrosporidium saccamoebae] | diamond | 621 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 29787854 | 29787854 | PRJNA1186363_P_NODE_39131_length_252_cov_0.871508_g38243_i0 | PRJNA1186363 | 39131 | 252 | 0.871508 | 2.19620016 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 126 | 4.24e-32 | NR | PJF19871.1 | 1246581 | g38243 | i0 | 73.8 | 1 | 84 | 22 | 100 | 0 | 252 | 1 | 367 | 450 | PJF19871.1 Serine/threonine-protein phosphatase [Paramicrosporidium saccamoebae] | diamond | 252 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 30420211 | 30420211 | PRJNA1186363_P_NODE_34513_length_281_cov_1.125000_g33625_i0 | PRJNA1186363 | 34513 | 281 | 1.125 | 3.16125 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 55.5 | 3.9e-7 | NR | PJF18687.1 | 1246581 | g33625 | i0 | 41.9 | 0.790035587188612 | 74 | 33 | 79 | 2 | 59 | 280 | 1 | 64 | PJF18687.1 Hsp16-like protein [Paramicrosporidium saccamoebae] | diamond | 222 | 55.5 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 30483065 | 30483065 | PRJNA1186363_P_NODE_22473_length_391_cov_2.698113_g21585_i0 | PRJNA1186363 | 22473 | 391 | 2.698113 | 10.54962183 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 156 | 1.44e-45 | NR | EPZ37075.1 | 988480 | g21585 | i0 | 63.2 | 5.76214833759591 | 125 | 45 | 95.9 | 1 | 375 | 1 | 1 | 124 | EPZ37075.1 60S ribosomal protein L18-2 [Rozella allomycis CSF55] | diamond | 2253 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 30577615 | 30577615 | PRJNA1186363_P_NODE_42553_length_244_cov_1.766082_g41665_i0 | PRJNA1186363 | 42553 | 244 | 1.766082 | 4.30924008 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 92 | 1.2e-21 | NR | EPZ33911.1 | 988480 | g41665 | i0 | 53.8 | 0.959016393442623 | 78 | 36 | 95.9 | 0 | 238 | 5 | 1 | 78 | EPZ33911.1 40S ribosomal protein S12 [Rozella allomycis CSF55] | diamond | 234 | 92 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 30988700 | 30988700 | PRJNA1186363_P_NODE_35434_length_274_cov_0.995025_g34546_i0 | PRJNA1186363 | 35434 | 274 | 0.995025 | 2.7263685 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 60.1 | 4.48e-8 | NR | PJF17134.1 | 1246581 | g34546 | i0 | 38.2 | 0.974452554744526 | 89 | 44 | 85.4 | 1 | 28 | 261 | 291 | 379 | PJF17134.1 DNA-directed RNA polymerase subunit [Paramicrosporidium saccamoebae] | diamond | 267 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 31083418 | 31083418 | PRJNA1186363_P_NODE_39755_length_250_cov_1.259887_g38867_i0 | PRJNA1186363 | 39755 | 250 | 1.259887 | 3.1497175 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 102 | 3.08e-23 | NR | PJF19372.1 | 1246581 | g38867 | i0 | 53.7 | 0.984 | 82 | 38 | 98.4 | 0 | 3 | 248 | 209 | 290 | PJF19372.1 hypothetical protein PSACC_00787 [Paramicrosporidium saccamoebae] | diamond | 246 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 31905578 | 31905578 | PRJNA1186363_P_NODE_42557_length_244_cov_1.666667_g41669_i0 | PRJNA1186363 | 42557 | 244 | 1.666667 | 4.06666748 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 74.7 | 1.04e-14 | NR | PJF19310.1 | 1246581 | g41669 | i0 | 55.6 | 0.995901639344262 | 81 | 24 | 99.6 | 1 | 2 | 244 | 53 | 121 | PJF19310.1 hypothetical protein PSACC_00806 [Paramicrosporidium saccamoebae] | diamond | 243 | 74.7 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 32000496 | 32000496 | PRJNA1186363_P_NODE_21138_length_408_cov_1.758209_g20250_i0 | PRJNA1186363 | 21138 | 408 | 1.758209 | 7.17349272 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 76.3 | 1.79e-14 | NR | PJF19039.1 | 1246581 | g20250 | i0 | 36 | 0.919117647058823 | 125 | 61 | 91.9 | 2 | 379 | 5 | 1 | 106 | PJF19039.1 hypothetical protein PSACC_01145 [Paramicrosporidium saccamoebae] | diamond | 375 | 76.3 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 32222001 | 32222001 | PRJNA1186363_P_NODE_15898_length_492_cov_1.804296_g15012_i0 | PRJNA1186363 | 15898 | 492 | 1.804296 | 8.87713632 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 58.2 | 4.66e-7 | NR | EPZ31257.1 | 988480 | g15012 | i0 | 31.1 | 0.725609756097561 | 119 | 70 | 72 | 3 | 138 | 491 | 27 | 134 | EPZ31257.1 UspA domain-containing protein [Rozella allomycis CSF55] | diamond | 357 | 58.2 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis |
Advanced export
JSON shape: default, array, newline-delimited
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);;