contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJEB10140" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3839564 | 3839564 | PRJEB10140_P_NODE_81724_length_448_cov_3.491228_g64465_i0 | PRJEB10140 | 81724 | 448 | 3.491228 | 15.64070144 | Entamoeba dispar | 46681 | Evosea | other_Eukaryota | 52.8 | 0.043 | NTclustered | gi|167387888|ref|XM_001738297.1| | 370354 | g64465 | i0 | 100 | 0.0625 | 28 | 0 | 6 | 0 | 76 | 103 | 1274 | 1301 | Entamoeba dispar SAW760 tyrosine protein kinase transforming protein SEA, putative (EDI_165220), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 5113912 | 5113912 | PRJEB10140_P_NODE_127205_length_288_cov_1.736402_g109898_i0 | PRJEB10140 | 127205 | 288 | 1.736402 | 5.00083776 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 95.3 | 4.36e-15 | NTclustered | gi|330840413|ref|XM_003292163.1| | 5786 | g109898 | i0 | 88.462 | 0.270833333333333 | 78 | 9 | 27 | 0 | 159 | 236 | 624 | 701 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_57790), partial mRNA | blastn | 78 | 95.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 5114586 | 5114586 | PRJEB10140_P_NODE_228385_length_178_cov_1.193798_g211076_i0 | PRJEB10140 | 228385 | 178 | 1.193798 | 2.12496044 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 158 | 3.1e-34 | NTclustered | gi|66818077|ref|XM_637640.1| | 352472 | g211076 | i0 | 86.207 | 13.3089887640449 | 145 | 20 | 81 | 0 | 13 | 157 | 373 | 517 | Dictyostelium discoideum AX4 NADH-ubiquinone oxidoreductase 23 kDa subunit (ndufs8) mRNA, complete cds | blastn | 2369 | 158 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 7663747 | 7663747 | PRJEB10140_P_NODE_109727_length_332_cov_5.544170_g92422_i0 | PRJEB10140 | 109727 | 332 | 5.54417 | 18.4066444 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 52.8 | 0.031 | NTclustered | gi|470247520|ref|XM_004366586.1| | 261658 | g92422 | i0 | 96.774 | 0.0933734939759036 | 31 | 1 | 9 | 0 | 196 | 226 | 136 | 166 | Cavenderia fasciculata uncharacterized protein (DFA_02253), partial mRNA | blastn | 31 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 7663870 | 7663870 | PRJEB10140_P_NODE_13327_length_1928_cov_2.593933_g7491_i0 | PRJEB10140 | 13327 | 1928 | 2.593933 | 50.01102824 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 60.2 | 0.001 | NTclustered | gi|470248599|ref|XM_004357786.1| | 261658 | g7491 | i0 | 100 | 0.016597510373444 | 32 | 0 | 2 | 0 | 630 | 661 | 95 | 64 | Cavenderia fasciculata uncharacterized protein (DFA_00127), partial mRNA | blastn | 32 | 60.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 11491419 | 11491419 | PRJEB10140_P_NODE_91130_length_401_cov_24.732955_g73841_i0 | PRJEB10140 | 91130 | 401 | 24.732955 | 99.17914955 | Entamoeba dispar | 46681 | Evosea | other_Eukaryota | 54.7 | 0.011 | NTclustered | gi|167379274|ref|XM_001735021.1| | 370354 | g73841 | i0 | 100 | 0.0723192019950125 | 29 | 0 | 7 | 0 | 219 | 247 | 520 | 548 | Entamoeba dispar SAW760 guanyl-nucleotide exchange factor, putative (EDI_342160), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 19138363 | 19138363 | PRJEB10140_P_NODE_279616_length_163_cov_1.824561_g262307_i0 | PRJEB10140 | 279616 | 163 | 1.824561 | 2.97403443 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|1160559416|ref|XM_020577812.1| | 670386 | g262307 | i0 | 96.97 | 0.54601226993865 | 33 | 0 | 20 | 1 | 2 | 33 | 1349 | 1381 | Polysphondylium pallidum PN500 hypothetical protein partial mRNA | blastn | 89 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 22963440 | 22963440 | PRJEB10140_P_NODE_127679_length_287_cov_1.756303_g110372_i0 | PRJEB10140 | 127679 | 287 | 1.756303 | 5.04058961 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|1160559574|ref|XM_020577891.1| | 670386 | g110372 | i0 | 94.286 | 0.121951219512195 | 35 | 2 | 12 | 0 | 143 | 177 | 1897 | 1863 | Polysphondylium pallidum PN500 putative WRKY transcription factor (wrky1), partial mRNA | blastn | 35 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 24237324 | 24237324 | PRJEB10140_P_NODE_105220_length_347_cov_2.506711_g87921_i0 | PRJEB10140 | 105220 | 347 | 2.506711 | 8.69828717 | Entamoeba dispar | 46681 | Evosea | other_Eukaryota | 52.8 | 0.033 | NTclustered | gi|167388790|ref|XM_001738646.1| | 370354 | g87921 | i0 | 100 | 0.0806916426512968 | 28 | 0 | 8 | 0 | 212 | 239 | 332 | 305 | Entamoeba dispar SAW760 uncharacterized protein (EDI_275430), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar |
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);;