contig_metadata
4 rows where bioproject = "PRJNA492280", tax_clade = "Amoebozoa" and tax_phylum = "Evosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3650065 | 3650065 | PRJNA492280_P_NODE_26603_length_163_cov_5.404762_g26496_i0 | PRJNA492280 | 26603 | 163 | 5.404762 | 8.80976206 | Physariida | 5789 | Evosea | other_Eukaryota | 139 | 1.01e-28 | NTclustered | gi|3221|emb|V01159.1| | 5791 | g26496 | i0 | 100 | 44.8282208588957 | 75 | 0 | 92 | 0 | 1 | 75 | 1839 | 1765 | Physarum polycephalum gene encoding 5.8S rRNA and 26S rRNA | blastn | 7307 | 139 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 6829468 | 6829468 | PRJNA492280_P_NODE_15706_length_164_cov_4.338583_g15599_i0 | PRJNA492280 | 15706 | 164 | 4.338583 | 7.11527612 | Dianema subretisporum | 1182205 | Evosea | other_Eukaryota | 117 | 4.79e-22 | NTclustered | gi|2250222329|gb|ON713412.1| | 1182205 | g15599 | i0 | 95.833 | 45.4939024390244 | 72 | 3 | 44 | 0 | 4 | 75 | 489 | 560 | Dianema subretisporum voucher MM31413 small subunit ribosomal RNA gene, partial sequence | blastn | 7461 | 117 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Dianemataceae | Dianema | Dianema subretisporum | ||
| 24050845 | 24050845 | PRJNA492280_P_NODE_26919_length_163_cov_3.293651_g26812_i0 | PRJNA492280 | 26919 | 163 | 3.293651 | 5.36865113 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 104 | 3.7e-18 | NTclustered | gi|2687|emb|X60210.1| | 5793 | g26812 | i0 | 92.958 | 4.77914110429448 | 71 | 5 | 44 | 0 | 6 | 76 | 1398 | 1468 | D.iridis LSU rRNA gene | blastn | 779 | 104 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis | ||
| 32699948 | 32699948 | PRJNA492280_P_NODE_31260_length_151_cov_3.298246_g31153_i0 | PRJNA492280 | 31260 | 151 | 3.298246 | 4.98035146 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 60.5 | 5.91e-9 | NR | XP_003288546.1 | 5786 | g31153 | i0 | 47.1 | 1.39072847682119 | 70 | 16 | 97.4 | 1 | 148 | 2 | 177 | 246 | XP_003288546.1 uncharacterized protein DICPUDRAFT_34242 [Dictyostelium purpureum] | diamond | 210 | 60.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum |
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);;