contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA630162" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29114545 | 29114545 | PRJNA630162_P_NODE_152988_length_164_cov_0.904348_g151465_i0 | PRJNA630162 | 152988 | 164 | 0.904348 | 1.48313072 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 7.7300000000000005e-07 | NR | KNE57871.1 | 578462 | g151465 | i0 | 66.7 | 7.48170731707317 | 33 | 11 | 60.4 | 0 | 152 | 54 | 652 | 684 | KNE57871.1 ribonucleoside-diphosphate reductase large subunit [Allomyces macrogynus ATCC 38327] | diamond | 1227 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 29638178 | 29638178 | PRJNA630162_P_NODE_160230_length_162_cov_0.920354_g158707_i0 | PRJNA630162 | 160230 | 162 | 0.920354 | 1.49097348 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 40 | 0.0282 | NR | ORZ40939.1 | 765915 | g158707 | i0 | 52.6 | 0.703703703703704 | 38 | 17 | 68.5 | 1 | 118 | 8 | 38 | 75 | ORZ40939.1 hypothetical protein BCR44DRAFT_1424075 [Catenaria anguillulae PL171] | diamond | 114 | 40 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 30617714 | 30617714 | PRJNA630162_P_NODE_154993_length_163_cov_1.587719_g153470_i0 | PRJNA630162 | 154993 | 163 | 1.587719 | 2.58798197 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 72 | 2.6e-13 | NR | KAJ1507952.1 | 945690 | g153470 | i0 | 57.7 | 2.7239263803681 | 52 | 22 | 95.7 | 0 | 158 | 3 | 189 | 240 | KAJ1507952.1 hypothetical protein HMI54_003673 [Coelomomyces lativittatus] | diamond | 444 | 72 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 30978230 | 30978230 | PRJNA630162_P_NODE_135314_length_168_cov_0.873950_g133791_i0 | PRJNA630162 | 135314 | 168 | 0.87395 | 1.468236 | Fungi | 4751 | Fungi | Fungi | 75.1 | 5.17e-14 | NR | KAI9168527.1 | 1313167 | g133791 | i0 | 64.2 | 8.48214285714286 | 53 | 15 | 94.6 | 1 | 161 | 3 | 63 | 111 | KAI9168527.1 hypothetical protein H9P43_007900 [Blastocladiella emersonii ATCC 22665] | diamond | 1425 | 75.5 | 0.994701986754967 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 31091787 | 31091787 | PRJNA630162_P_NODE_162815_length_161_cov_2.687500_g161292_i0 | PRJNA630162 | 162815 | 161 | 2.6875 | 4.326875 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 62 | 1.94e-9 | NR | KAI9135928.1 | 1500003 | g161292 | i0 | 70 | 4.13664596273292 | 40 | 12 | 74.5 | 0 | 9 | 128 | 929 | 968 | KAI9135928.1 SNF2 family N-terminal domain-containing protein [Paraphysoderma sedebokerense] | diamond | 666 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 31819163 | 31819163 | PRJNA630162_P_NODE_91997_length_190_cov_2.929078_g90474_i0 | PRJNA630162 | 91997 | 190 | 2.929078 | 5.5652482 | Blastocladiella britannica | 64508 | Fungi | Fungi | 65.1 | 1.84e-10 | NR | KAI9223416.1 | 64508 | g90474 | i0 | 58 | 3.94736842105263 | 50 | 21 | 78.9 | 0 | 11 | 160 | 220 | 269 | KAI9223416.1 hypothetical protein BC828DRAFT_260769 [Blastocladiella britannica] | diamond | 750 | 65.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica |
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);;