contig_metadata
6 rows where bioproject = "PRJEB43370", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26906936 | 26906936 | PRJEB43370_P_NODE_10882_length_162_cov_0.920354_g10839_i0 | PRJEB43370 | 10882 | 162 | 0.920354 | 1.49097348 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 80.1 | 8.21e-16 | NR | EPZ30926.1 | 988480 | g10839 | i0 | 67.9 | 5.83333333333333 | 53 | 17 | 98.1 | 0 | 2 | 160 | 247 | 299 | EPZ30926.1 Peptidase S8/S53 domain-containing protein [Rozella allomycis CSF55] | diamond | 945 | 80.1 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 27159600 | 27159600 | PRJEB43370_P_NODE_3942_length_223_cov_1.195402_g3899_i0 | PRJEB43370 | 3942 | 223 | 1.195402 | 2.66574646 | Rozella allomycis CSF55 | 988480 | Fungi | Fungi | 125 | 3.0899999999999993e-31 | NR | EPZ33761.1 | 988480 | g3899 | i0 | 82.2 | 5.89237668161435 | 73 | 13 | 98.2 | 0 | 223 | 5 | 243 | 315 | EPZ33761.1 Aminotransferase, class I/classII domain-containing protein [Rozella allomycis CSF55] | diamond | 1314 | 125 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 27539100 | 27539100 | PRJEB43370_P_NODE_3424_length_237_cov_1.021277_g3381_i0 | PRJEB43370 | 3424 | 237 | 1.021277 | 2.42042649 | Paramicrosporidium saccamoebae | 1246581 | Fungi | Fungi | 82.8 | 5.25e-17 | NR | PJF16614.1 | 1246581 | g3381 | i0 | 70.4 | 0.89873417721519 | 71 | 21 | 89.9 | 0 | 237 | 25 | 174 | 244 | PJF16614.1 40S ribosomal protein S6 [Paramicrosporidium saccamoebae] | diamond | 213 | 82.8 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Paramicrosporidium | Paramicrosporidium saccamoebae | ||||
| 30563610 | 30563610 | PRJEB43370_P_NODE_2253_length_288_cov_1.615063_g2210_i0 | PRJEB43370 | 2253 | 288 | 1.615063 | 4.65138144 | Eukaryota | 2759 | Fungi | Fungi | 124 | 4.749999999999999e-31 | NR | EPZ31343.1 | 988480 | g2210 | i0 | 57.3 | 6.01041666666667 | 96 | 41 | 100 | 0 | 1 | 288 | 197 | 292 | EPZ31343.1 DUF1900 domain-containing protein [Rozella allomycis CSF55] | diamond | 1731 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 30848318 | 30848318 | PRJEB43370_P_NODE_4214_length_217_cov_0.928571_g4171_i0 | PRJEB43370 | 4214 | 217 | 0.928571 | 2.01499907 | Eukaryota | 2759 | Fungi | Fungi | 125 | 1.58e-33 | NR | EPZ33659.1 | 988480 | g4171 | i0 | 78.9 | 10.7972350230415 | 71 | 15 | 98.2 | 0 | 215 | 3 | 85 | 155 | EPZ33659.1 60S ribosomal protein L8 [Rozella allomycis CSF55] | diamond | 2343 | 125 | 1 | Eukaryota | Opisthokonta | Fungi | Cryptomycota | Rozella | Rozella allomycis | ||||
| 32429668 | 32429668 | PRJEB43370_P_NODE_3659_length_230_cov_0.845304_g3616_i0 | PRJEB43370 | 3659 | 230 | 0.84530400000000006 | 1.9441992 | Eukaryota | 2759 | Fungi | Fungi | 112 | 2.57e-28 | NR | PJF16614.1 | 1246581 | g3616 | i0 | 73.7 | 1.98260869565217 | 76 | 20 | 99.1 | 0 | 229 | 2 | 130 | 205 | PJF16614.1 40S ribosomal protein S6 [Paramicrosporidium saccamoebae] | diamond | 456 | 113 | 0.991150442477876 | 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);;