contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA986481" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3524347 | 3524347 | PRJNA986481_P_NODE_49523_length_253_cov_0.990196_g48998_i0 | PRJNA986481 | 49523 | 253 | 0.990196 | 2.50519588 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|66807762|ref|XM_632512.1| | 352472 | g48998 | i0 | 100 | 0.110671936758893 | 28 | 0 | 11 | 0 | 170 | 197 | 483 | 456 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0286661) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 4801918 | 4801918 | PRJNA986481_P_NODE_7784_length_582_cov_2.553471_g7279_i0 | PRJNA986481 | 7784 | 582 | 2.553471 | 14.86120122 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 503 | 1.32e-137 | NTclustered | gi|330801204|ref|XM_003288572.1| | 5786 | g7279 | i0 | 84.423 | 72.4862542955326 | 520 | 72 | 88 | 8 | 23 | 537 | 19 | 534 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_92126), mRNA | blastn | 42187 | 503 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 6076796 | 6076796 | PRJNA986481_P_NODE_34785_length_277_cov_1.675439_g34260_i0 | PRJNA986481 | 34785 | 277 | 1.675439 | 4.64096603 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 172 | 1.87e-38 | NTclustered | gi|330793229|ref|XM_003284640.1| | 5786 | g34260 | i0 | 80.804 | 13.0902527075812 | 224 | 39 | 80 | 3 | 30 | 251 | 153 | 374 | Dictyostelium purpureum uncharacterized protein (rasD), mRNA | blastn | 3626 | 172 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 6077233 | 6077233 | PRJNA986481_P_NODE_6865_length_617_cov_3.975352_g6380_i0 | PRJNA986481 | 6865 | 617 | 3.975352 | 24.52792184 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 375 | 3.2e-99 | NTclustered | gi|1160573488|ref|XM_020576922.1| | 670386 | g6380 | i0 | 82.127 | 2.17179902755267 | 442 | 75 | 71 | 4 | 164 | 603 | 440 | 1 | Polysphondylium pallidum PN500 Ras GTPase (rasG), partial mRNA | blastn | 1340 | 375 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 10200658 | 10200658 | PRJNA986481_P_NODE_24908_length_329_cov_1.442857_g24383_i0 | PRJNA986481 | 24908 | 329 | 1.442857 | 4.74699953 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 259 | 1.7e-64 | NTclustered | gi|290042|gb|L11593.1|DDIRACC | 44689 | g24383 | i0 | 83.103 | 3.19452887537994 | 290 | 43 | 87 | 6 | 3 | 289 | 350 | 64 | Slime mold RacC protein mRNA, complete cds | blastn | 1051 | 259 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 11176541 | 11176541 | PRJNA986481_P_NODE_11049_length_493_cov_1.574324_g10526_i0 | PRJNA986481 | 11049 | 493 | 1.574324 | 7.76141732 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 58.4 | 0.001 | NTclustered | gi|470249668|ref|XM_004367009.1| | 261658 | g10526 | i0 | 97.059 | 0.275862068965517 | 34 | 1 | 7 | 0 | 276 | 309 | 1103 | 1136 | Cavenderia fasciculata uncharacterized protein (DFA_07200), partial mRNA | blastn | 136 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 11176755 | 11176755 | PRJNA986481_P_NODE_24109_length_334_cov_1.740351_g23584_i0 | PRJNA986481 | 24109 | 334 | 1.740351 | 5.81277234 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 60.2 | 1.88e-4 | NTclustered | gi|330798009|ref|XM_003287001.1| | 5786 | g23584 | i0 | 91.111 | 0.221556886227545 | 45 | 2 | 13 | 2 | 117 | 160 | 2018 | 2061 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_47162), mRNA | blastn | 74 | 60.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 12751464 | 12751464 | PRJNA986481_P_NODE_8150_length_570_cov_1.971209_g7644_i0 | PRJNA986481 | 8150 | 570 | 1.971209 | 11.2358913 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 62.1 | 9.34e-5 | NTclustered | gi|3406653|gb|AF079369.1| | 44689 | g7644 | i0 | 97.222 | 0.126315789473684 | 36 | 1 | 6 | 0 | 304 | 339 | 1185 | 1150 | Dictyostelium discoideum transcriptional repressor TUP1 mRNA, complete cds | blastn | 72 | 62.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 13726857 | 13726857 | PRJNA986481_P_NODE_14291_length_434_cov_1.148052_g13766_i0 | PRJNA986481 | 14291 | 434 | 1.148052 | 4.98254568 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 115 | 5.27e-21 | NTclustered | gi|831757464|ref|XM_012893584.1| | 1410327 | g13766 | i0 | 79.503 | 1.21428571428571 | 161 | 33 | 37 | 0 | 28 | 188 | 352 | 512 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 527 | 115 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 17551176 | 17551176 | PRJNA986481_P_NODE_174_length_2033_cov_4.011593_g135_i0 | PRJNA986481 | 174 | 2033 | 4.011593 | 81.55568569 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 942 | 0 | NTclustered | gi|330818764|ref|XM_003291461.1| | 5786 | g135 | i0 | 77.708 | 71.6207575012297 | 1588 | 323 | 77 | 28 | 460 | 2033 | 1623 | 53 | Dictyostelium purpureum heat shock protein (DICPUDRAFT_49867), partial mRNA | blastn | 145605 | 942 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 18825151 | 18825151 | PRJNA986481_P_NODE_24415_length_332_cov_1.837456_g23890_i0 | PRJNA986481 | 24415 | 332 | 1.837456 | 6.10035392 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 54.7 | 0.009 | NTclustered | gi|831777879|ref|XM_012899786.1| | 1410327 | g23890 | i0 | 100 | 0.620481927710843 | 29 | 0 | 9 | 0 | 30 | 58 | 481 | 509 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 206 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 20099991 | 20099991 | PRJNA986481_P_NODE_31576_length_291_cov_1.429752_g31051_i0 | PRJNA986481 | 31576 | 291 | 1.429752 | 4.16057832 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|330802135|ref|XM_003289028.1| | 5786 | g31051 | i0 | 100 | 0.0996563573883162 | 29 | 0 | 10 | 0 | 152 | 180 | 47 | 75 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_35083), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 21375327 | 21375327 | PRJNA986481_P_NODE_11237_length_489_cov_2.270455_g10714_i0 | PRJNA986481 | 11237 | 489 | 2.270455 | 11.10252495 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 71.3 | 1.32e-7 | NTclustered | gi|470263871|ref|XM_004360983.1| | 261658 | g10714 | i0 | 83.784 | 0.331288343558282 | 74 | 12 | 15 | 0 | 207 | 280 | 1834 | 1907 | Cavenderia fasciculata dihydrolipoamide acetyltransferase (pdhC), partial mRNA | blastn | 162 | 71.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 21375661 | 21375661 | PRJNA986481_P_NODE_32957_length_285_cov_1.148305_g32432_i0 | PRJNA986481 | 32957 | 285 | 1.148305 | 3.27266925 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 169 | 2.5099999999999996e-37 | NTclustered | gi|66818990|ref|XM_638063.1| | 352472 | g32432 | i0 | 77.544 | 1 | 285 | 61 | 99 | 3 | 2 | 285 | 421 | 139 | Dictyostelium discoideum AX4 heat shock protein Hsp70 family protein (DDB_G0276445) mRNA, complete cds | blastn | 285 | 169 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 22650289 | 22650289 | PRJNA986481_P_NODE_13618_length_444_cov_2.483544_g13094_i0 | PRJNA986481 | 13618 | 444 | 2.483544 | 11.02693536 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 274 | 8.42e-69 | NTclustered | gi|470252539|ref|XM_004359310.1| | 261658 | g13094 | i0 | 79.052 | 52.0135135135135 | 401 | 82 | 90 | 2 | 45 | 444 | 523 | 124 | Cavenderia fasciculata ADP-ribosylation factor (arfA), partial mRNA | blastn | 23094 | 274 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata |
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);;