contig_metadata
6 rows where bioproject = "PRJNA1132896", tax_kingdom = "Fungi" and tax_phylum = "Blastocladiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9211615 | 9211615 | PRJNA1132896_P_NODE_3068_length_319_cov_1.504065_g2977_i0 | PRJNA1132896 | 3068 | 319 | 1.504065 | 4.79796735 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 142 | 5.8499999999999994e-37 | NR | KAI9144847.1 | 1500003 | g2977 | i0 | 63.8 | 5.95297805642633 | 105 | 37 | 98.7 | 1 | 3 | 317 | 148 | 251 | KAI9144847.1 ATP synthase alpha/beta family, nucleotide-binding domain-containing protein [Paraphysoderma sedebokerense] | diamond | 1899 | 142 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 28101588 | 28101588 | PRJNA1132896_P_NODE_8545_length_246_cov_0.890173_g8454_i0 | PRJNA1132896 | 8545 | 246 | 0.890173 | 2.18982558 | Blastocladiella | 4807 | Fungi | Fungi | 66.2 | 2.02e-10 | NR | KAI9220162.1 | 64508 | g8454 | i0 | 42.2 | 2.01219512195122 | 83 | 46 | 98.8 | 1 | 2 | 244 | 710 | 792 | KAI9220162.1 chitin synthase-domain-containing protein [Blastocladiella britannica] | diamond | 495 | 66.2 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 29028569 | 29028569 | PRJNA1132896_P_NODE_2348_length_357_cov_1.559859_g2257_i0 | PRJNA1132896 | 2348 | 357 | 1.559859 | 5.56869663 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 113 | 2.75e-26 | NR | KAI9142081.1 | 1500003 | g2257 | i0 | 47.9 | 2.9327731092437 | 117 | 57 | 95.8 | 2 | 355 | 14 | 387 | 502 | KAI9142081.1 acyl-CoA synthetase [Paraphysoderma sedebokerense] | diamond | 1047 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 31650385 | 31650385 | PRJNA1132896_P_NODE_10677_length_226_cov_2.013072_g10586_i0 | PRJNA1132896 | 10677 | 226 | 2.013072 | 4.54954272 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 42.7 | 0.0315 | NR | KAI9144974.1 | 1500003 | g10586 | i0 | 31 | 0.942477876106195 | 71 | 49 | 94.2 | 0 | 13 | 225 | 1228 | 1298 | KAI9144974.1 hypothetical protein BKA69DRAFT_648959 [Paraphysoderma sedebokerense] | diamond | 213 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 31745366 | 31745366 | PRJNA1132896_P_NODE_9257_length_244_cov_0.900585_g9166_i0 | PRJNA1132896 | 9257 | 244 | 0.900585 | 2.1974274 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 70.1 | 6.09e-12 | NR | KAI9137650.1 | 1500003 | g9166 | i0 | 39.8 | 1.02049180327869 | 83 | 46 | 97.1 | 1 | 239 | 3 | 122 | 204 | KAI9137650.1 eukaryotic translation initiation factor 3 subunit I-like protein [Paraphysoderma sedebokerense] | diamond | 249 | 70.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 32872043 | 32872043 | PRJNA1132896_P_NODE_4040_length_288_cov_1.767442_g3949_i0 | PRJNA1132896 | 4040 | 288 | 1.767442 | 5.09023296 | Fungi | 4751 | Fungi | Fungi | 145 | 7.53e-42 | NR | ORZ35599.1 | 765915 | g3949 | i0 | 65.3 | 17.0104166666667 | 95 | 33 | 99 | 0 | 287 | 3 | 3 | 97 | ORZ35599.1 ribosomal L18ae/LX protein domain-domain-containing protein [Catenaria anguillulae PL171] | diamond | 4899 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae |
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);;