contig_metadata
7 rows where bioproject = "PRJEB10320", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11491527 | 11491527 | PRJEB10320_P_NODE_21830_length_181_cov_1.335616_g21572_i0 | PRJEB10320 | 21830 | 181 | 1.335616 | 2.41746496 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 84.7 | 4.5e-18 | NR | KAI9142824.1 | 1500003 | g21572 | i0 | 74.1 | 4.79005524861878 | 58 | 15 | 96.1 | 0 | 176 | 3 | 58 | 115 | KAI9142824.1 50S ribosomal protein L30e-like protein [Paraphysoderma sedebokerense] | diamond | 867 | 84.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 27158849 | 27158849 | PRJEB10320_P_NODE_17862_length_208_cov_2.312139_g17604_i0 | PRJEB10320 | 17862 | 208 | 2.312139 | 4.80924912 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 95.5 | 7.78e-23 | NR | KAI9139274.1 | 1500003 | g17604 | i0 | 67.2 | 1.83173076923077 | 64 | 21 | 92.3 | 0 | 194 | 3 | 5 | 68 | KAI9139274.1 ribosomal L18ae/LX protein domain-containing protein [Paraphysoderma sedebokerense] | diamond | 381 | 95.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 27728117 | 27728117 | PRJEB10320_P_NODE_20924_length_186_cov_2.741722_g20666_i0 | PRJEB10320 | 20924 | 186 | 2.741722 | 5.09960292 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 65.1 | 8.2e-12 | NR | KAJ1509468.1 | 945690 | g20666 | i0 | 58.1 | 1 | 62 | 21 | 98.4 | 2 | 2 | 184 | 20 | 77 | KAJ1509468.1 hypothetical protein HMI54_002374, partial [Coelomomyces lativittatus] | diamond | 186 | 65.1 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 27816558 | 27816558 | PRJEB10320_P_NODE_17364_length_213_cov_1.303371_g17106_i0 | PRJEB10320 | 17364 | 213 | 1.303371 | 2.77618023 | Fungi | 4751 | Fungi | Fungi | 114 | 2.38e-29 | NR | KNE58187.1 | 578462 | g17106 | i0 | 79.7 | 13.5633802816901 | 64 | 13 | 90.1 | 0 | 197 | 6 | 1 | 64 | KNE58187.1 60S ribosomal protein L8 [Allomyces macrogynus ATCC 38327] | diamond | 2889 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 29338063 | 29338063 | PRJEB10320_P_NODE_18189_length_206_cov_1.380117_g17931_i0 | PRJEB10320 | 18189 | 206 | 1.380117 | 2.84304102 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 59.7 | 4.76e-9 | NR | KNE55833.1 | 578462 | g17931 | i0 | 52.5 | 0.888349514563107 | 61 | 29 | 88.8 | 0 | 200 | 18 | 99 | 159 | KNE55833.1 hypothetical protein AMAG_01701 [Allomyces macrogynus ATCC 38327] | diamond | 183 | 59.7 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 30026774 | 30026774 | PRJEB10320_P_NODE_4911_length_479_cov_1.921171_g4666_i0 | PRJEB10320 | 4911 | 479 | 1.921171 | 9.20240909 | Blastocladiaceae | 4806 | Fungi | Fungi | 135 | 7.61e-38 | NR | KAI9222680.1 | 64508 | g4666 | i0 | 65.5 | 3.08768267223382 | 116 | 40 | 72.7 | 0 | 428 | 81 | 3 | 118 | KAI9222680.1 translation protein SH3-like domain-containing protein, partial [Blastocladiella britannica] | diamond | 1479 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 31512170 | 31512170 | PRJEB10320_P_NODE_24576_length_166_cov_1.251908_g24318_i0 | PRJEB10320 | 24576 | 166 | 1.251908 | 2.07816728 | Fungi | 4751 | Fungi | Fungi | 41.6 | 0.0339 | NR | KAI9139637.1 | 1500003 | g24318 | i0 | 36.4 | 1.86144578313253 | 55 | 35 | 99.4 | 0 | 2 | 166 | 45 | 99 | KAI9139637.1 hypothetical protein BKA69DRAFT_1084271 [Paraphysoderma sedebokerense] | diamond | 309 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense |
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);;