contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA662254" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4456286 | 4456286 | PRJNA662254_P_NODE_5524_length_738_cov_2.153383_g4933_i0 | PRJNA662254 | 5524 | 738 | 2.153383 | 15.89196654 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 715 | 0 | NTclustered | gi|330802803|ref|XM_003289355.1| | 5786 | g4933 | i0 | 85.863 | 88.6287262872629 | 672 | 95 | 91 | 0 | 11 | 682 | 717 | 46 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_72679), mRNA | blastn | 65408 | 715 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 9556747 | 9556747 | PRJNA662254_P_NODE_25928_length_324_cov_3.059761_g25277_i0 | PRJNA662254 | 25928 | 324 | 3.059761 | 9.91362564 | Entamoeba histolytica | 5759 | Evosea | other_Eukaryota | 63.9 | 1.41e-5 | NTclustered | gi|415339|emb|X65163.1| | 5759 | g25277 | i0 | 93.333 | 106.259259259259 | 45 | 0 | 13 | 2 | 282 | 324 | 6012 | 5969 | E.histolytica rRNA | blastn | 34428 | 63.9 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 12107795 | 12107795 | PRJNA662254_P_NODE_8790_length_567_cov_0.935223_g8150_i0 | PRJNA662254 | 8790 | 567 | 0.935223 | 5.30271441 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 405 | 3.73e-108 | NTclustered | gi|1160571292|ref|XM_020575140.1| | 670386 | g8150 | i0 | 80.364 | 81.9541446208113 | 550 | 94 | 96 | 12 | 1 | 543 | 709 | 1251 | Polysphondylium pallidum PN500 vacuolar H+-ATPase A subunit (vatA), partial mRNA | blastn | 46468 | 405 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 13915898 | 13915898 | PRJNA662254_P_NODE_29131_length_307_cov_1.337607_g28480_i0 | PRJNA662254 | 29131 | 307 | 1.337607 | 4.10645349 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|3599669|dbj|AB009080.1| | 44689 | g28480 | i0 | 100 | 0.495114006514658 | 30 | 0 | 10 | 0 | 194 | 223 | 2723 | 2694 | Dictyostelium discoideum gene for TRFA, complete cds | blastn | 152 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 15190444 | 15190444 | PRJNA662254_P_NODE_1772_length_1330_cov_24.992840_g1445_i0 | PRJNA662254 | 1772 | 1330 | 24.99284 | 332.404772 | Entamoeba | 5758 | Evosea | other_Eukaryota | 856 | 0 | NTclustered | gi|511083902|dbj|AK419160.1| | 5759 | g1445 | i0 | 80.694 | 84.4894736842105 | 1124 | 197 | 84 | 18 | 149 | 1262 | 1142 | 29 | Entamoeba histolytica cDNA clone: Xeh-003B20, actin, complete cds, strain: HM-1:IMSS | blastn | 112371 | 856 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 15931092 | 15931092 | PRJNA662254_P_NODE_2093_length_1231_cov_3.887737_g1733_i0 | PRJNA662254 | 2093 | 1231 | 3.887737 | 47.85804247 | Entamoeba histolytica | 5759 | Evosea | other_Eukaryota | 680 | 0 | NTclustered | gi|511087819|dbj|AK421189.1| | 5759 | g1733 | i0 | 78.336 | 63.4646628757108 | 1094 | 207 | 88 | 24 | 117 | 1198 | 1091 | 16 | Entamoeba histolytica cDNA clone: Xeh-012A11, elongation factor 1-alpha 1, complete cds, strain: HM-1:IMSS | blastn | 78125 | 680 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 16464748 | 16464748 | PRJNA662254_P_NODE_28393_length_311_cov_1.214286_g27742_i0 | PRJNA662254 | 28393 | 311 | 1.214286 | 3.77642946 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 263 | 1.23e-65 | NTclustered | gi|300078500|gb|GU001162.1| | 136499 | g27742 | i0 | 82.019 | 98.2154340836013 | 317 | 49 | 100 | 7 | 1 | 311 | 3398 | 3084 | Phalansterium solitarium 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 | 30545 | 263 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium solitarium | ||||
| 24854614 | 24854614 | PRJNA662254_P_NODE_50500_length_248_cov_1.800000_g49849_i0 | PRJNA662254 | 50500 | 248 | 1.8 | 4.464 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 246 | 9.59e-61 | NTclustered | gi|1160574980|ref|XM_020581849.1| | 670386 | g49849 | i0 | 85.593 | 96.8225806451613 | 236 | 33 | 95 | 1 | 10 | 245 | 805 | 571 | Polysphondylium pallidum PN500 hypothetical protein partial mRNA | blastn | 24012 | 246 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album |
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);;