contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA752278" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 727576 | 727576 | PRJNA752278_P_NODE_49121_length_278_cov_1.453659_g48918_i0 | PRJNA752278 | 49121 | 278 | 1.453659 | 4.04117202 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 377 | 3.72e-100 | NTclustered | gi|330799499|ref|XM_003287734.1| | 5786 | g48918 | i0 | 91.304 | 100.363309352518 | 276 | 24 | 99 | 0 | 1 | 276 | 444 | 169 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_72359), partial mRNA | blastn | 27901 | 377 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 728242 | 728242 | PRJNA752278_P_NODE_83801_length_249_cov_0.875000_g83598_i0 | PRJNA752278 | 83801 | 249 | 0.875 | 2.17875 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 207 | 4.54e-49 | NTclustered | gi|1160561030|ref|XM_020578730.1| | 670386 | g83598 | i0 | 85.149 | 14.1726907630522 | 202 | 30 | 81 | 0 | 1 | 202 | 41 | 242 | Polysphondylium pallidum PN500 Ras GTPase (rapA), partial mRNA | blastn | 3529 | 207 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 2003411 | 2003411 | PRJNA752278_P_NODE_35762_length_291_cov_2.192661_g35559_i0 | PRJNA752278 | 35762 | 291 | 2.192661 | 6.38064351 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 75 | 5.75e-9 | NTclustered | gi|831771834|ref|XM_012897972.1| | 1410327 | g35559 | i0 | 95.652 | 10.8213058419244 | 46 | 2 | 16 | 0 | 244 | 289 | 251 | 296 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 3149 | 75 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 2004545 | 2004545 | PRJNA752278_P_NODE_96962_length_244_cov_0.900585_g96759_i0 | PRJNA752278 | 96962 | 244 | 0.900585 | 2.1974274 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|330841988|ref|XM_003292921.1| | 5786 | g96759 | i0 | 100 | 0.114754098360656 | 28 | 0 | 11 | 0 | 104 | 131 | 1039 | 1066 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_92967), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 4555920 | 4555920 | PRJNA752278_P_NODE_39344_length_287_cov_2.303738_g39141_i0 | PRJNA752278 | 39344 | 287 | 2.303738 | 6.61172806 | Cavostelium apophysatum | 435410 | Evosea | other_Eukaryota | 353 | 6.5e-93 | NTclustered | gi|146448837|gb|EF513185.1| | 435410 | g39141 | i0 | 90.875 | 85.1742160278746 | 263 | 24 | 92 | 0 | 25 | 287 | 1286 | 1024 | Cavostelium apophysatum elongation factor 1A (EF1A) gene, partial cds | blastn | 24445 | 353 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Cavostelium | Cavostelium apophysatum | ||
| 4556955 | 4556955 | PRJNA752278_P_NODE_99724_length_243_cov_0.905882_g99521_i0 | PRJNA752278 | 99724 | 243 | 0.905882 | 2.20129326 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 187 | 5.7499999999999985e-43 | NTclustered | gi|330840718|ref|XM_003292310.1| | 5786 | g99521 | i0 | 83.92 | 34.3292181069959 | 199 | 29 | 82 | 1 | 45 | 243 | 574 | 769 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_50380), mRNA | blastn | 8342 | 187 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 7107060 | 7107060 | PRJNA752278_P_NODE_88966_length_247_cov_0.885057_g88763_i0 | PRJNA752278 | 88966 | 247 | 0.885057 | 2.18609079 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|470252307|ref|XM_004359194.1| | 261658 | g88763 | i0 | 92.5 | 0.275303643724696 | 40 | 1 | 16 | 2 | 14 | 52 | 1322 | 1360 | Cavenderia fasciculata Dimethyladenosine transferase (DFA_01283), partial mRNA | blastn | 68 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 7578779 | 7578779 | PRJNA752278_P_NODE_31646_length_304_cov_2.303030_g31443_i0 | PRJNA752278 | 31646 | 304 | 2.30303 | 7.0012112 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.008 | NTclustered | gi|684937|gb|U20661.1|DDU20661 | 44689 | g31443 | i0 | 100 | 0.766447368421053 | 29 | 0 | 10 | 0 | 245 | 273 | 2650 | 2622 | Dictyostelium discoideum unknown internal repeat protein gene, complete cds, and unknown orf1, orf2 and orf3 genes, partial cds | blastn | 233 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 8380160 | 8380160 | PRJNA752278_P_NODE_12167_length_423_cov_2.537143_g11964_i0 | PRJNA752278 | 12167 | 423 | 2.537143 | 10.73211489 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 283 | 1.33e-71 | NTclustered | gi|831754628|ref|XM_012892721.1| | 1410327 | g11964 | i0 | 79.227 | 22.1891252955083 | 414 | 80 | 97 | 6 | 13 | 423 | 1302 | 892 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 9386 | 283 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 10129305 | 10129305 | PRJNA752278_P_NODE_1888_length_831_cov_2.257256_g1710_i0 | PRJNA752278 | 1888 | 831 | 2.257256 | 18.75779736 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 0.023 | NTclustered | gi|330796048|ref|XM_003286034.1| | 5786 | g1710 | i0 | 100 | 0.227436823104693 | 29 | 0 | 3 | 0 | 587 | 615 | 250 | 278 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_76975), partial mRNA | blastn | 189 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 13482385 | 13482385 | PRJNA752278_P_NODE_9911_length_456_cov_2.616188_g9708_i0 | PRJNA752278 | 9911 | 456 | 2.616188 | 11.92981728 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 261 | 6.750000000000001e-65 | NTclustered | gi|470260760|ref|XM_004360149.1| | 261658 | g9708 | i0 | 77.174 | 79.3311403508772 | 460 | 97 | 100 | 7 | 1 | 456 | 1058 | 603 | Cavenderia fasciculata elongation factor 1 alpha (efaAI), partial mRNA | blastn | 36175 | 261 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 14756539 | 14756539 | PRJNA752278_P_NODE_5072_length_580_cov_5.126233_g4871_i0 | PRJNA752278 | 5072 | 580 | 5.126233 | 29.7321514 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 58.4 | 0.001 | NTclustered | gi|831786499|ref|XM_012902675.1| | 1410327 | g4871 | i0 | 94.595 | 0.0637931034482759 | 37 | 2 | 6 | 0 | 387 | 423 | 426 | 462 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 37 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 14756900 | 14756900 | PRJNA752278_P_NODE_7052_length_515_cov_3.065611_g6849_i0 | PRJNA752278 | 7052 | 515 | 3.065611 | 15.78789665 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 58.4 | 0.001 | NTclustered | gi|831787734|ref|XM_012903072.1| | 1410327 | g6849 | i0 | 100 | 0.0601941747572816 | 31 | 0 | 6 | 0 | 256 | 286 | 1595 | 1565 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 31 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 14757300 | 14757300 | PRJNA752278_P_NODE_91632_length_246_cov_0.890173_g91429_i0 | PRJNA752278 | 91632 | 246 | 0.890173 | 2.18982558 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 237 | 5.72e-58 | NTclustered | gi|330842214|ref|XM_003293030.1| | 5786 | g91429 | i0 | 86.574 | 73.8943089430894 | 216 | 27 | 87 | 2 | 10 | 224 | 361 | 147 | Dictyostelium purpureum uncharacterized protein (rac1A), mRNA | blastn | 18178 | 237 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 21129660 | 21129660 | PRJNA752278_P_NODE_21357_length_347_cov_2.343066_g21154_i0 | PRJNA752278 | 21357 | 347 | 2.343066 | 8.13043902 | Entamoeba dispar | 46681 | Evosea | other_Eukaryota | 65.8 | 4.22e-6 | NTclustered | gi|167381181|ref|XM_001735557.1| | 370354 | g21154 | i0 | 95.122 | 1.85590778097983 | 41 | 2 | 12 | 0 | 74 | 114 | 232 | 192 | Entamoeba dispar SAW760 uncharacterized protein (EDI_096510), partial mRNA | blastn | 644 | 65.8 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 21129701 | 21129701 | PRJNA752278_P_NODE_23057_length_338_cov_1.241509_g22854_i0 | PRJNA752278 | 23057 | 338 | 1.241509 | 4.19630042 | Entamoeba nuttalli | 412467 | Evosea | other_Eukaryota | 63.9 | 1.47e-5 | NTclustered | gi|1653960324|dbj|LC436932.1| | 412467 | g22854 | i0 | 97.297 | 7.38165680473373 | 37 | 1 | 11 | 0 | 246 | 282 | 62 | 98 | Entamoeba nuttalli Thai-En-SRP-TYPE IV gene for serine rich protein, partial cds | blastn | 2495 | 63.9 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba nuttalli | |||
| 23680139 | 23680139 | PRJNA752278_P_NODE_25839_length_323_cov_2.792000_g25636_i0 | PRJNA752278 | 25839 | 323 | 2.792 | 9.01816 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 305 | 2.11e-78 | NTclustered | gi|470261707|ref|XM_004360422.1| | 261658 | g25636 | i0 | 84.277 | 76.0897832817337 | 318 | 44 | 98 | 6 | 1 | 315 | 699 | 1013 | Cavenderia fasciculata S-adenosylmethionine synthetase (metK), partial mRNA | blastn | 24577 | 305 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 23680254 | 23680254 | PRJNA752278_P_NODE_31819_length_304_cov_0.995671_g31616_i0 | PRJNA752278 | 31819 | 304 | 0.995671 | 3.02683984 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 172 | 2.08e-38 | NTclustered | gi|330797305|ref|XM_003286654.1| | 5786 | g31616 | i0 | 80.087 | 1.88486842105263 | 231 | 46 | 76 | 0 | 61 | 291 | 597 | 367 | Dictyostelium purpureum enoyl-CoA hydratase (DICPUDRAFT_54444), partial mRNA | blastn | 573 | 172 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 25427801 | 25427801 | PRJNA752278_P_NODE_71120_length_257_cov_1.646739_g70917_i0 | PRJNA752278 | 71120 | 257 | 1.646739 | 4.23211923 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|330800940|ref|XM_003288442.1| | 5786 | g70917 | i0 | 97.059 | 2.8715953307393 | 34 | 0 | 13 | 1 | 146 | 178 | 259 | 226 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_94663), partial mRNA | blastn | 738 | 56.5 | 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);;