contig_metadata
12 rows where bioproject = "PRJNA1010780", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26654410 | 26654410 | PRJNA1010780_S_NODE_20821_length_385_cov_3.337143_g19532_i0 | PRJNA1010780 | 20821 | 385 | 3.337143 | 12.84800055 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 63.9 | 6.45e-9 | NR | RKP19483.1 | 988480 | g19532 | i0 | 41.4 | 0.545454545454545 | 70 | 41 | 54.5 | 0 | 382 | 173 | 332 | 401 | RKP19483.1 RCC1/BLIP-II [Rozella allomycis CSF55] | diamond | 210 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 26781587 | 26781587 | PRJNA1010780_S_NODE_5901_length_1104_cov_7.037418_g5318_i0 | PRJNA1010780 | 5901 | 1104 | 7.037418 | 77.69309472 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 437 | 9.089999999999999e-145 | NR | PJF16701.1 | 1246581 | g5318 | i0 | 62.8 | 0.839673913043478 | 309 | 113 | 84 | 1 | 1007 | 81 | 72 | 378 | PJF16701.1 hypothetical protein PSACC_03482 [Paramicrosporidium saccamoebae] | diamond | 927 | 437 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 26813100 | 26813100 | PRJNA1010780_S_NODE_33221_length_241_cov_2.276699_g31932_i0 | PRJNA1010780 | 33221 | 241 | 2.276699 | 5.48684459 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 58.9 | 6.85e-8 | NR | RKP17857.1 | 988480 | g31932 | i0 | 38.4 | 0.908713692946058 | 73 | 45 | 90.9 | 0 | 12 | 230 | 392 | 464 | RKP17857.1 ARM repeat-containing protein, partial [Rozella allomycis CSF55] | diamond | 219 | 58.9 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 27445774 | 27445774 | PRJNA1010780_S_NODE_53543_length_167_cov_1.553030_g52254_i0 | PRJNA1010780 | 53543 | 167 | 1.55303 | 2.5935601 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 60.8 | 3.04e-9 | NR | EPZ32192.1 | 988480 | g52254 | i0 | 50.9 | 0.988023952095808 | 55 | 26 | 97 | 1 | 166 | 5 | 23 | 77 | EPZ32192.1 C2 calcium/lipid-binding, CaLB domain-containing protein [Rozella allomycis CSF55] | diamond | 165 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 27722482 | 27722482 | PRJNA1010780_S_NODE_44904_length_189_cov_1.863636_g43615_i0 | PRJNA1010780 | 44904 | 189 | 1.863636 | 3.52227204 | Fungi | 4751 | Fungi | Fungi | 101 | 4.3599999999999997e-23 | NR | EPZ33559.1 | 988480 | g43615 | i0 | 74.2 | 6.88888888888889 | 62 | 16 | 98.4 | 0 | 187 | 2 | 399 | 460 | EPZ33559.1 Ribosomal protein S6e domain-containing protein, partial [Rozella allomycis CSF55] | diamond | 1302 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 28550739 | 28550739 | PRJNA1010780_S_NODE_27487_length_288_cov_3.217391_g26198_i0 | PRJNA1010780 | 27487 | 288 | 3.217391 | 9.26608608 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 116 | 2.63e-28 | NR | EPZ32670.1 | 988480 | g26198 | i0 | 62.2 | 2.83333333333333 | 90 | 32 | 93.8 | 1 | 278 | 9 | 111 | 198 | EPZ32670.1 Eukaryotic translation initiation factor 2 subunit gamma [Rozella allomycis CSF55] | diamond | 816 | 116 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 28897672 | 28897672 | PRJNA1010780_S_NODE_16708_length_486_cov_2.880266_g15451_i0 | PRJNA1010780 | 16708 | 486 | 2.880266 | 13.99809276 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 85.9 | 2.62e-16 | NR | PJF17133.1 | 1246581 | g15451 | i0 | 72.7 | 0.339506172839506 | 55 | 15 | 34 | 0 | 170 | 6 | 51 | 105 | PJF17133.1 Katanin p60 ATPase domain-containing protein [Paramicrosporidium saccamoebae] | diamond | 165 | 85.9 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 29276638 | 29276638 | PRJNA1010780_S_NODE_60209_length_155_cov_1.225000_g58920_i0 | PRJNA1010780 | 60209 | 155 | 1.225 | 1.89875 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 63.9 | 2.95e-10 | NR | RKP17846.1 | 988480 | g58920 | i0 | 68.6 | 1.9741935483871 | 51 | 16 | 98.7 | 0 | 154 | 2 | 92 | 142 | RKP17846.1 methionine aminopeptidase, partial [Rozella allomycis CSF55] | diamond | 306 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 29686889 | 29686889 | PRJNA1010780_S_NODE_26930_length_294_cov_16.293436_g25641_i0 | PRJNA1010780 | 26930 | 294 | 16.293436 | 47.90270184 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 83.2 | 7.31e-17 | NR | EPZ34692.1 | 988480 | g25641 | i0 | 66.2 | 3.20408163265306 | 65 | 21 | 65.3 | 1 | 61 | 252 | 190 | 254 | EPZ34692.1 Nucleic acid-binding domain-containing protein [Rozella allomycis CSF55] | diamond | 942 | 83.2 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 30382611 | 30382611 | PRJNA1010780_S_NODE_52153_length_170_cov_1.533333_g50864_i0 | PRJNA1010780 | 52153 | 170 | 1.533333 | 2.6066661 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 64.3 | 3.4e-10 | NR | PJF17134.1 | 1246581 | g50864 | i0 | 58.9 | 0.988235294117647 | 56 | 23 | 98.8 | 0 | 1 | 168 | 1517 | 1572 | PJF17134.1 DNA-directed RNA polymerase subunit [Paramicrosporidium saccamoebae] | diamond | 168 | 64.3 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 31298447 | 31298447 | PRJNA1010780_S_NODE_22555_length_353_cov_3.701258_g21266_i0 | PRJNA1010780 | 22555 | 353 | 3.701258 | 13.06544074 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 151 | 1.25e-39 | NR | EPZ32686.1 | 988480 | g21266 | i0 | 66.7 | 4.97167138810198 | 117 | 39 | 99.4 | 0 | 2 | 352 | 1524 | 1640 | EPZ32686.1 CbxX/CfqX domain-containing protein, partial [Rozella allomycis CSF55] | diamond | 1755 | 151 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 32500866 | 32500866 | PRJNA1010780_S_NODE_17699_length_458_cov_3.600473_g16426_i0 | PRJNA1010780 | 17699 | 458 | 3.600473 | 16.49016634 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 45.8 | 0.0234 | NR | PJF17204.1 | 1246581 | g16426 | i0 | 31.6 | 0.517467248908297 | 79 | 54 | 51.7 | 0 | 393 | 157 | 194 | 272 | PJF17204.1 hypothetical protein PSACC_03008 [Paramicrosporidium saccamoebae] | diamond | 237 | 45.8 | 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);;