contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA1249042" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 354070 | 354070 | PRJNA1249042_S_NODE_114341_length_151_cov_161.370370_g114127_i0 | PRJNA1249042 | 114341 | 151 | 161.37037 | 243.6692587 | Mucor mucedo | 29922 | Fungi | Fungi | 58.4 | 2.65e-4 | NTclustered | gi|2324075884|ref|XM_051603668.1| | 29922 | g114127 | i0 | 94.737 | 0.251655629139073 | 38 | 0 | 25 | 1 | 45 | 82 | 253 | 218 | Mucor mucedo uncharacterized protein (EV154DRAFT_529412), mRNA | blastn | 38 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor mucedo | |
| 354261 | 354261 | PRJNA1249042_S_NODE_31181_length_239_cov_1.959184_g30967_i0 | PRJNA1249042 | 31181 | 239 | 1.959184 | 4.68244976 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 82.4 | 2.74e-11 | NTclustered | gi|1069937857|ref|XM_018438040.1| | 763407 | g30967 | i0 | 77.181 | 5.25941422594142 | 149 | 29 | 62 | 5 | 91 | 238 | 346 | 202 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein partial mRNA | blastn | 1257 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 3602817 | 3602817 | PRJNA1249042_S_NODE_65743_length_192_cov_1.577181_g65529_i0 | PRJNA1249042 | 65743 | 192 | 1.577181 | 3.02818752 | Blakeslea | 4849 | Fungi | Fungi | 355 | 1.13e-93 | NTclustered | gi|11078065|gb|AF157178.1|AF157178 | 4850 | g65529 | i0 | 100 | 99.9895833333333 | 192 | 0 | 100 | 0 | 1 | 192 | 35 | 226 | Blakeslea trispora 28S ribosomal RNA gene, partial sequence | blastn | 19198 | 355 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Choanephoraceae | Blakeslea | Blakeslea trispora | |
| 6731992 | 6731992 | PRJNA1249042_S_NODE_117526_length_150_cov_1.345794_g117312_i0 | PRJNA1249042 | 117526 | 150 | 1.345794 | 2.018691 | Radiomyces spectabilis | 64574 | Fungi | Fungi | 139 | 9.12e-29 | NTclustered | gi|2323708324|ref|XM_051566874.1| | 64574 | g117312 | i0 | 85.606 | 7.66 | 132 | 19 | 88 | 0 | 19 | 150 | 322 | 453 | Radiomyces spectabilis 40S ribosomal protein S18 (BYT42DRAFT_557287), partial mRNA | blastn | 1149 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Radiomycetaceae | Radiomyces | Radiomyces spectabilis | |
| 11832885 | 11832885 | PRJNA1249042_S_NODE_21230_length_261_cov_1.899083_g21016_i0 | PRJNA1249042 | 21230 | 261 | 1.899083 | 4.95660663 | Halteromyces radiatus | 101107 | Fungi | Fungi | 150 | 8.2e-32 | NTclustered | gi|2323722226|ref|XM_051544598.1| | 101107 | g21016 | i0 | 79.111 | 2.08812260536398 | 225 | 41 | 85 | 6 | 40 | 261 | 423 | 202 | Halteromyces radiatus 40S ribosomal protein S16 (BX664DRAFT_328416), partial mRNA | blastn | 545 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Halteromyces | Halteromyces radiatus |
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);;