contig_metadata
14 rows where bioproject = "PRJNA682774", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10868633 | 10868633 | PRJNA682774_P_NODE_2229_length_304_cov_1.012987_g2200_i0 | PRJNA682774 | 2229 | 304 | 1.012987 | 3.07948048 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 152 | 2.71e-44 | NR | PJF19243.1 | 1246581 | g2200 | i0 | 72.3 | 0.996710526315789 | 101 | 28 | 99.7 | 0 | 1 | 303 | 95 | 195 | PJF19243.1 Elongation factor 1-beta [Paramicrosporidium saccamoebae] | diamond | 303 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 13418597 | 13418597 | PRJNA682774_P_NODE_1671_length_344_cov_1.136531_g1642_i0 | PRJNA682774 | 1671 | 344 | 1.136531 | 3.90966664 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 161 | 1.4499999999999998e-47 | NR | PJF16710.1 | 1246581 | g1642 | i0 | 68.1 | 1.01162790697674 | 116 | 34 | 98.5 | 1 | 342 | 4 | 26 | 141 | PJF16710.1 Protein arginine n-methyltransferase [Paramicrosporidium saccamoebae] | diamond | 348 | 161 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 27430043 | 27430043 | PRJNA682774_P_NODE_703_length_515_cov_3.699095_g674_i0 | PRJNA682774 | 703 | 515 | 3.699095 | 19.05033925 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 104 | 1.53e-23 | NR | PJF18108.1 | 1246581 | g674 | i0 | 33.7 | 1.10679611650485 | 190 | 89 | 90.3 | 3 | 49 | 513 | 5 | 192 | PJF18108.1 hypothetical protein PSACC_02076 [Paramicrosporidium saccamoebae] | diamond | 570 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 27524498 | 27524498 | PRJNA682774_P_NODE_3423_length_253_cov_0.866667_g3394_i0 | PRJNA682774 | 3423 | 253 | 0.866667 | 2.19266751 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 75.9 | 9.21e-14 | NR | PJF18635.1 | 1246581 | g3394 | i0 | 47.5 | 1.17391304347826 | 99 | 37 | 99.6 | 3 | 253 | 2 | 419 | 517 | PJF18635.1 Rad4-domain-containing protein [Paramicrosporidium saccamoebae] | diamond | 297 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 27714367 | 27714367 | PRJNA682774_P_NODE_704_length_515_cov_2.461538_g675_i0 | PRJNA682774 | 704 | 515 | 2.461538 | 12.6769207 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 74.7 | 7.34e-13 | NR | PJF19918.1 | 1246581 | g675 | i0 | 37.9 | 0.6 | 103 | 61 | 58.8 | 2 | 447 | 145 | 21 | 122 | PJF19918.1 hypothetical protein PSACC_00269 [Paramicrosporidium saccamoebae] | diamond | 309 | 74.7 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 27978123 | 27978123 | PRJNA682774_P_NODE_1725_length_339_cov_1.169173_g1696_i0 | PRJNA682774 | 1725 | 339 | 1.169173 | 3.96349647 | root | 1 | Root_unresolved | Root_unresolved | 93.6 | 1.72e-19 | NR | PJF16745.1 | 1246581 | g1696 | i0 | 45.9 | 1.91150442477876 | 109 | 55 | 93.8 | 2 | 338 | 21 | 964 | 1071 | PJF16745.1 hypothetical protein PSACC_03453 [Paramicrosporidium saccamoebae] | diamond | 648 | 94.4 | 0.991525423728813 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 28156170 | 28156170 | PRJNA682774_P_NODE_2485_length_290_cov_2.046083_g2456_i0 | PRJNA682774 | 2485 | 290 | 2.046083 | 5.9336407 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 47 | 0.00106 | NR | PJF19389.1 | 1246581 | g2456 | i0 | 41.1 | 0.579310344827586 | 56 | 33 | 57.9 | 0 | 30 | 197 | 98 | 153 | PJF19389.1 hypothetical protein PSACC_00797 [Paramicrosporidium saccamoebae] | diamond | 168 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 28250559 | 28250559 | PRJNA682774_P_NODE_3146_length_262_cov_1.513228_g3117_i0 | PRJNA682774 | 3146 | 262 | 1.513228 | 3.96465736 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 87.8 | 1.44e-18 | NR | PJF18108.1 | 1246581 | g3117 | i0 | 44.2 | 0.984732824427481 | 86 | 48 | 98.5 | 0 | 260 | 3 | 154 | 239 | PJF18108.1 hypothetical protein PSACC_02076 [Paramicrosporidium saccamoebae] | diamond | 258 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 29198089 | 29198089 | PRJNA682774_P_NODE_3269_length_258_cov_1.264865_g3240_i0 | PRJNA682774 | 3269 | 258 | 1.264865 | 3.2633517 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 105 | 2.46e-24 | NR | EPZ35390.1 | 988480 | g3240 | i0 | 58.3 | 1.95348837209302 | 84 | 35 | 97.7 | 0 | 3 | 254 | 364 | 447 | EPZ35390.1 Mg2+, CorA-like/Zinc transporter domain-containing protein [Rozella allomycis CSF55] | diamond | 504 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 29260880 | 29260880 | PRJNA682774_P_NODE_3509_length_253_cov_0.866667_g3480_i0 | PRJNA682774 | 3509 | 253 | 0.866667 | 2.19266751 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 90.5 | 7.61e-20 | NR | PJF16814.1 | 1246581 | g3480 | i0 | 74.1 | 2.47826086956522 | 54 | 14 | 64 | 0 | 2 | 163 | 206 | 259 | PJF16814.1 40S ribosomal protein S4 [Paramicrosporidium saccamoebae] | diamond | 627 | 90.5 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 29513475 | 29513475 | PRJNA682774_P_NODE_1490_length_359_cov_2.181818_g1461_i0 | PRJNA682774 | 1490 | 359 | 2.181818 | 7.83272662 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 72.4 | 2.72e-12 | NR | PJF18108.1 | 1246581 | g1461 | i0 | 38.1 | 1.05292479108635 | 126 | 49 | 81.1 | 4 | 64 | 354 | 7 | 132 | PJF18108.1 hypothetical protein PSACC_02076 [Paramicrosporidium saccamoebae] | diamond | 378 | 72.4 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 29639664 | 29639664 | PRJNA682774_P_NODE_470_length_633_cov_3.371429_g442_i0 | PRJNA682774 | 470 | 633 | 3.371429 | 21.34114557 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 75.5 | 2.6e-12 | NR | PJF18115.1 | 1246581 | g442 | i0 | 36.9 | 0.758293838862559 | 160 | 87 | 74.9 | 6 | 625 | 152 | 58 | 205 | PJF18115.1 Lupus La protein [Paramicrosporidium saccamoebae] | diamond | 480 | 75.5 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 30019114 | 30019114 | PRJNA682774_P_NODE_4111_length_249_cov_0.886364_g4082_i0 | PRJNA682774 | 4111 | 249 | 0.886364 | 2.20704636 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 74.7 | 2.11e-13 | NR | PJF18575.1 | 1246581 | g4082 | i0 | 55.3 | 0.91566265060241 | 76 | 32 | 91.6 | 1 | 249 | 22 | 15 | 88 | PJF18575.1 Seryl-trna synthetase [Paramicrosporidium saccamoebae] | diamond | 228 | 74.7 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 31314464 | 31314464 | PRJNA682774_P_NODE_2675_length_282_cov_1.488038_g2646_i0 | PRJNA682774 | 2675 | 282 | 1.488038 | 4.19626716 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 62 | 6.88e-9 | NR | PJF19323.1 | 1246581 | g2646 | i0 | 44.6 | 0.691489361702128 | 65 | 31 | 63.8 | 1 | 58 | 237 | 5 | 69 | PJF19323.1 hypothetical protein PSACC_00830 [Paramicrosporidium saccamoebae] | diamond | 195 | 62 | 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);;