contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA971676" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 944500 | 944500 | PRJNA971676_P_NODE_11501_length_272_cov_1.356784_g11412_i0 | PRJNA971676 | 11501 | 272 | 1.356784 | 3.69045248 | Rhizophagus irregularis | 588596 | Fungi | Fungi | 95.3 | 4.09e-15 | NTclustered | gi|2749810162|ref|XM_066136109.1| | 588596 | g11412 | i0 | 76.571 | 2.51470588235294 | 175 | 39 | 64 | 2 | 40 | 213 | 1011 | 1184 | Rhizophagus irregularis uncharacterized protein (OCT59_010802), mRNA | blastn | 684 | 95.3 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus irregularis | |
| 7322848 | 7322848 | PRJNA971676_P_NODE_846_length_783_cov_2.571831_g769_i0 | PRJNA971676 | 846 | 783 | 2.571831 | 20.13743673 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 333 | 2.5e-86 | NTclustered | gi|1069936519|ref|XM_018440025.1| | 763407 | g769 | i0 | 80.455 | 49.7432950191571 | 440 | 83 | 56 | 2 | 198 | 637 | 571 | 135 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 38949 | 333 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 9872944 | 9872944 | PRJNA971676_P_NODE_4948_length_371_cov_1.812081_g4859_i0 | PRJNA971676 | 4948 | 371 | 1.812081 | 6.72282051 | Rhizopus microsporus | 58291 | Fungi | Fungi | 213 | 1.53e-50 | NTclustered | gi|1331197917|ref|XM_023610857.1| | 1340429 | g4859 | i0 | 86.598 | 21.2371967654987 | 194 | 24 | 52 | 2 | 130 | 322 | 193 | 1 | Rhizopus microsporus ATCC 52813 uncharacterized protein (RHIMIDRAFT_251574), partial mRNA | blastn | 7879 | 213 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus microsporus | |
| 13698217 | 13698217 | PRJNA971676_P_NODE_13571_length_252_cov_1.581006_g13482_i0 | PRJNA971676 | 13571 | 252 | 1.581006 | 3.98413512 | Mucor mucedo | 29922 | Fungi | Fungi | 161 | 3.639999999999999e-35 | NTclustered | gi|2324053893|ref|XM_051594572.1| | 29922 | g13482 | i0 | 78.175 | 33.515873015873 | 252 | 55 | 100 | 0 | 1 | 252 | 586 | 335 | Mucor mucedo guanine nucleotide-binding protein subunit beta-2-like 1 (EV154DRAFT_244719), mRNA | blastn | 8446 | 161 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor mucedo | |
| 16247569 | 16247569 | PRJNA971676_P_NODE_23893_length_213_cov_4.878571_g23804_i0 | PRJNA971676 | 23893 | 213 | 4.878571 | 10.39135623 | Gamsiella multidivaricata | 101098 | Fungi | Fungi | 171 | 4.96e-38 | NTclustered | gi|2323775902|ref|XM_051549929.1| | 101098 | g23804 | i0 | 83.069 | 73.4037558685446 | 189 | 30 | 88 | 2 | 26 | 213 | 386 | 199 | Gamsiella multidivaricata putative 60S ribosomal protein L27A (BC939DRAFT_112647), mRNA | blastn | 15635 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Gamsiella | Gamsiella multidivaricata | |
| 18796299 | 18796299 | PRJNA971676_P_NODE_11795_length_269_cov_2.750000_g11706_i0 | PRJNA971676 | 11795 | 269 | 2.75 | 7.3975 | Calcarisporiella thermophila | 911321 | Fungi | Fungi | 178 | 3.9e-40 | NTclustered | gi|2837845933|ref|XM_069398936.1| | 911321 | g11706 | i0 | 82.297 | 51.0557620817844 | 209 | 33 | 77 | 4 | 1 | 207 | 537 | 743 | Calcarisporiella thermophila 60S ribosomal protein uL2 (VTP21DRAFT_812), partial mRNA | blastn | 13734 | 178 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Calcarisporiellales | Calcarisporiellaceae | Calcarisporiella | Calcarisporiella thermophila |
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);;