contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA1022139" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 161601 | 161601 | PRJNA1022139_P_NODE_23241_length_291_cov_1.862385_g23136_i0 | PRJNA1022139 | 23241 | 291 | 1.862385 | 5.41954035 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 219 | 2.5099999999999998e-52 | NTclustered | gi|330791897|ref|XM_003283980.1| | 5786 | g23136 | i0 | 80.546 | 35.1099656357388 | 293 | 50 | 100 | 5 | 1 | 291 | 1351 | 1064 | Dictyostelium purpureum 26S proteasome ATPase 2 subunit (DICPUDRAFT_96551), mRNA | blastn | 10217 | 219 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 1003641 | 1003641 | PRJNA1022139_P_NODE_43701_length_230_cov_2.872611_g43596_i0 | PRJNA1022139 | 43701 | 230 | 2.872611 | 6.6070053 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 154 | 5.47e-33 | NTclustered | gi|330791827|ref|XM_003283945.1| | 5786 | g43596 | i0 | 85.235 | 63.6 | 149 | 22 | 65 | 0 | 44 | 192 | 1258 | 1110 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_52641), mRNA | blastn | 14628 | 154 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 3988332 | 3988332 | PRJNA1022139_P_NODE_39544_length_245_cov_0.895349_g39439_i0 | PRJNA1022139 | 39544 | 245 | 0.895349 | 2.19360505 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|66823122|ref|XM_639824.1| | 352472 | g39439 | i0 | 100 | 0.628571428571429 | 29 | 0 | 12 | 0 | 145 | 173 | 1711 | 1683 | Dictyostelium discoideum AX4 RhoGAP domain-containing protein (gacU) mRNA, complete cds | blastn | 154 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 4831580 | 4831580 | PRJNA1022139_P_NODE_14144_length_362_cov_1.598616_g14039_i0 | PRJNA1022139 | 14144 | 362 | 1.598616 | 5.78698992 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 58.4 | 7.38e-4 | NTclustered | gi|330791506|ref|XM_003283786.1| | 5786 | g14039 | i0 | 92.5 | 1.36740331491713 | 40 | 3 | 11 | 0 | 203 | 242 | 6288 | 6327 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_45096), partial mRNA | blastn | 495 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 6539934 | 6539934 | PRJNA1022139_P_NODE_37906_length_247_cov_0.885057_g37801_i0 | PRJNA1022139 | 37906 | 247 | 0.885057 | 2.18609079 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|19570867|dbj|AB049419.1| | 5791 | g37801 | i0 | 100 | 0.34412955465587 | 29 | 0 | 12 | 0 | 158 | 186 | 575 | 547 | Physarum polycephalum Glom mRNA for mitochondrial DNA packaging protein, complete cds | blastn | 85 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 9089111 | 9089111 | PRJNA1022139_P_NODE_12648_length_380_cov_1.130293_g12543_i0 | PRJNA1022139 | 12648 | 380 | 1.130293 | 4.2951134 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 250 | 1.2e-61 | NTclustered | gi|831769224|ref|XM_012897186.1| | 1410327 | g12543 | i0 | 78.701 | 9.14210526315789 | 385 | 75 | 100 | 5 | 1 | 380 | 541 | 159 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 3474 | 250 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 12915320 | 12915320 | PRJNA1022139_P_NODE_22611_length_295_cov_1.585586_g22506_i0 | PRJNA1022139 | 22611 | 295 | 1.585586 | 4.6774787 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 87.9 | 7.51e-13 | NTclustered | gi|831788452|ref|XM_012903297.1| | 1410327 | g22506 | i0 | 89.706 | 0.230508474576271 | 68 | 7 | 23 | 0 | 94 | 161 | 1840 | 1907 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 68 | 87.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 15031284 | 15031284 | PRJNA1022139_P_NODE_10232_length_416_cov_7.002915_g10127_i0 | PRJNA1022139 | 10232 | 416 | 7.002915 | 29.1321264 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 255 | 2.84e-63 | NTclustered | gi|167938|gb|M23749.1|DDIUBIQB | 44689 | g10127 | i0 | 79.944 | 73.4254807692308 | 359 | 63 | 86 | 9 | 3 | 358 | 33 | 385 | D.discoideum ubiquitin mRNA, complete cds, clone DCUBV45 | blastn | 30545 | 255 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 15464366 | 15464366 | PRJNA1022139_P_NODE_27093_length_277_cov_1.720588_g26988_i0 | PRJNA1022139 | 27093 | 277 | 1.720588 | 4.76602876 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 82.4 | 3.25e-11 | NTclustered | gi|470262764|ref|XM_004360714.1| | 261658 | g26988 | i0 | 90.323 | 6.86642599277978 | 62 | 6 | 22 | 0 | 123 | 184 | 258 | 197 | Cavenderia fasciculata uncharacterized protein (DFA_05050), partial mRNA | blastn | 1902 | 82.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 15464450 | 15464450 | PRJNA1022139_P_NODE_3753_length_651_cov_2.356401_g3649_i0 | PRJNA1022139 | 3753 | 651 | 2.356401 | 15.34017051 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 320 | 1.61e-82 | NTclustered | gi|470266348|ref|XM_004361672.1| | 261658 | g3649 | i0 | 79.642 | 18.2718894009217 | 447 | 89 | 69 | 2 | 2 | 447 | 328 | 773 | Cavenderia fasciculata Rab GTPase (rab7A), partial mRNA | blastn | 11895 | 320 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 15464518 | 15464518 | PRJNA1022139_P_NODE_7133_length_491_cov_2.966507_g7028_i0 | PRJNA1022139 | 7133 | 491 | 2.966507 | 14.56554937 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 73.1 | 3.68e-8 | NTclustered | gi|330790854|ref|XM_003283463.1| | 5786 | g7028 | i0 | 76.19 | 0.378818737270876 | 147 | 29 | 30 | 4 | 269 | 415 | 392 | 252 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_93471), partial mRNA | blastn | 186 | 73.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 16306009 | 16306009 | PRJNA1022139_P_NODE_14133_length_362_cov_1.847751_g14028_i0 | PRJNA1022139 | 14133 | 362 | 1.847751 | 6.68885862 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 329 | 1.42e-85 | NTclustered | gi|330792727|ref|XM_003284391.1| | 5786 | g14028 | i0 | 84.848 | 92.2430939226519 | 330 | 46 | 91 | 4 | 1 | 328 | 75 | 402 | Dictyostelium purpureum elongation factor 1 alpha (DICPUDRAFT_52946), mRNA | blastn | 33392 | 331 | 0.993957703927492 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 18013449 | 18013449 | PRJNA1022139_P_NODE_23955_length_288_cov_2.506977_g23850_i0 | PRJNA1022139 | 23955 | 288 | 2.506977 | 7.22009376 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|330845282|ref|XM_003294474.1| | 5786 | g23850 | i0 | 100 | 0.0972222222222222 | 28 | 0 | 10 | 0 | 247 | 274 | 142 | 115 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_159528), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 18013468 | 18013468 | PRJNA1022139_P_NODE_26415_length_280_cov_1.159420_g26310_i0 | PRJNA1022139 | 26415 | 280 | 1.15942 | 3.246376 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 167 | 8.83e-37 | NTclustered | gi|831768525|ref|XM_012896976.1| | 1410327 | g26310 | i0 | 77.899 | 1.98214285714286 | 276 | 55 | 98 | 3 | 7 | 279 | 921 | 649 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 555 | 167 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 19287210 | 19287210 | PRJNA1022139_P_NODE_11116_length_401_cov_2.743902_g11011_i0 | PRJNA1022139 | 11116 | 401 | 2.743902 | 11.00304702 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 287 | 9.68e-73 | NTclustered | gi|330822624|ref|XM_003291701.1| | 5786 | g11011 | i0 | 80 | 22.9551122194514 | 395 | 73 | 98 | 4 | 10 | 401 | 261 | 652 | Dictyostelium purpureum vacuolar H+ ATPase B subunit (DICPUDRAFT_50012), mRNA | blastn | 9205 | 287 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 21838452 | 21838452 | PRJNA1022139_P_NODE_24058_length_288_cov_1.432558_g23953_i0 | PRJNA1022139 | 24058 | 288 | 1.432558 | 4.12576704 | Fuligo septica | 159720 | Evosea | other_Eukaryota | 220 | 6.8999999999999985e-53 | NTclustered | gi|2329703162|gb|MW239946.1| | 647295 | g23953 | i0 | 80.208 | 19.2708333333333 | 288 | 53 | 99 | 4 | 1 | 286 | 72 | 357 | Fuligo septica var. flava strain MA-Fungi 78792 alpha tubulin (aTUB) gene, partial cds | blastn | 5550 | 220 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Fuligo | Fuligo septica |
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);;