contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA763243" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9671377 | 9671377 | PRJNA763243_P_NODE_27028_length_313_cov_7.733333_g26682_i0 | PRJNA763243 | 27028 | 313 | 7.733333 | 24.20533229 | Cunninghamella gigacellularis | 1884436 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|1050794460|gb|KX238889.1| | 1884436 | g26682 | i0 | 96.97 | 0.105431309904153 | 33 | 1 | 11 | 0 | 278 | 310 | 63 | 31 | Cunninghamella gigacellularis strain URM 7400 clone 1 large subunit ribosomal RNA gene, partial sequence | blastn | 33 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Cunninghamella | Cunninghamella gigacellularis | |
| 12222724 | 12222724 | PRJNA763243_P_NODE_30790_length_306_cov_2.060086_g30444_i0 | PRJNA763243 | 30790 | 306 | 2.060086 | 6.30386316 | Umbelopsis ramanniana | 41833 | Fungi | Fungi | 67.6 | 1.02e-6 | NTclustered | gi|2323680017|ref|XM_051585666.1| | 1314678 | g30444 | i0 | 97.436 | 3.07516339869281 | 39 | 1 | 13 | 0 | 260 | 298 | 715 | 753 | Umbelopsis ramanniana AG uncharacterized protein (K450DRAFT_221140), mRNA | blastn | 941 | 67.6 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis ramanniana | |
| 18594395 | 18594395 | PRJNA763243_P_NODE_17195_length_376_cov_2.636964_g16850_i0 | PRJNA763243 | 17195 | 376 | 2.636964 | 9.91498464 | Rhizopus delemar | 936053 | Fungi | Fungi | 209 | 2.01e-49 | NTclustered | gi|2797484205|ref|XM_067671031.1| | 246409 | g16850 | i0 | 81.369 | 66.906914893617 | 263 | 43 | 69 | 6 | 81 | 340 | 340 | 81 | Rhizopus delemar RA 99-880 histone H2B (RO3G_16447), partial mRNA | blastn | 25157 | 209 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus delemar | |
| 24156849 | 24156849 | PRJNA763243_P_NODE_15779_length_389_cov_12.265823_g15434_i0 | PRJNA763243 | 15779 | 389 | 12.265823 | 47.71405147 | Glomeraceae | 36751 | Fungi | Fungi | 154 | 9.9e-33 | NTclustered | gi|1569056421|gb|MG664440.1| | 241622 | g15434 | i0 | 90.598 | 53.3470437017995 | 117 | 10 | 57 | 1 | 4 | 120 | 752 | 867 | Uncultured Glomeromycotina clone G70849 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 | 20752 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | uncultured Glomeromycotina |
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);;