contig_metadata
12 rows where bioproject = "PRJNA756891", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4560464 | 4560464 | PRJNA756891_P_NODE_904_length_840_cov_20.222947_g848_i0 | PRJNA756891 | 904 | 840 | 20.222947 | 169.8727548 | Eukaryota | 2759 | Fungi | Fungi | 419 | 6.989999999999998e-146 | NR | EPZ33659.1 | 988480 | g848 | i0 | 78 | 29.0678571428571 | 250 | 55 | 89.3 | 0 | 831 | 82 | 1 | 250 | EPZ33659.1 60S ribosomal protein L8 [Rozella allomycis CSF55] | diamond | 24417 | 421 | 0.995249406175772 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 19859082 | 19859082 | PRJNA756891_P_NODE_876_length_855_cov_19.783887_g820_i0 | PRJNA756891 | 876 | 855 | 19.783887 | 169.15223385 | Eukaryota | 2759 | Fungi | Fungi | 419 | 8.51e-146 | NR | EPZ33659.1 | 988480 | g820 | i0 | 78 | 28.5754385964912 | 250 | 55 | 87.7 | 0 | 10 | 759 | 1 | 250 | EPZ33659.1 60S ribosomal protein L8 [Rozella allomycis CSF55] | diamond | 24432 | 421 | 0.995249406175772 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 22409438 | 22409438 | PRJNA756891_P_NODE_9918_length_277_cov_1.509804_g9849_i0 | PRJNA756891 | 9918 | 277 | 1.509804 | 4.18215708 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 137 | 3.909999999999999e-37 | NR | PJF19672.1 | 1246581 | g9849 | i0 | 67 | 0.985559566787004 | 91 | 30 | 98.6 | 0 | 3 | 275 | 150 | 240 | PJF19672.1 Arginase [Paramicrosporidium saccamoebae] | diamond | 273 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 23685048 | 23685048 | PRJNA756891_P_NODE_6319_length_340_cov_1.149813_g6250_i0 | PRJNA756891 | 6319 | 340 | 1.149813 | 3.9093642 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 165 | 9.74e-45 | NR | PJF19132.1 | 1246581 | g6250 | i0 | 68.1 | 0.997058823529412 | 113 | 36 | 99.7 | 0 | 1 | 339 | 74 | 186 | PJF19132.1 Double Clp-N motif domain-containing protein [Paramicrosporidium saccamoebae] | diamond | 339 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 26768096 | 26768096 | PRJNA756891_P_NODE_2121_length_570_cov_2.225352_g2053_i0 | PRJNA756891 | 2121 | 570 | 2.225352 | 12.6845064 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 104 | 3.69e-22 | NR | EPZ33023.1 | 988480 | g2053 | i0 | 53.7 | 0.994736842105263 | 95 | 43 | 49.5 | 1 | 284 | 3 | 165 | 259 | EPZ33023.1 Sas10 domain-containing protein [Rozella allomycis CSF55] | diamond | 567 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 27179172 | 27179172 | PRJNA756891_P_NODE_2882_length_493_cov_1.521429_g2814_i0 | PRJNA756891 | 2882 | 493 | 1.521429 | 7.50064497 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 219 | 3.27e-63 | NR | PJF19132.1 | 1246581 | g2814 | i0 | 66.7 | 0.98580121703854 | 162 | 52 | 98.6 | 1 | 3 | 488 | 712 | 871 | PJF19132.1 Double Clp-N motif domain-containing protein [Paramicrosporidium saccamoebae] | diamond | 486 | 219 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 27716703 | 27716703 | PRJNA756891_P_NODE_13224_length_248_cov_1.760000_g13155_i0 | PRJNA756891 | 13224 | 248 | 1.76 | 4.3648 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 48.9 | 2.7e-4 | NR | PJF18389.1 | 1246581 | g13155 | i0 | 32.9 | 0.991935483870968 | 82 | 49 | 91.9 | 2 | 247 | 20 | 644 | 725 | PJF18389.1 hypothetical protein PSACC_01801 [Paramicrosporidium saccamoebae] | diamond | 246 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 27716714 | 27716714 | PRJNA756891_P_NODE_7204_length_321_cov_1.322581_g7135_i0 | PRJNA756891 | 7204 | 321 | 1.322581 | 4.24548501 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 62.8 | 8.91e-9 | NR | PJF19024.1 | 1246581 | g7135 | i0 | 42.4 | 0.551401869158878 | 59 | 34 | 55.1 | 0 | 52 | 228 | 434 | 492 | PJF19024.1 DUF563 domain-containing protein [Paramicrosporidium saccamoebae] | diamond | 177 | 62.8 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 28379345 | 28379345 | PRJNA756891_P_NODE_11746_length_255_cov_1.219780_g11677_i0 | PRJNA756891 | 11746 | 255 | 1.21978 | 3.110439 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 92.4 | 8.12e-20 | NR | RKP20301.1 | 988480 | g11677 | i0 | 54.7 | 1.76470588235294 | 75 | 33 | 88.2 | 1 | 30 | 254 | 185 | 258 | RKP20301.1 SPRY-domain-containing protein, partial [Rozella allomycis CSF55] | diamond | 450 | 92.4 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 29399550 | 29399550 | PRJNA756891_P_NODE_2509_length_526_cov_2.209713_g2441_i0 | PRJNA756891 | 2509 | 526 | 2.209713 | 11.62309038 | Eukaryota | 2759 | Fungi | Fungi | 251 | 6.12e-82 | NR | EPZ36545.1 | 988480 | g2441 | i0 | 74.7 | 19.8650190114068 | 162 | 40 | 91.8 | 1 | 494 | 12 | 6 | 167 | EPZ36545.1 Septum-promoting GTP-binding protein 1 [Rozella allomycis CSF55] | diamond | 10449 | 253 | 0.992094861660079 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 29588690 | 29588690 | PRJNA756891_P_NODE_10090_length_275_cov_1.212871_g10021_i0 | PRJNA756891 | 10090 | 275 | 1.212871 | 3.33539525 | Fungi | 4751 | Fungi | Fungi | 53.5 | 7.68e-6 | NR | EPZ36333.1 | 988480 | g10021 | i0 | 68.8 | 4.56 | 32 | 10 | 34.9 | 0 | 82 | 177 | 276 | 307 | EPZ36333.1 Serine/threonine-protein phosphatase PP2A catalytic subunit [Rozella allomycis CSF55] | diamond | 1254 | 53.9 | 0.992578849721707 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 31126803 | 31126803 | PRJNA756891_P_NODE_14775_length_245_cov_0.895349_g14706_i0 | PRJNA756891 | 14775 | 245 | 0.895349 | 2.19360505 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 53.9 | 4.14e-6 | NR | PJF19672.1 | 1246581 | g14706 | i0 | 45.9 | 0.746938775510204 | 61 | 31 | 74.7 | 2 | 190 | 8 | 29 | 87 | PJF19672.1 Arginase [Paramicrosporidium saccamoebae] | diamond | 183 | 53.9 | 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);;