contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA615175" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 594966 | 594966 | PRJNA615175_P_NODE_24561_length_274_cov_2.865672_g24393_i0 | PRJNA615175 | 24561 | 274 | 2.865672 | 7.85194128 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|1160554294|ref|XM_020572972.1| | 670386 | g24393 | i0 | 100 | 0.105839416058394 | 29 | 0 | 11 | 0 | 33 | 61 | 5714 | 5686 | Polysphondylium pallidum PN500 hypothetical protein (tipC), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 595127 | 595127 | PRJNA615175_P_NODE_32681_length_244_cov_3.304094_g32513_i0 | PRJNA615175 | 32681 | 244 | 3.304094 | 8.06198936 | Soliformovum expulsum | 435423 | Evosea | other_Eukaryota | 350 | 6.969999999999998e-92 | NTclustered | gi|260909293|gb|FJ766479.1| | 435423 | g32513 | i0 | 92.369 | 97.3606557377049 | 249 | 13 | 100 | 3 | 1 | 244 | 1501 | 1748 | Soliformovum expulsum culture-collection ATCC:48083 clone pool B 18S ribosomal RNA gene, partial sequence | blastn | 23756 | 350 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Fractovitellida | Soliformoviidae | Soliformovum | Soliformovum expulsum | ||
| 4422762 | 4422762 | PRJNA615175_P_NODE_7804_length_538_cov_3.617204_g7638_i0 | PRJNA615175 | 7804 | 538 | 3.617204 | 19.46055752 | Soliformovum irregulare | 435424 | Evosea | other_Eukaryota | 795 | 0 | NTclustered | gi|146448863|gb|EF513199.1| | 435424 | g7638 | i0 | 93.309 | 71.2732342007435 | 538 | 36 | 100 | 0 | 1 | 538 | 386 | 923 | Soliformovum irregulare elongation factor 1A (EF1A) gene, partial cds | blastn | 38345 | 795 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Fractovitellida | Soliformoviidae | Soliformovum | Soliformovum irregulare | ||
| 10799176 | 10799176 | PRJNA615175_P_NODE_2269_length_1019_cov_2.512685_g2151_i0 | PRJNA615175 | 2269 | 1019 | 2.512685 | 25.604260150000002 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 856 | 0 | NTclustered | gi|3209|emb|X14502.1| | 5791 | g2151 | i0 | 82.68 | 0.951913640824338 | 970 | 162 | 95 | 6 | 1 | 967 | 1060 | 94 | Physarum polycephalum plasmodial specific LAV1-2 mRNA | blastn | 970 | 856 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 13348972 | 13348972 | PRJNA615175_P_NODE_1671_length_1164_cov_3.054079_g1570_i0 | PRJNA615175 | 1671 | 1164 | 3.054079 | 35.54947956 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 743 | 0 | NTclustered | gi|1160565652|ref|XM_020580448.1| | 670386 | g1570 | i0 | 79.25 | 85.0274914089347 | 1094 | 205 | 93 | 18 | 39 | 1118 | 1227 | 142 | Polysphondylium pallidum PN500 S-adenosyl-L-homocysteine hydrolase (sahA), partial mRNA | blastn | 98972 | 743 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 19721468 | 19721468 | PRJNA615175_P_NODE_2036_length_1069_cov_18.300201_g1922_i0 | PRJNA615175 | 2036 | 1069 | 18.300201 | 195.62914869 | Didymium spongiosum | 289992 | Evosea | other_Eukaryota | 870 | 0 | NTclustered | gi|2161226356|gb|MZ313554.1| | 289992 | g1922 | i0 | 81.876 | 20.2432179607109 | 1109 | 129 | 100 | 62 | 1 | 1069 | 8173 | 7097 | Mucilago crustacea 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 | 21640 | 870 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium spongiosum | ||
| 22272206 | 22272206 | PRJNA615175_P_NODE_298_length_2039_cov_2.776195_g274_i0 | PRJNA615175 | 298 | 2039 | 2.776195 | 56.60661605 | Didymium iridis | 5793 | Evosea | other_Eukaryota | 2538 | 0 | NTclustered | gi|2687|emb|X60210.1| | 5793 | g274 | i0 | 89.453 | 21.4271701814615 | 2048 | 165 | 99 | 33 | 12 | 2039 | 843 | 2859 | D.iridis LSU rRNA gene | blastn | 43690 | 2538 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis |
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);;