contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA274362" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 370615 | 370615 | PRJNA274362_S_NODE_26541_length_183_cov_1.798507_g26421_i0 | PRJNA274362 | 26541 | 183 | 1.798507 | 3.29126781 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 263 | 6.61e-66 | NTclustered | gi|330799499|ref|XM_003287734.1| | 5786 | g26421 | i0 | 93.714 | 97.2677595628415 | 175 | 11 | 96 | 0 | 3 | 177 | 263 | 89 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_72359), partial mRNA | blastn | 17800 | 263 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 370636 | 370636 | PRJNA274362_S_NODE_2741_length_494_cov_3.323596_g2623_i0 | PRJNA274362 | 2741 | 494 | 3.323596 | 16.41856424 | Entamoeba suis | 359305 | Evosea | other_Eukaryota | 444 | 6.81e-120 | NTclustered | gi|731174162|dbj|AB914741.1| | 359305 | g2623 | i0 | 83.368 | 98.9392712550607 | 487 | 74 | 98 | 7 | 1 | 484 | 243 | 725 | Entamoeba suis gene for actin, partial cds, isolate: Sa-69 | blastn | 48876 | 444 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba suis | |||
| 4197583 | 4197583 | PRJNA274362_S_NODE_19384_length_209_cov_0.943750_g19264_i0 | PRJNA274362 | 19384 | 209 | 0.94375 | 1.9724375 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 250 | 6.05e-62 | NTclustered | gi|66805384|ref|XM_631333.1| | 352472 | g19264 | i0 | 88.406 | 96.6172248803828 | 207 | 24 | 99 | 0 | 1 | 207 | 1119 | 913 | Dictyostelium discoideum AX4 hypothetical protein (act4) mRNA, complete cds | blastn | 20193 | 250 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 5473668 | 5473668 | PRJNA274362_S_NODE_11605_length_258_cov_3.674641_g11485_i0 | PRJNA274362 | 11605 | 258 | 3.674641 | 9.48057378 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 353 | 5.749999999999998e-93 | NTclustered | gi|66804710|ref|XM_630996.1| | 352472 | g11485 | i0 | 91.732 | 96.7403100775194 | 254 | 21 | 98 | 0 | 3 | 256 | 652 | 905 | Dictyostelium discoideum AX4 hypothetical protein (act5) mRNA, complete cds | blastn | 24959 | 353 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 10574637 | 10574637 | PRJNA274362_S_NODE_27329_length_181_cov_1.181818_g27209_i0 | PRJNA274362 | 27329 | 181 | 1.181818 | 2.13909058 | Diacheopsis resinae | 3092648 | Evosea | other_Eukaryota | 200 | 5.19e-47 | NTclustered | gi|2727873016|gb|OR778661.1| | 3092648 | g27209 | i0 | 88.024 | 92.2375690607735 | 167 | 18 | 92 | 2 | 1 | 166 | 497 | 662 | Diacheopsis sp. OShchepin-2023a voucher LK-zV4186 translation elongation factor 1-alpha (EF1A) gene, partial cds | blastn | 16695 | 200 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Diacheopsis | Diacheopsis resinae | |||
| 11849183 | 11849183 | PRJNA274362_S_NODE_23030_length_194_cov_5.020690_g22910_i0 | PRJNA274362 | 23030 | 194 | 5.02069 | 9.7401386 | Diachea mitchellii | 2928464 | Evosea | other_Eukaryota | 254 | 4.28e-63 | NTclustered | gi|2574169345|gb|OP630987.1| | 2928464 | g22910 | i0 | 90.256 | 98.2680412371134 | 195 | 17 | 100 | 2 | 1 | 194 | 875 | 682 | Diachea mitchellii strain MA-Fungi 96407 alpha-tubulin (aTUB) gene, partial cds | blastn | 19064 | 254 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Diachea | Diachea mitchellii | ||
| 15086209 | 15086209 | PRJNA274362_S_NODE_31172_length_171_cov_0.991803_g31052_i0 | PRJNA274362 | 31172 | 171 | 0.991803 | 1.69598313 | Didymium | 5792 | Evosea | other_Eukaryota | 174 | 2.93e-39 | NTclustered | gi|2049856602|gb|MG963730.1| | 289976 | g31052 | i0 | 88.356 | 84.8479532163743 | 146 | 16 | 85 | 1 | 1 | 145 | 504 | 649 | Didymium clavus strain MA-Fungi 51663 alpha-tubulin (a-Tub) gene, partial cds | blastn | 14509 | 174 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium clavus | ||
| 18222412 | 18222412 | PRJNA274362_S_NODE_31135_length_171_cov_1.122951_g31015_i0 | PRJNA274362 | 31135 | 171 | 1.122951 | 1.92024621 | Filamoeba nolandi | 136452 | Evosea | other_Eukaryota | 161 | 2.28e-35 | NTclustered | gi|146448849|gb|EF513192.1| | 136452 | g31015 | i0 | 86 | 81.7426900584795 | 150 | 21 | 88 | 0 | 15 | 164 | 538 | 687 | Filamoeba nolandi elongation factor 1A (EF1A) gene, partial cds | blastn | 13978 | 161 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Filamoeba | Filamoeba nolandi |
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);;