contig_metadata
10 rows where bioproject = "PRJNA489308" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6827782 | 6827782 | PRJNA489308_P_NODE_28046_length_258_cov_1.794595_g27970_i0 | PRJNA489308 | 28046 | 258 | 1.794595 | 4.6300551 | Fungi | 4751 | Fungi | Fungi | 80.1 | 2.79e-15 | NR | PJF19253.1 | 1246581 | g27970 | i0 | 64.7 | 2.97674418604651 | 51 | 18 | 59.3 | 0 | 157 | 5 | 1 | 51 | PJF19253.1 hypothetical protein PSACC_00935 [Paramicrosporidium saccamoebae] | diamond | 768 | 80.1 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 24676389 | 24676389 | PRJNA489308_P_NODE_8700_length_374_cov_2.421927_g8624_i0 | PRJNA489308 | 8700 | 374 | 2.421927 | 9.05800698 | Eukaryota | 2759 | Fungi | Fungi | 178 | 9.71e-51 | NR | EPZ30990.1 | 988480 | g8624 | i0 | 71.8 | 6.96256684491979 | 124 | 35 | 99.5 | 0 | 374 | 3 | 362 | 485 | EPZ30990.1 Acyl-CoA dehydrogenase/oxidase domain-containing protein [Rozella allomycis CSF55] | diamond | 2604 | 179 | 0.994413407821229 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 26633163 | 26633163 | PRJNA489308_P_NODE_11481_length_340_cov_26.576779_g11405_i0 | PRJNA489308 | 11481 | 340 | 26.576779 | 90.3610486 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 118 | 4.35e-30 | NR | EPZ30786.1 | 988480 | g11405 | i0 | 59.6 | 1.56176470588235 | 89 | 36 | 78.5 | 0 | 321 | 55 | 162 | 250 | EPZ30786.1 Ribosomal protein L22/L17, eukaryotic/archaeal domain-containing protein [Rozella allomycis CSF55] | diamond | 531 | 118 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 27092397 | 27092397 | PRJNA489308_P_NODE_41222_length_200_cov_6.456693_g41146_i0 | PRJNA489308 | 41222 | 200 | 6.456693 | 12.913386 | Eukaryota | 2759 | Fungi | Fungi | 79 | 8.53e-16 | NR | EPZ34692.1 | 988480 | g41146 | i0 | 65.6 | 4.635 | 64 | 21 | 94.5 | 1 | 10 | 198 | 190 | 253 | EPZ34692.1 Nucleic acid-binding domain-containing protein [Rozella allomycis CSF55] | diamond | 927 | 79.3 | 0.996216897856242 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 27107774 | 27107774 | PRJNA489308_P_NODE_342_length_1296_cov_23.946034_g307_i0 | PRJNA489308 | 342 | 1296 | 23.946034 | 310.34060064 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 284 | 2.46e-90 | NR | PJF16902.1 | 1246581 | g307 | i0 | 64 | 6.75925925925926 | 236 | 82 | 54.4 | 3 | 167 | 871 | 24 | 257 | PJF16902.1 hypothetical protein PSACC_03283 [Paramicrosporidium saccamoebae] | diamond | 8760 | 284 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 28086943 | 28086943 | PRJNA489308_P_NODE_17985_length_296_cov_1.784753_g17909_i0 | PRJNA489308 | 17985 | 296 | 1.784753 | 5.28286888 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 84.7 | 1.48e-18 | NR | EPZ33918.1 | 988480 | g17909 | i0 | 56 | 0.760135135135135 | 75 | 23 | 76 | 1 | 2 | 226 | 62 | 126 | EPZ33918.1 Pre-mRNA branch site protein p14 [Rozella allomycis CSF55] | diamond | 225 | 84.7 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 28276377 | 28276377 | PRJNA489308_P_NODE_36606_length_243_cov_66.164706_g36530_i0 | PRJNA489308 | 36606 | 243 | 66.164706 | 160.78023558 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 82 | 1.01e-16 | NR | EPZ34692.1 | 988480 | g36530 | i0 | 66.2 | 3.87654320987654 | 65 | 21 | 79 | 1 | 23 | 214 | 190 | 254 | EPZ34692.1 Nucleic acid-binding domain-containing protein [Rozella allomycis CSF55] | diamond | 942 | 82 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 28402812 | 28402812 | PRJNA489308_P_NODE_12586_length_331_cov_1.193798_g12510_i0 | PRJNA489308 | 12586 | 331 | 1.193798 | 3.95147138 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 90.5 | 3.12e-19 | NR | PJF18475.1 | 1246581 | g12510 | i0 | 60.6 | 3.32628398791541 | 66 | 26 | 59.8 | 0 | 134 | 331 | 98 | 163 | PJF18475.1 UMP-CMP kinase [Paramicrosporidium saccamoebae] | diamond | 1101 | 90.5 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 28718605 | 28718605 | PRJNA489308_P_NODE_34007_length_247_cov_0.885057_g33931_i0 | PRJNA489308 | 34007 | 247 | 0.885057 | 2.18609079 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 43.1 | 0.0289 | NR | EPZ33152.1 | 988480 | g33931 | i0 | 42.6 | 0.57085020242915 | 47 | 27 | 57.1 | 0 | 153 | 13 | 561 | 607 | EPZ33152.1 ABC transporter domain-containing protein [Rozella allomycis CSF55] | diamond | 141 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 30139178 | 30139178 | PRJNA489308_P_NODE_5652_length_445_cov_3.395161_g5576_i0 | PRJNA489308 | 5652 | 445 | 3.395161 | 15.10846645 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 75.1 | 5.34e-13 | NR | PJF16516.1 | 1246581 | g5576 | i0 | 48.8 | 0.552808988764045 | 82 | 35 | 50.6 | 1 | 445 | 221 | 168 | 249 | PJF16516.1 hypothetical protein PSACC_03723 [Paramicrosporidium saccamoebae] | diamond | 246 | 75.1 | 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);;