contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA565778" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3109124 | 3109124 | PRJNA565778_S_NODE_23923_length_226_cov_2.751323_g23627_i0 | PRJNA565778 | 23923 | 226 | 2.751323 | 6.21798998 | Rhizopus delemar | 936053 | Fungi | Fungi | 285 | 1.82e-72 | NTclustered | gi|2797416685|ref|XM_067657024.1| | 246409 | g23627 | i0 | 94.118 | 26.8185840707965 | 187 | 11 | 83 | 0 | 1 | 187 | 225 | 411 | Rhizopus delemar RA 99-880 uncharacterized protein (RO3G_02433), partial mRNA | blastn | 6061 | 285 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus delemar | |
| 10762880 | 10762880 | PRJNA565778_S_NODE_9649_length_349_cov_116.599359_g9353_i0 | PRJNA565778 | 9649 | 349 | 116.599359 | 406.93176291 | Rhizopus stolonifer | 4846 | Fungi | Fungi | 558 | 1.59e-154 | NTclustered | gi|1336687659|gb|MG865992.1| | 4846 | g9353 | i0 | 99.351 | 86.4469914040115 | 308 | 2 | 88 | 0 | 42 | 349 | 3 | 310 | Rhizopus stolonifer voucher Rhs sequence | blastn | 30170 | 558 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus stolonifer | |
| 16438354 | 16438354 | PRJNA565778_S_NODE_11713_length_319_cov_98.180851_g11417_i0 | PRJNA565778 | 11713 | 319 | 98.180851 | 313.19691469 | Lichtheimiaceae | 499202 | Fungi | Fungi | 195 | 4.7e-45 | NTclustered | gi|2432189616|ref|XM_053116933.1| | 64656 | g11417 | i0 | 87.283 | 22.8025078369906 | 173 | 19 | 54 | 3 | 48 | 218 | 508 | 337 | Zychaea mexicana ribosomal protein L18e/L15P (BDB00DRAFT_32246), mRNA | blastn | 7274 | 196 | 0.994897959183674 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Zychaea | Zychaea mexicana | |
| 18409990 | 18409990 | PRJNA565778_S_NODE_12515_length_310_cov_12.421245_g12219_i0 | PRJNA565778 | 12515 | 310 | 12.421245 | 38.5058595 | Radiomyces spectabilis | 64574 | Fungi | Fungi | 154 | 7.72e-33 | NTclustered | gi|2323709042|ref|XM_051563602.1| | 64574 | g12219 | i0 | 88.372 | 2.70967741935484 | 129 | 13 | 41 | 2 | 130 | 257 | 128 | 1 | Radiomyces spectabilis ribosomal L29e protein family-domain-containing protein (BYT42DRAFT_475122), partial mRNA | blastn | 840 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Radiomycetaceae | Radiomyces | Radiomyces spectabilis | |
| 19684761 | 19684761 | PRJNA565778_S_NODE_29356_length_203_cov_2.373494_g29060_i0 | PRJNA565778 | 29356 | 203 | 2.373494 | 4.81819282 | Lobosporangium transversale | 64571 | Fungi | Fungi | 147 | 7.89e-31 | NTclustered | gi|1227149764|ref|XM_022025950.1| | 64571 | g29060 | i0 | 86.131 | 7.57142857142857 | 137 | 18 | 67 | 1 | 61 | 196 | 746 | 610 | Lobosporangium transversale 60S ribosomal protein L2 (BCR41DRAFT_363809), partial mRNA | blastn | 1537 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Lobosporangium | Lobosporangium transversale | |
| 22812925 | 22812925 | PRJNA565778_S_NODE_13118_length_303_cov_140.695489_g12822_i0 | PRJNA565778 | 13118 | 303 | 140.695489 | 426.30733167 | Fungi | 4751 | Fungi | Fungi | 466 | 8.51e-127 | NTclustered | gi|658131632|emb|HF968958.1| | 4874 | g12822 | i0 | 99.225 | 108.564356435644 | 258 | 2 | 85 | 0 | 37 | 294 | 2009 | 2266 | Gigaspora margarita partial 28S rRNA gene, strain BEG34, isolate spore 4, clone BL2_6_26 | blastn | 32895 | 466 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita | |
| 24784432 | 24784432 | PRJNA565778_S_NODE_23720_length_227_cov_2.431579_g23424_i0 | PRJNA565778 | 23720 | 227 | 2.431579 | 5.51968433 | Zychaea mexicana | 64656 | Fungi | Fungi | 71.3 | 5.58e-8 | NTclustered | gi|2432145018|ref|XM_053129847.1| | 64656 | g23424 | i0 | 80.899 | 0.92511013215859 | 89 | 17 | 39 | 0 | 139 | 227 | 373 | 285 | Zychaea mexicana 40S ribosomal protein S20 (BDB00DRAFT_970980), mRNA | blastn | 210 | 71.3 | 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);;