contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA1011844" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 155738 | 155738 | PRJNA1011844_P_NODE_106641_length_310_cov_2.772152_g98068_i0 | PRJNA1011844 | 106641 | 310 | 2.772152 | 8.5936712 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 100 | 1.02e-16 | NTclustered | gi|330805894|ref|XM_003290864.1| | 5786 | g98068 | i0 | 87.5 | 1.05161290322581 | 88 | 10 | 28 | 1 | 11 | 97 | 209 | 122 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_81609), partial mRNA | blastn | 326 | 100 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 1431354 | 1431354 | PRJNA1011844_P_NODE_176042_length_211_cov_5.420290_g167460_i0 | PRJNA1011844 | 176042 | 211 | 5.42029 | 11.4368119 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 261 | 2.83e-65 | NTclustered | gi|66805384|ref|XM_631333.1| | 352472 | g167460 | i0 | 90.404 | 95.3696682464455 | 198 | 19 | 94 | 0 | 12 | 209 | 256 | 453 | Dictyostelium discoideum AX4 hypothetical protein (act4) mRNA, complete cds | blastn | 20123 | 261 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 7808819 | 7808819 | PRJNA1011844_P_NODE_151127_length_247_cov_3.545977_g142548_i0 | PRJNA1011844 | 151127 | 247 | 3.545977 | 8.75856319 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 228 | 3.4599999999999984e-55 | NTclustered | gi|15284027|dbj|AB070525.1| | 5791 | g142548 | i0 | 85.135 | 24.1174089068826 | 222 | 33 | 90 | 0 | 13 | 234 | 53 | 274 | Physarum polycephalum ub1 mRNA for ubiquitin 1, complete cds | blastn | 5957 | 228 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 7810427 | 7810427 | PRJNA1011844_P_NODE_88407_length_365_cov_2.003425_g79854_i0 | PRJNA1011844 | 88407 | 365 | 2.003425 | 7.31250125 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 52.8 | 0.035 | NTclustered | gi|330795121|ref|XM_003285576.1| | 5786 | g79854 | i0 | 100 | 0.0767123287671233 | 28 | 0 | 8 | 0 | 327 | 354 | 207 | 234 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_149504), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 8654997 | 8654997 | PRJNA1011844_P_NODE_134927_length_263_cov_2.689474_g126349_i0 | PRJNA1011844 | 134927 | 263 | 2.689474 | 7.07331662 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 198 | 2.9099999999999993e-46 | NTclustered | gi|501417115|gb|JX481323.1| | 1334539 | g126349 | i0 | 81.275 | 92.6882129277567 | 251 | 42 | 95 | 5 | 12 | 260 | 724 | 971 | Dianema inconspicuum voucher MM24067 elongation factor 1A (EF1A) gene, partial cds | blastn | 24377 | 200 | 0.99 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Dianemataceae | Dianema | Dianema inconspicuum | ||
| 10359498 | 10359498 | PRJNA1011844_P_NODE_155029_length_245_cov_0.895349_g146449_i0 | PRJNA1011844 | 155029 | 245 | 0.895349 | 2.19360505 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|66807354|ref|XM_632308.1| | 352472 | g146449 | i0 | 90.476 | 0.285714285714286 | 42 | 3 | 17 | 1 | 107 | 148 | 877 | 837 | Dictyostelium discoideum AX4 hypothetical protein (gtaN) mRNA, complete cds | blastn | 70 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 16732869 | 16732869 | PRJNA1011844_P_NODE_124454_length_277_cov_1.838235_g115877_i0 | PRJNA1011844 | 124454 | 277 | 1.838235 | 5.09191095 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 309 | 1.3700000000000003e-79 | NTclustered | gi|66805384|ref|XM_631333.1| | 352472 | g115877 | i0 | 87.925 | 94.3574007220217 | 265 | 29 | 96 | 3 | 12 | 276 | 260 | 521 | Dictyostelium discoideum AX4 hypothetical protein (act4) mRNA, complete cds | blastn | 26137 | 309 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 19281218 | 19281218 | PRJNA1011844_P_NODE_105176_length_313_cov_1.233333_g96604_i0 | PRJNA1011844 | 105176 | 313 | 1.233333 | 3.86033229 | Badhamia melanospora | 1346252 | Evosea | other_Eukaryota | 316 | 9.4e-82 | NTclustered | gi|1360488402|gb|MF352495.1| | 1346252 | g96604 | i0 | 86.054 | 77.4313099041534 | 294 | 41 | 94 | 0 | 11 | 304 | 473 | 766 | Badhamia melanospora strain MA-Fungi 87964 elongation factor 1 alpha (EF1A) gene, partial cds | blastn | 24236 | 316 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Badhamia | Badhamia melanospora | ||
| 19283142 | 19283142 | PRJNA1011844_P_NODE_64496_length_491_cov_4.600478_g56076_i0 | PRJNA1011844 | 64496 | 491 | 4.600478 | 22.58834698 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 254 | 1.22e-62 | NTclustered | gi|831777572|ref|XM_012899693.1| | 1410327 | g56076 | i0 | 82.807 | 54.4317718940937 | 285 | 47 | 58 | 2 | 197 | 480 | 6628 | 6345 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 26726 | 254 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 22679056 | 22679056 | PRJNA1011844_P_NODE_68538_length_462_cov_16.285347_g60081_i0 | PRJNA1011844 | 68538 | 462 | 16.285347 | 75.23830314 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 121 | 1.21e-22 | NTclustered | gi|7209|emb|X60270.1| | 44689 | g60081 | i0 | 85.484 | 5.46536796536797 | 124 | 9 | 29 | 3 | 252 | 366 | 155 | 32 | D.discoideum DdANN7 mRNA for annexin VII, partial cds | blastn | 2525 | 122 | 0.991803278688525 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 23108287 | 23108287 | PRJNA1011844_P_NODE_127199_length_273_cov_2.760000_g118621_i0 | PRJNA1011844 | 127199 | 273 | 2.76 | 7.5348 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 60.2 | 1.5e-4 | NTclustered | gi|831774435|ref|XM_012898758.1| | 1410327 | g118621 | i0 | 100 | 0.32967032967033 | 32 | 0 | 12 | 0 | 152 | 183 | 336 | 367 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 90 | 60.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 25227942 | 25227942 | PRJNA1011844_P_NODE_113100_length_295_cov_2.927928_g104524_i0 | PRJNA1011844 | 113100 | 295 | 2.927928 | 8.6373876 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 315 | 3.16e-81 | NTclustered | gi|167859713|gb|EU273436.1| | 1346289 | g104524 | i0 | 86.713 | 97.3491525423729 | 286 | 34 | 96 | 3 | 12 | 295 | 371 | 654 | Telaepolella tubasferens clone 2 actin gene, partial cds | blastn | 28718 | 315 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Telaepolella | Telaepolella tubasferens |
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);;