contig_metadata
4 rows where bioproject = "PRJNA1095825", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26647242 | 26647242 | PRJNA1095825_P_NODE_105961_length_370_cov_2.033670_g102898_i0 | PRJNA1095825 | 105961 | 370 | 2.03367 | 7.524579 | Fungi | 4751 | Fungi | Fungi | 121 | 7.54e-33 | NR | KAI9221418.1 | 64508 | g102898 | i0 | 59.8 | 4.71891891891892 | 97 | 39 | 78.6 | 0 | 24 | 314 | 14 | 110 | KAI9221418.1 60S ribosomal protein L30 [Blastocladiella britannica] | diamond | 1746 | 122 | 0.991803278688525 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 27888776 | 27888776 | PRJNA1095825_P_NODE_201525_length_275_cov_1.876238_g198462_i0 | PRJNA1095825 | 201525 | 275 | 1.876238 | 5.1596545 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 88.6 | 1.04e-18 | NR | KNE61836.1 | 578462 | g198462 | i0 | 48.2 | 0.927272727272727 | 85 | 42 | 92.7 | 1 | 255 | 1 | 204 | 286 | KNE61836.1 hypothetical protein AMAG_07112 [Allomyces macrogynus ATCC 38327] | diamond | 255 | 88.6 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 28172967 | 28172967 | PRJNA1095825_P_NODE_71166_length_449_cov_1.228723_g68103_i0 | PRJNA1095825 | 71166 | 449 | 1.228723 | 5.51696627 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 50.1 | 4.49e-4 | NR | KAJ1499711.1 | 945690 | g68103 | i0 | 75.9 | 0.193763919821826 | 29 | 7 | 19.4 | 0 | 180 | 266 | 152 | 180 | KAJ1499711.1 hypothetical protein HMI54_011471, partial [Coelomomyces lativittatus] | diamond | 87 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 30699421 | 30699421 | PRJNA1095825_P_NODE_204414_length_273_cov_1.540000_g201351_i0 | PRJNA1095825 | 204414 | 273 | 1.54 | 4.2042 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 138 | 4.55e-37 | NR | KAI9183257.1 | 1313167 | g201351 | i0 | 64.8 | 1 | 91 | 32 | 100 | 0 | 1 | 273 | 204 | 294 | KAI9183257.1 sphingolipid delta-4 desaturase [Blastocladiella emersonii ATCC 22665] | diamond | 273 | 138 | 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);;