contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA929522" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9833250 | 9833250 | PRJNA929522_S_NODE_9208_length_246_cov_1.780347_g9138_i0 | PRJNA929522 | 9208 | 246 | 1.780347 | 4.37965362 | Umbelopsis isabellina | 91625 | Fungi | Fungi | 165 | 2.74e-36 | NTclustered | gi|1068083945|gb|KX424916.1| | 91625 | g9138 | i0 | 84.211 | 30.349593495935 | 171 | 25 | 69 | 2 | 10 | 179 | 458 | 289 | Umbelopsis isabellina strain M6-22 NAD-dependent malate dehydrogenase mRNA, complete cds | blastn | 7466 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis isabellina | |
| 12384446 | 12384446 | PRJNA929522_S_NODE_5410_length_301_cov_1.140351_g5340_i0 | PRJNA929522 | 5410 | 301 | 1.140351 | 3.43245651 | Absidia saloaensis | 2698938 | Fungi | Fungi | 545 | 1.0499999999999999e-150 | NTclustered | gi|1798056214|gb|MN953783.1| | 2698938 | g5340 | i0 | 99.336 | 98.3853820598007 | 301 | 2 | 100 | 0 | 1 | 301 | 363 | 663 | Absidia saloaensis strain URM:8209 large subunit ribosomal RNA gene, partial sequence | blastn | 29614 | 545 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Absidia | Absidia saloaensis | |
| 13659002 | 13659002 | PRJNA929522_S_NODE_6871_length_273_cov_2.310000_g6801_i0 | PRJNA929522 | 6871 | 273 | 2.31 | 6.3063 | Radiomyces spectabilis | 64574 | Fungi | Fungi | 141 | 5.2e-29 | NTclustered | gi|2323750843|ref|XM_051569791.1| | 64574 | g6801 | i0 | 84.247 | 1.78388278388278 | 146 | 21 | 53 | 2 | 128 | 272 | 282 | 426 | Radiomyces spectabilis succinyl-CoA ligase subunit alpha (BYT42DRAFT_583598), mRNA | blastn | 487 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Radiomycetaceae | Radiomyces | Radiomyces spectabilis | |
| 18756892 | 18756892 | PRJNA929522_S_NODE_6235_length_284_cov_1.857820_g6165_i0 | PRJNA929522 | 6235 | 284 | 1.85782 | 5.2762088 | Lichtheimia ornata | 688661 | Fungi | Fungi | 283 | 8.539999999999999e-72 | NTclustered | gi|2553594699|ref|XM_058489316.1| | 688661 | g6165 | i0 | 89.333 | 75.0035211267606 | 225 | 24 | 79 | 0 | 10 | 234 | 240 | 16 | Lichtheimia ornata heat shock protein HSS1 (O0I10_009322), partial mRNA | blastn | 21301 | 283 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Lichtheimia | Lichtheimia ornata | |
| 21307434 | 21307434 | PRJNA929522_S_NODE_5457_length_300_cov_1.281938_g5387_i0 | PRJNA929522 | 5457 | 300 | 1.281938 | 3.845814 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 215 | 3.36e-51 | NTclustered | gi|1069941228|ref|XM_018428823.1| | 763407 | g5387 | i0 | 80.851 | 36.1633333333333 | 282 | 46 | 93 | 8 | 7 | 284 | 312 | 35 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 10849 | 215 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 23857732 | 23857732 | PRJNA929522_S_NODE_9299_length_246_cov_0.890173_g9229_i0 | PRJNA929522 | 9299 | 246 | 0.890173 | 2.18982558 | Absidia sp. (in: mucoromycotan fungi) | 1982014 | Fungi | Fungi | 211 | 3.46e-50 | NTclustered | gi|1838434292|gb|MT436029.1| | 1982014 | g9229 | i0 | 96.825 | 44.8089430894309 | 126 | 4 | 51 | 0 | 121 | 246 | 5727 | 5602 | Absidia sp. (in: fungi) strain UoMAU379 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 11023 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Absidia | Absidia sp. (in: mucoromycotan fungi) | |
| 25131494 | 25131494 | PRJNA929522_S_NODE_5500_length_299_cov_1.022124_g5430_i0 | PRJNA929522 | 5500 | 299 | 1.022124 | 3.05615076 | Mucor mucedo | 29922 | Fungi | Fungi | 213 | 1.21e-50 | NTclustered | gi|2324050007|ref|XM_051601342.1| | 29922 | g5430 | i0 | 80.714 | 46.2976588628763 | 280 | 48 | 93 | 6 | 12 | 288 | 110 | 386 | Mucor mucedo S-adenosylmethionine synthase (EV154DRAFT_506880), mRNA | blastn | 13843 | 213 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor mucedo |
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);;