contig_metadata
16 rows where bioproject = "PRJNA1002570" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 152604 | 152604 | PRJNA1002570_P_NODE_43701_length_241_cov_1.833333_g43506_i0 | PRJNA1002570 | 43701 | 241 | 1.833333 | 4.41833253 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 115 | 4.58e-29 | NR | PJF16681.1 | 1246581 | g43506 | i0 | 90.7 | 0.672199170124481 | 54 | 5 | 67.2 | 0 | 164 | 3 | 1 | 54 | PJF16681.1 hypothetical protein PSACC_03418, partial [Paramicrosporidium saccamoebae] | diamond | 162 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 26805391 | 26805391 | PRJNA1002570_P_NODE_22941_length_284_cov_1.459716_g22746_i0 | PRJNA1002570 | 22941 | 284 | 1.459716 | 4.14559344 | Fungi | 4751 | Fungi | Fungi | 47.8 | 6.64e-4 | NR | PJF16640.1 | 1246581 | g22746 | i0 | 62.9 | 1.10915492957746 | 35 | 13 | 37 | 0 | 93 | 197 | 28 | 62 | PJF16640.1 hypothetical protein PSACC_03553 [Paramicrosporidium saccamoebae] | diamond | 315 | 48.1 | 0.993762993762994 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 27382178 | 27382178 | PRJNA1002570_P_NODE_13323_length_329_cov_1.617188_g13128_i0 | PRJNA1002570 | 13323 | 329 | 1.617188 | 5.32054852 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 155 | 1.59e-41 | NR | PJF17398.1 | 1246581 | g13128 | i0 | 69.7 | 0.993920972644377 | 109 | 33 | 99.4 | 0 | 328 | 2 | 423 | 531 | PJF17398.1 ABC-2 type transporter domain-containing protein [Paramicrosporidium saccamoebae] | diamond | 327 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 27445564 | 27445564 | PRJNA1002570_P_NODE_46103_length_197_cov_4.685484_g45908_i0 | PRJNA1002570 | 46103 | 197 | 4.685484 | 9.23040348 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 102 | 5.8e-26 | NR | PJF16509.1 | 1246581 | g45908 | i0 | 71.9 | 0.974619289340102 | 64 | 18 | 97.5 | 0 | 193 | 2 | 50 | 113 | PJF16509.1 hypothetical protein PSACC_03696 [Paramicrosporidium saccamoebae] | diamond | 192 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 27666436 | 27666436 | PRJNA1002570_P_NODE_22124_length_286_cov_1.305164_g21929_i0 | PRJNA1002570 | 22124 | 286 | 1.305164 | 3.73276904 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 120 | 1.89e-29 | NR | PJF16729.1 | 1246581 | g21929 | i0 | 62.8 | 0.986013986013986 | 94 | 35 | 98.6 | 0 | 286 | 5 | 147 | 240 | PJF16729.1 putative heat shock protein hsp88 [Paramicrosporidium saccamoebae] | diamond | 282 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 27792674 | 27792674 | PRJNA1002570_P_NODE_20064_length_290_cov_1.493088_g19869_i0 | PRJNA1002570 | 20064 | 290 | 1.493088 | 4.3299552 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 84 | 1.86e-16 | NR | PJF18026.1 | 1246581 | g19869 | i0 | 61 | 0.796551724137931 | 77 | 21 | 79.7 | 3 | 5 | 235 | 110 | 177 | PJF18026.1 hypothetical protein PSACC_02169 [Paramicrosporidium saccamoebae] | diamond | 231 | 84 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 28897507 | 28897507 | PRJNA1002570_P_NODE_16208_length_310_cov_2.459916_g16013_i0 | PRJNA1002570 | 16208 | 310 | 2.459916 | 7.6257396 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 103 | 3.71e-23 | NR | PJF17986.1 | 1246581 | g16013 | i0 | 57.3 | 0.929032258064516 | 96 | 33 | 85.2 | 1 | 308 | 45 | 69 | 164 | PJF17986.1 T-complex protein 1 subunit gamma [Paramicrosporidium saccamoebae] | diamond | 288 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 29213632 | 29213632 | PRJNA1002570_P_NODE_36469_length_250_cov_2.310734_g36274_i0 | PRJNA1002570 | 36469 | 250 | 2.310734 | 5.776835 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 68.6 | 3.28e-11 | NR | PJF19360.1 | 1246581 | g36274 | i0 | 52.2 | 0.804 | 67 | 24 | 80.4 | 2 | 224 | 24 | 3 | 61 | PJF19360.1 hypothetical protein PSACC_00875 [Paramicrosporidium saccamoebae] | diamond | 201 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 30128885 | 30128885 | PRJNA1002570_P_NODE_32972_length_259_cov_1.897849_g32777_i0 | PRJNA1002570 | 32972 | 259 | 1.897849 | 4.91542891 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 70.1 | 3.48e-12 | NR | PJF17315.1 | 1246581 | g32777 | i0 | 71.8 | 0.451737451737452 | 39 | 11 | 45.2 | 0 | 150 | 34 | 200 | 238 | PJF17315.1 Proteasome subunit beta type, partial [Paramicrosporidium saccamoebae] | diamond | 117 | 70.1 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 30792638 | 30792638 | PRJNA1002570_P_NODE_18934_length_294_cov_2.968326_g18739_i0 | PRJNA1002570 | 18934 | 294 | 2.968326 | 8.72687844 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 150 | 1.38e-39 | NR | PJF18373.1 | 1246581 | g18739 | i0 | 76.6 | 0.959183673469388 | 94 | 22 | 95.9 | 0 | 292 | 11 | 160 | 253 | PJF18373.1 hypothetical protein PSACC_01795 [Paramicrosporidium saccamoebae] | diamond | 282 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 32057508 | 32057508 | PRJNA1002570_P_NODE_45478_length_230_cov_2.292994_g45283_i0 | PRJNA1002570 | 45478 | 230 | 2.292994 | 5.2738862 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 67.4 | 4.6e-11 | NR | PJF19032.1 | 1246581 | g45283 | i0 | 46.4 | 0.9 | 69 | 24 | 90 | 1 | 229 | 23 | 255 | 310 | PJF19032.1 Mitochondrial ribosomal protein L3 [Paramicrosporidium saccamoebae] | diamond | 207 | 67.4 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 32089115 | 32089115 | PRJNA1002570_P_NODE_15318_length_310_cov_3.569620_g15123_i0 | PRJNA1002570 | 15318 | 310 | 3.56962 | 11.065822 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 94 | 7.58e-20 | NR | PJF19131.1 | 1246581 | g15123 | i0 | 48.5 | 0.996774193548387 | 103 | 27 | 98.7 | 3 | 4 | 309 | 158 | 235 | PJF19131.1 Kinesin-like protein [Paramicrosporidium saccamoebae] | diamond | 309 | 94 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 32120958 | 32120958 | PRJNA1002570_P_NODE_33878_length_256_cov_3.448087_g33683_i0 | PRJNA1002570 | 33878 | 256 | 3.448087 | 8.82710272 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 52.8 | 1.25e-5 | NR | PJF18725.1 | 1246581 | g33683 | i0 | 39.7 | 0.9140625 | 78 | 46 | 91.4 | 1 | 9 | 242 | 546 | 622 | PJF18725.1 Glycerol-3-phosphate o-acyltransferase [Paramicrosporidium saccamoebae] | diamond | 234 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 32595382 | 32595382 | PRJNA1002570_P_NODE_30860_length_265_cov_1.588542_g30665_i0 | PRJNA1002570 | 30860 | 265 | 1.588542 | 4.2096363 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 127 | 4.41e-32 | NR | PJF16656.1 | 1246581 | g30665 | i0 | 79.2 | 2.61509433962264 | 77 | 16 | 87.2 | 0 | 264 | 34 | 445 | 521 | PJF16656.1 UTP--glucose-1-phosphate uridylyltransferase domain-containing protein, partial [Paramicrosporidium saccamoebae] | diamond | 693 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 32721245 | 32721245 | PRJNA1002570_P_NODE_35980_length_251_cov_0.865169_g35785_i0 | PRJNA1002570 | 35980 | 251 | 0.865169 | 2.17157419 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 57 | 4.01e-7 | NR | PJF19689.1 | 1246581 | g35785 | i0 | 36.1 | 0.860557768924303 | 72 | 46 | 86.1 | 0 | 221 | 6 | 1453 | 1524 | PJF19689.1 hypothetical protein PSACC_00496 [Paramicrosporidium saccamoebae] | diamond | 216 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 32878589 | 32878589 | PRJNA1002570_P_NODE_21460_length_287_cov_1.943925_g21265_i0 | PRJNA1002570 | 21460 | 287 | 1.943925 | 5.57906475 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 52 | 3.63e-5 | NR | PJF20080.1 | 1246581 | g21265 | i0 | 32.2 | 0.909407665505226 | 87 | 57 | 90.9 | 2 | 284 | 24 | 1240 | 1324 | PJF20080.1 hypothetical protein PSACC_00104 [Paramicrosporidium saccamoebae] | diamond | 261 | 52 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae |
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);;