contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJDB3785" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1283047 | 1283047 | PRJDB3785_S_NODE_18842_length_182_cov_1.563910_g18689_i0 | PRJDB3785 | 18842 | 182 | 1.56391 | 2.8463162 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 95.3 | 2.54e-15 | NTclustered | gi|1160573022|ref|XM_020576689.1| | 670386 | g18689 | i0 | 82.407 | 0.901098901098901 | 108 | 19 | 59 | 0 | 30 | 137 | 406 | 513 | Polysphondylium pallidum PN500 40S ribosomal protein S3 (rps3), partial mRNA | blastn | 164 | 95.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 2558828 | 2558828 | PRJDB3785_S_NODE_703_length_967_cov_6.190632_g630_i0 | PRJDB3785 | 703 | 967 | 6.190632 | 59.86341144 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 686 | 0 | NTclustered | gi|66820862|ref|XM_638894.1| | 352472 | g630 | i0 | 80.663 | 91.229576008273 | 905 | 157 | 93 | 18 | 72 | 967 | 1131 | 236 | Dictyostelium discoideum AX4 hypothetical protein (act20) mRNA, complete cds | blastn | 88219 | 686 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 3834913 | 3834913 | PRJDB3785_S_NODE_14024_length_206_cov_1.662420_g13871_i0 | PRJDB3785 | 14024 | 206 | 1.66242 | 3.4245852 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 270 | 4.569999999999999e-68 | NTclustered | gi|66820523|ref|XM_638773.1| | 352472 | g13871 | i0 | 90.338 | 92.9660194174757 | 207 | 18 | 100 | 2 | 1 | 206 | 214 | 9 | Dictyostelium discoideum AX4 hypothetical protein (act22) mRNA, complete cds | blastn | 19151 | 270 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 6387234 | 6387234 | PRJDB3785_S_NODE_7946_length_266_cov_2.589862_g7793_i0 | PRJDB3785 | 7946 | 266 | 2.589862 | 6.88903292 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 246 | 1.0399999999999999e-60 | NTclustered | gi|330793486|ref|XM_003284767.1| | 5786 | g7793 | i0 | 85.062 | 83.8947368421053 | 241 | 36 | 91 | 0 | 1 | 241 | 266 | 26 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_91392), mRNA | blastn | 22316 | 246 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 8935961 | 8935961 | PRJDB3785_S_NODE_9248_length_248_cov_2.175879_g9095_i0 | PRJDB3785 | 9248 | 248 | 2.175879 | 5.39617992 | Entamoeba dispar | 46681 | Evosea | other_Eukaryota | 202 | 2.0999999999999998e-47 | NTclustered | gi|167393182|ref|XM_001740406.1| | 370354 | g9095 | i0 | 85.864 | 72.8629032258064 | 191 | 25 | 77 | 2 | 59 | 248 | 469 | 280 | Entamoeba dispar SAW760 elongation factor 1-alpha (EDI_196620), partial mRNA | blastn | 18070 | 202 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 11184476 | 11184476 | PRJDB3785_S_NODE_17329_length_189_cov_1.092857_g17176_i0 | PRJDB3785 | 17329 | 189 | 1.092857 | 2.06549973 | Entamoeba | 5758 | Evosea | other_Eukaryota | 167 | 5.549999999999999e-37 | NTclustered | gi|158940|gb|L02417.1|ENHEF2 | 5759 | g17176 | i0 | 88.028 | 6.38095238095238 | 142 | 15 | 75 | 2 | 2 | 142 | 428 | 288 | Entamoeba histolytica translation elongation factor-2 (EF-2) mRNA, complete cds | blastn | 1206 | 167 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 12460377 | 12460377 | PRJDB3785_S_NODE_4630_length_353_cov_2.282895_g4477_i0 | PRJDB3785 | 4630 | 353 | 2.282895 | 8.05861935 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 167 | 1.14e-36 | NTclustered | gi|551445|emb|Z37981.1| | 44689 | g4477 | i0 | 88.652 | 4.38243626062323 | 141 | 10 | 46 | 4 | 8 | 142 | 3202 | 3342 | D.discoideum gene for protein kinase | blastn | 1547 | 167 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 16585564 | 16585564 | PRJDB3785_S_NODE_14214_length_205_cov_1.538462_g14061_i0 | PRJDB3785 | 14214 | 205 | 1.538462 | 3.1538471 | Schizoplasmodiopsis vulgaris | 435421 | Evosea | other_Eukaryota | 222 | 1.29e-53 | NTclustered | gi|159082997|gb|EF513198.1| | 435421 | g14061 | i0 | 86.341 | 76.1756097560976 | 205 | 26 | 99 | 2 | 1 | 204 | 249 | 46 | Schizoplasmodiopsis vulgaris elongation factor 1A (EF1A) gene, partial cds | blastn | 15616 | 222 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Schizoplasmodiopsis | Schizoplasmodiopsis vulgaris | |||
| 20409461 | 20409461 | PRJDB3785_S_NODE_24217_length_165_cov_1.974138_g24064_i0 | PRJDB3785 | 24217 | 165 | 1.974138 | 3.2573277 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 82.4 | 1.76e-11 | NTclustered | gi|831789132|ref|XM_012903508.1| | 1410327 | g24064 | i0 | 91.667 | 0.363636363636364 | 60 | 3 | 36 | 2 | 1 | 59 | 717 | 775 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 60 | 82.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 23933615 | 23933615 | PRJDB3785_S_NODE_24819_length_164_cov_1.773913_g24666_i0 | PRJDB3785 | 24819 | 164 | 1.773913 | 2.90921732 | Physarum | 5790 | Evosea | other_Eukaryota | 143 | 7.9e-30 | NTclustered | gi|2916681488|gb|PP948833.1| | 31288 | g24666 | i0 | 84.667 | 87.8841463414634 | 150 | 16 | 90 | 7 | 5 | 151 | 524 | 379 | Physarum sp. voucher HMJAU M20367-2 translation elongation factor 1-alpha (EF1A) gene, partial cds | blastn | 14413 | 143 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum sp. | ||
| 23933626 | 23933626 | PRJDB3785_S_NODE_9799_length_242_cov_1.098446_g9646_i0 | PRJDB3785 | 9799 | 242 | 1.098446 | 2.65823932 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 303 | 5.45e-78 | NTclustered | gi|167579|gb|M14146.1|DDIACT15 | 44689 | g9646 | i0 | 90.129 | 96.4586776859504 | 233 | 23 | 96 | 0 | 10 | 242 | 640 | 872 | D.discoideum actin 15 gene, complete cds | blastn | 23343 | 303 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum |
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);;