contig_metadata
8 rows where bioproject = "PRJNA1160211", tax_kingdom = "Fungi" and tax_phylum = "Zoopagomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5412141 | 5412141 | PRJNA1160211_S_NODE_121505_length_418_cov_23.428986_g120276_i0 | PRJNA1160211 | 121505 | 418 | 23.428986 | 97.93316148 | Pandora neoaphidis | 76017 | Fungi | Fungi | 725 | 0 | NTclustered | gi|1390219702|gb|MH366634.1| | 76017 | g120276 | i0 | 99.747 | 67.0717703349282 | 395 | 1 | 94 | 0 | 24 | 418 | 306 | 700 | Pandora neoaphidis voucher Number 19 large subunit ribosomal RNA gene, partial sequence | blastn | 28036 | 725 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Pandora | Pandora neoaphidis | |
| 20710691 | 20710691 | PRJNA1160211_S_NODE_148737_length_376_cov_12.290429_g147504_i0 | PRJNA1160211 | 148737 | 376 | 12.290429 | 46.21201304 | Neoconidiobolus thromboides | 76012 | Fungi | Fungi | 270 | 9.08e-68 | NTclustered | gi|2032035963|gb|MW795364.1| | 76012 | g147504 | i0 | 82.059 | 1.84042553191489 | 340 | 39 | 86 | 14 | 19 | 341 | 32748 | 32414 | Neoconidiobolus thromboides strain ATCC 12587 mitochondrion, complete genome | blastn | 692 | 270 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Neoconidiobolus | Neoconidiobolus thromboides | |
| 23261743 | 23261743 | PRJNA1160211_S_NODE_182159_length_331_cov_28.488372_g180926_i0 | PRJNA1160211 | 182159 | 331 | 28.488372 | 94.29651132 | Pandora neoaphidis | 76017 | Fungi | Fungi | 573 | 5.379999999999998e-159 | NTclustered | gi|1390219702|gb|MH366634.1| | 76017 | g180926 | i0 | 100 | 80.0996978851964 | 310 | 0 | 94 | 0 | 22 | 331 | 41 | 350 | Pandora neoaphidis voucher Number 19 large subunit ribosomal RNA gene, partial sequence | blastn | 26513 | 573 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Pandora | Pandora neoaphidis | |
| 26596909 | 26596909 | PRJNA1160211_S_NODE_181121_length_333_cov_1.996154_g179888_i0 | PRJNA1160211 | 181121 | 333 | 1.996154 | 6.64719282 | Coemansia sp. RSA 455 | 2663915 | Fungi | Fungi | 80.5 | 4.09e-15 | NR | KAJ2236155.1 | 2663915 | g179888 | i0 | 40.7 | 7.64864864864865 | 108 | 33 | 97.3 | 1 | 325 | 2 | 86 | 162 | KAJ2236155.1 hypothetical protein GGI13_008530, partial [Coemansia sp. RSA 455] | diamond | 2547 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. RSA 455 | |
| 26787344 | 26787344 | PRJNA1160211_S_NODE_35621_length_627_cov_3.805054_g34498_i0 | PRJNA1160211 | 35621 | 627 | 3.805054 | 23.85768858 | Syncephalis fuscata | 1851187 | Fungi | Fungi | 49.3 | 0.00421 | NR | KAI9595585.1 | 1851187 | g34498 | i0 | 50 | 0.416267942583732 | 48 | 18 | 23 | 2 | 483 | 626 | 267 | 308 | KAI9595585.1 hypothetical protein BDF19DRAFT_440943 [Syncephalis fuscata] | diamond | 261 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Syncephalis | Syncephalis fuscata | |
| 27545956 | 27545956 | PRJNA1160211_S_NODE_164444_length_355_cov_1.407801_g163211_i0 | PRJNA1160211 | 164444 | 355 | 1.407801 | 4.99769355 | Piptocephalis tieghemiana | 1286916 | Fungi | Fungi | 70.5 | 1.08e-12 | NR | KAI9227560.1 | 1286916 | g163211 | i0 | 58.7 | 1.06478873239437 | 63 | 26 | 53.2 | 0 | 348 | 160 | 51 | 113 | KAI9227560.1 MAG: Prefoldin [Piptocephalis tieghemiana] | diamond | 378 | 70.5 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Piptocephalis | Piptocephalis tieghemiana | |
| 30261822 | 30261822 | PRJNA1160211_S_NODE_149132_length_376_cov_2.518152_g147899_i0 | PRJNA1160211 | 149132 | 376 | 2.518152 | 9.46825152 | Neoconidiobolus thromboides FSU 785 | 1314799 | Fungi | Fungi | 111 | 4.0700000000000005e-27 | NR | KAI9295824.1 | 1314799 | g147899 | i0 | 54.2 | 1.30851063829787 | 83 | 35 | 66.2 | 1 | 354 | 106 | 203 | 282 | KAI9295824.1 putative aspartic endopeptidase, partial [Neoconidiobolus thromboides FSU 785] | diamond | 492 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Neoconidiobolus | Neoconidiobolus thromboides | |
| 32316971 | 32316971 | PRJNA1160211_S_NODE_221799_length_287_cov_13.752336_g220566_i0 | PRJNA1160211 | 221799 | 287 | 13.752336 | 39.46920432 | Ramicandelaber brevisporus | 304332 | Fungi | Fungi | 68.6 | 4.98e-13 | NR | KAI8872367.1 | 304332 | g220566 | i0 | 71.7 | 0.480836236933798 | 46 | 13 | 48.1 | 0 | 282 | 145 | 9 | 54 | KAI8872367.1 40S ribosomal protein S28, partial [Ramicandelaber brevisporus] | diamond | 138 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Ramicandelaberales | Ramicandelaberaceae | Ramicandelaber | Ramicandelaber brevisporus |
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);;