contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA758088" and tax_phylum = "Mucoromycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 734478 | 734478 | PRJNA758088_P_NODE_133901_length_363_cov_1.327586_g126930_i0 | PRJNA758088 | 133901 | 363 | 1.327586 | 4.81913718 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 246 | 1.47e-60 | NTclustered | gi|1069957696|ref|XM_018429090.1| | 763407 | g126930 | i0 | 87.981 | 61.9504132231405 | 208 | 25 | 57 | 0 | 37 | 244 | 588 | 795 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 22488 | 246 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 10941862 | 10941862 | PRJNA758088_P_NODE_349689_length_243_cov_0.905882_g342718_i0 | PRJNA758088 | 349689 | 243 | 0.905882 | 2.20129326 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 117 | 7.6600000000000005e-22 | NTclustered | gi|1069937393|ref|XM_018438914.1| | 763407 | g342718 | i0 | 85.841 | 12.7654320987654 | 113 | 12 | 46 | 4 | 92 | 202 | 229 | 339 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 3102 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 16041688 | 16041688 | PRJNA758088_P_NODE_79933_length_474_cov_4.004988_g72968_i0 | PRJNA758088 | 79933 | 474 | 4.004988 | 18.98364312 | Radiomyces spectabilis | 64574 | Fungi | Fungi | 368 | 4.03e-97 | NTclustered | gi|2323731116|ref|XM_051568413.1| | 64574 | g72968 | i0 | 81.818 | 93.2637130801688 | 451 | 71 | 95 | 6 | 22 | 471 | 609 | 169 | Radiomyces spectabilis mitochondrial carrier domain-containing protein (BYT42DRAFT_570633), partial mRNA | blastn | 44207 | 368 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Radiomycetaceae | Radiomyces | Radiomyces spectabilis | |
| 18589311 | 18589311 | PRJNA758088_P_NODE_334715_length_245_cov_0.895349_g327744_i0 | PRJNA758088 | 334715 | 245 | 0.895349 | 2.19360505 | Halteromyces radiatus | 101107 | Fungi | Fungi | 141 | 4.59e-29 | NTclustered | gi|2323701674|ref|XM_051542933.1| | 101107 | g327744 | i0 | 83.893 | 5.61224489795918 | 149 | 22 | 60 | 2 | 40 | 187 | 343 | 490 | Halteromyces radiatus V-type proton ATPase proteolipid subunit (BX664DRAFT_319391), mRNA | blastn | 1375 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Halteromyces | Halteromyces radiatus | |
| 21139750 | 21139750 | PRJNA758088_P_NODE_309357_length_248_cov_0.880000_g302386_i0 | PRJNA758088 | 309357 | 248 | 0.88 | 2.1824 | Zychaea mexicana | 64656 | Fungi | Fungi | 132 | 2.8e-26 | NTclustered | gi|2432173028|ref|XM_053123822.1| | 64656 | g302386 | i0 | 88.785 | 14.1370967741935 | 107 | 12 | 43 | 0 | 64 | 170 | 258 | 364 | Zychaea mexicana ADP-ribosylation factor (BDB00DRAFT_827935), mRNA | blastn | 3506 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Zychaea | Zychaea mexicana |
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);;