contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA896758" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 872952 | 872952 | PRJNA896758_P_NODE_901_length_1225_cov_2.483507_g655_i0 | PRJNA896758 | 901 | 1225 | 2.483507 | 30.42296075 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 983 | 0 | NTclustered | gi|330802803|ref|XM_003289355.1| | 5786 | g655 | i0 | 82.562 | 91.216326530612207 | 1124 | 188 | 91 | 6 | 82 | 1201 | 1165 | 46 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_72679), mRNA | blastn | 111740 | 983 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 2148220 | 2148220 | PRJNA896758_P_NODE_26082_length_242_cov_0.911243_g25692_i0 | PRJNA896758 | 26082 | 242 | 0.911243 | 2.20520806 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|1160554624|ref|XM_020573137.1| | 670386 | g25692 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 29 | 56 | 51 | 24 | Polysphondylium pallidum PN500 hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 4701462 | 4701462 | PRJNA896758_P_NODE_5104_length_503_cov_2.090698_g4716_i0 | PRJNA896758 | 5104 | 503 | 2.090698 | 10.51621094 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 388 | 3.3e-103 | NTclustered | gi|66813933|ref|XM_636054.1| | 352472 | g4716 | i0 | 82.916 | 84.0954274353877 | 439 | 67 | 86 | 8 | 1 | 435 | 697 | 1131 | Dictyostelium discoideum AX4 hypothetical protein (act7) mRNA, complete cds | blastn | 42300 | 388 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 11076451 | 11076451 | PRJNA896758_P_NODE_6389_length_450_cov_2.220159_g5999_i0 | PRJNA896758 | 6389 | 450 | 2.220159 | 9.9907155 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 58.4 | 0.001 | NTclustered | gi|831763891|ref|XM_012895554.1| | 1410327 | g5999 | i0 | 100 | 0.315555555555556 | 31 | 0 | 7 | 0 | 173 | 203 | 839 | 869 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 142 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 14900726 | 14900726 | PRJNA896758_P_NODE_15132_length_294_cov_0.891403_g14742_i0 | PRJNA896758 | 15132 | 294 | 0.891403 | 2.62072482 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 63.9 | 1.26e-5 | NTclustered | gi|268637974|ref|XM_636093.2| | 352472 | g14742 | i0 | 91.304 | 0.27891156462585 | 46 | 4 | 16 | 0 | 141 | 186 | 2417 | 2372 | Dictyostelium discoideum AX4 ubiquitin system component Cue domain containing protein (ascc2) mRNA, complete cds | blastn | 82 | 63.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 14900742 | 14900742 | PRJNA896758_P_NODE_17632_length_276_cov_1.502463_g17242_i0 | PRJNA896758 | 17632 | 276 | 1.502463 | 4.14679788 | Nannengaella leucopus | 3231604 | Evosea | other_Eukaryota | 207 | 5.12e-49 | NTclustered | gi|2329703254|gb|MW239998.1| | 3231604 | g17242 | i0 | 80.882 | 19.286231884058 | 272 | 45 | 97 | 6 | 9 | 276 | 610 | 342 | Physarum leucopus strain MA-Fungi 68971 alpha tubulin (aTUB) gene, partial cds | blastn | 5323 | 207 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Nannengaella | Nannengaella leucopus | ||
| 21274677 | 21274677 | PRJNA896758_P_NODE_10317_length_356_cov_1.360424_g9927_i0 | PRJNA896758 | 10317 | 356 | 1.360424 | 4.84310944 | Rhizomastix varia | 1745347 | Evosea | other_Eukaryota | 403 | 8.07e-108 | NTclustered | gi|944556463|gb|KP343611.1| | 1745347 | g9927 | i0 | 87.079 | 99.1095505617977 | 356 | 46 | 100 | 0 | 1 | 356 | 576 | 221 | Rhizomastix varia strain FBAN clone 2 actin gene, partial cds | blastn | 35283 | 403 | 1 | Eukaryota | Amoebozoa | Evosea | Rhizomastix | Rhizomastix varia | |||||
| 23825072 | 23825072 | PRJNA896758_P_NODE_6439_length_448_cov_1.600000_g6049_i0 | PRJNA896758 | 6439 | 448 | 1.6 | 7.168 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|66820018|ref|XM_638571.1| | 352472 | g6049 | i0 | 100 | 0.254464285714286 | 30 | 0 | 7 | 0 | 48 | 77 | 744 | 773 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0275337) mRNA, complete cds | blastn | 114 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 24195422 | 24195422 | PRJNA896758_P_NODE_11099_length_344_cov_2.870849_g10709_i0 | PRJNA896758 | 11099 | 344 | 2.870849 | 9.87572056 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 377 | 4.73e-100 | NTclustered | gi|511084914|dbj|AK419690.1| | 5759 | g10709 | i0 | 87.021 | 98.375 | 339 | 38 | 98 | 4 | 1 | 336 | 66 | 401 | Entamoeba histolytica cDNA clone: Xeh-005H14, actin, putative, complete cds, strain: HM-1:IMSS | blastn | 33841 | 377 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica |
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);;