contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA890871" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9793015 | 9793015 | PRJNA890871_P_NODE_72368_length_247_cov_0.885057_g72233_i0 | PRJNA890871 | 72368 | 247 | 0.885057 | 2.18609079 | Cokeromyces recurvatus | 90255 | Fungi | Fungi | 163 | 9.88e-36 | NTclustered | gi|2324083841|ref|XM_051523433.1| | 90255 | g72233 | i0 | 84.663 | 1.35627530364372 | 163 | 25 | 66 | 0 | 85 | 247 | 697 | 535 | Cokeromyces recurvatus meiotic recombinase Dmc1 (BX663DRAFT_441048), partial mRNA | blastn | 335 | 163 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Cokeromyces | Cokeromyces recurvatus | |
| 17443609 | 17443609 | PRJNA890871_P_NODE_90774_length_230_cov_2.828025_g90639_i0 | PRJNA890871 | 90774 | 230 | 2.828025 | 6.5044575 | Mucor velutinosus | 708070 | Fungi | Fungi | 185 | 1.94e-42 | NTclustered | gi|2724932545|ref|XM_064824701.1| | 708070 | g90639 | i0 | 90.647 | 0.604347826086956 | 139 | 13 | 60 | 0 | 8 | 146 | 161 | 23 | Mucor velutinosus NADH:ubiquinone oxidoreductase 24 (NUO24), partial mRNA | blastn | 139 | 185 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor velutinosus | |
| 21644706 | 21644706 | PRJNA890871_P_NODE_48717_length_268_cov_2.194872_g48582_i0 | PRJNA890871 | 48717 | 268 | 2.194872 | 5.88225696 | Mucor | 4830 | Fungi | Fungi | 496 | 9.429999999999999e-136 | NTclustered | gi|908373101|gb|JF723685.2| | 4841 | g48582 | i0 | 100 | 100 | 268 | 0 | 100 | 0 | 1 | 268 | 577 | 844 | Mucor racemosus strain CBS 115.08 18S ribosomal RNA gene, partial sequence | blastn | 26800 | 496 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor racemosus | |
| 23816543 | 23816543 | PRJNA890871_P_NODE_35939_length_290_cov_1.419355_g35804_i0 | PRJNA890871 | 35939 | 290 | 1.419355 | 4.1161295 | Mucor racemosus | 4841 | Fungi | Fungi | 536 | 6.079999999999999e-148 | NTclustered | gi|225134681|gb|FJ345353.1| | 4841 | g35804 | i0 | 100 | 56.5172413793103 | 290 | 0 | 100 | 0 | 1 | 290 | 2239 | 2528 | Mucor racemosus strain ATCC 42647 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 16390 | 536 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor racemosus |
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);;