contig_metadata
6 rows where bioproject = "PRJNA533623", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5610578 | 5610578 | PRJNA533623_P_NODE_53185_length_280_cov_10.488584_g51406_i0 | PRJNA533623 | 53185 | 280 | 10.488584 | 29.3680352 | Coelomomyces stegomyiae | 143960 | Fungi | Fungi | 169 | 2.46e-37 | NTclustered | gi|82398116|gb|DQ273767.1| | 143960 | g51406 | i0 | 93.75 | 39.0714285714286 | 112 | 7 | 40 | 0 | 73 | 184 | 2159 | 2270 | Coelomomyces stegomyiae isolate AFTOL-ID 18 28S ribosomal RNA gene, partial sequence | blastn | 10940 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces stegomyiae | |
| 5610845 | 5610845 | PRJNA533623_P_NODE_65785_length_233_cov_36.093023_g64004_i0 | PRJNA533623 | 65785 | 233 | 36.093023 | 84.09674359 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 61.2 | 9.5e-9 | NR | KAI9146480.1 | 1500003 | g64004 | i0 | 56.5 | 1.77682403433476 | 46 | 20 | 59.2 | 0 | 24 | 161 | 325 | 370 | KAI9146480.1 hypothetical protein BKA69DRAFT_1044925 [Paraphysoderma sedebokerense] | diamond | 414 | 61.2 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 12596902 | 12596902 | PRJNA533623_P_NODE_4390_length_1072_cov_12.256182_g3262_i0 | PRJNA533623 | 4390 | 1072 | 12.256182 | 131.38627104 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 151 | 3.869999999999999e-37 | NR | KAI9168422.1 | 1313167 | g3262 | i0 | 48.7 | 0.419776119402985 | 150 | 76 | 41.7 | 1 | 593 | 1039 | 390 | 539 | KAI9168422.1 Dihydrosphingosine phosphate lyase [Blastocladiella emersonii ATCC 22665] | diamond | 450 | 151 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 26681104 | 26681104 | PRJNA533623_P_NODE_25641_length_454_cov_42.982188_g23873_i0 | PRJNA533623 | 25641 | 454 | 42.982188 | 195.13913352 | Fungi | 4751 | Fungi | Fungi | 70.9 | 6.55e-13 | NR | ORZ38913.1 | 765915 | g23873 | i0 | 46.4 | 2.64977973568282 | 69 | 37 | 45.6 | 0 | 376 | 170 | 16 | 84 | ORZ38913.1 Tim10/DDP family zinc finger-domain-containing protein, partial [Catenaria anguillulae PL171] | diamond | 1203 | 70.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 29635233 | 29635233 | PRJNA533623_P_NODE_55290_length_272_cov_3.184834_g53510_i0 | PRJNA533623 | 55290 | 272 | 3.184834 | 8.66274848 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 108 | 3.87e-25 | NR | ORZ40624.1 | 765915 | g53510 | i0 | 73.8 | 0.926470588235294 | 84 | 20 | 90.4 | 1 | 22 | 267 | 1095 | 1178 | ORZ40624.1 hypothetical protein BCR44DRAFT_1482360 [Catenaria anguillulae PL171] | diamond | 252 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 29730077 | 29730077 | PRJNA533623_P_NODE_53610_length_279_cov_1.568807_g51831_i0 | PRJNA533623 | 53610 | 279 | 1.568807 | 4.37697153 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 141 | 6.71e-41 | NR | KAI9189876.1 | 1313167 | g51831 | i0 | 68.5 | 3.93548387096774 | 92 | 29 | 98.9 | 0 | 3 | 278 | 9 | 100 | KAI9189876.1 ubiquitin-conjugating enzyme E2 W [Blastocladiella emersonii ATCC 22665] | diamond | 1098 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii |
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);;