contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJEB75230" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2687531 | 2687531 | PRJEB75230_P_NODE_563_length_1545_cov_3.976902_g492_i0 | PRJEB75230 | 563 | 1545 | 3.976902 | 61.4431359 | Squamamoeba japonica | 1167875 | Evosea | other_Eukaryota | 303 | 3.97e-77 | NTclustered | gi|381423465|gb|JN638030.1| | 1167875 | g492 | i0 | 86.429 | 16.4543689320388 | 280 | 34 | 22 | 4 | 494 | 771 | 1461 | 1184 | Squamamoeba japonica strain CCAP 1593/1 clone 2218 18S ribosomal RNA gene, partial sequence | blastn | 25422 | 303 | 1 | Eukaryota | Amoebozoa | Evosea | Squamamoeba | Squamamoeba japonica | |||||
| 7789225 | 7789225 | PRJEB75230_P_NODE_23427_length_370_cov_1.555556_g23245_i0 | PRJEB75230 | 23427 | 370 | 1.555556 | 5.7555572 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 60.2 | 2.1e-4 | NTclustered | gi|470250729|ref|XM_004358405.1| | 261658 | g23245 | i0 | 94.872 | 0.105405405405405 | 39 | 1 | 11 | 1 | 3 | 41 | 504 | 467 | Cavenderia fasciculata uncharacterized protein (DFA_00473), partial mRNA | blastn | 39 | 60.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 7789541 | 7789541 | PRJEB75230_P_NODE_4227_length_665_cov_2.530405_g4051_i0 | PRJEB75230 | 4227 | 665 | 2.530405 | 16.82719325 | Rostrostelium ellipticum | 361140 | Evosea | other_Eukaryota | 385 | 5.75e-102 | NTclustered | gi|117413669|emb|AM168485.1| | 361140 | g4051 | i0 | 82.035 | 82.4917293233083 | 462 | 74 | 69 | 8 | 1 | 456 | 586 | 128 | Rostrostelium ellipticum partial tuba gene for alpha-tubulin, exon 1, isolate AE2 | blastn | 54857 | 385 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Rostrostelium | Rostrostelium ellipticum | ||
| 10341036 | 10341036 | PRJEB75230_P_NODE_92649_length_269_cov_1.566327_g92467_i0 | PRJEB75230 | 92649 | 269 | 1.566327 | 4.21341963 | Mastigamoeba balamuthi | 108607 | Evosea | other_Eukaryota | 182 | 3.01e-41 | NTclustered | gi|704367441|gb|KP057244.1| | 108607 | g92467 | i0 | 80.672 | 32.3977695167286 | 238 | 42 | 88 | 4 | 6 | 241 | 474 | 239 | Mastigamoeba balamuthi serine hydroxymethyltransferase mRNA, complete cds | blastn | 8715 | 182 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Mastigamoebidae | Mastigamoeba | Mastigamoeba balamuthi | |||
| 17988516 | 17988516 | PRJEB75230_P_NODE_2775_length_808_cov_2.727891_g2618_i0 | PRJEB75230 | 2775 | 808 | 2.727891 | 22.041359280000002 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 544 | 1.1e-149 | NTclustered | gi|330792727|ref|XM_003284391.1| | 5786 | g2618 | i0 | 79.349 | 78.8180693069307 | 799 | 146 | 98 | 17 | 6 | 794 | 847 | 58 | Dictyostelium purpureum elongation factor 1 alpha (DICPUDRAFT_52946), mRNA | blastn | 63685 | 544 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 17989330 | 17989330 | PRJEB75230_P_NODE_78775_length_281_cov_1.096154_g78593_i0 | PRJEB75230 | 78775 | 281 | 1.096154 | 3.08019274 | Entamoeba dispar | 46681 | Evosea | other_Eukaryota | 63.9 | 1.2e-5 | NTclustered | gi|167385781|ref|XM_001733331.1| | 370354 | g78593 | i0 | 100 | 0.120996441281139 | 34 | 0 | 12 | 0 | 165 | 198 | 2307 | 2340 | Entamoeba dispar SAW760 ataxia telangiectasia mutated, putative (EDI_100660), partial mRNA | blastn | 34 | 63.9 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 20538091 | 20538091 | PRJEB75230_P_NODE_38037_length_332_cov_0.891892_g37855_i0 | PRJEB75230 | 38037 | 332 | 0.891892 | 2.96108144 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 235 | 2.8899999999999996e-57 | NTclustered | gi|66805998|ref|XM_631629.1| | 352472 | g37855 | i0 | 79.758 | 7.12650602409639 | 331 | 61 | 99 | 5 | 5 | 332 | 1405 | 1732 | Dictyostelium discoideum AX4 elongation factor 2 (efbA) mRNA, complete cds | blastn | 2366 | 235 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 20538624 | 20538624 | PRJEB75230_P_NODE_7337_length_527_cov_1.017621_g7155_i0 | PRJEB75230 | 7337 | 527 | 1.017621 | 5.36286267 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 56.5 | 0.004 | NTclustered | gi|470264556|ref|XM_004361183.1| | 261658 | g7155 | i0 | 100 | 0.0569259962049336 | 30 | 0 | 6 | 0 | 128 | 157 | 788 | 759 | Cavenderia fasciculata pleckstrin domain-containing protein (gxcBB), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 24362689 | 24362689 | PRJEB75230_P_NODE_2280_length_881_cov_2.478960_g2132_i0 | PRJEB75230 | 2280 | 881 | 2.47896 | 21.8396376 | Filamoeba nolandi | 136452 | Evosea | other_Eukaryota | 580 | 9.169999999999999e-161 | NTclustered | gi|146448849|gb|EF513192.1| | 136452 | g2132 | i0 | 78.644 | 63.6867196367764 | 885 | 181 | 100 | 8 | 1 | 881 | 475 | 1355 | Filamoeba nolandi elongation factor 1A (EF1A) gene, partial cds | blastn | 56108 | 580 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Filamoeba | Filamoeba nolandi | ||||
| 24363454 | 24363454 | PRJEB75230_P_NODE_69160_length_289_cov_2.458333_g68978_i0 | PRJEB75230 | 69160 | 289 | 2.458333 | 7.10458237 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|330840734|ref|XM_003292318.1| | 5786 | g68978 | i0 | 100 | 0.193771626297578 | 28 | 0 | 10 | 0 | 136 | 163 | 1270 | 1243 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_99321), mRNA | blastn | 56 | 52.8 | 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);;