contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA685607" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 666283 | 666283 | PRJNA685607_P_NODE_28081_length_337_cov_1.079545_g27722_i0 | PRJNA685607 | 28081 | 337 | 1.079545 | 3.63806665 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 230 | 1.3699999999999995e-55 | NTclustered | gi|66803079|ref|XM_630291.1| | 352472 | g27722 | i0 | 80.936 | 2.86053412462908 | 299 | 49 | 88 | 8 | 1 | 295 | 30 | 324 | Dictyostelium discoideum AX4 S-adenosylmethionine synthetase (metK) mRNA, complete cds | blastn | 964 | 230 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 4494277 | 4494277 | PRJNA685607_P_NODE_53904_length_271_cov_0.929293_g53545_i0 | PRJNA685607 | 53904 | 271 | 0.929293 | 2.51838403 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 104 | 6.76e-18 | NTclustered | gi|330793266|ref|XM_003284658.1| | 5786 | g53545 | i0 | 87.778 | 0.763837638376384 | 90 | 9 | 33 | 2 | 35 | 123 | 1636 | 1724 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_53138), mRNA | blastn | 207 | 104 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 6280101 | 6280101 | PRJNA685607_P_NODE_14925_length_419_cov_1.777457_g14567_i0 | PRJNA685607 | 14925 | 419 | 1.777457 | 7.44754483 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 348 | 4.59e-91 | NTclustered | gi|290046|gb|L11588.1|DDIRACIA | 44689 | g14567 | i0 | 84.419 | 39.8472553699284 | 353 | 55 | 84 | 0 | 47 | 399 | 386 | 34 | Dictyostelium discoideum rac1A protein mRNA, complete cds | blastn | 16696 | 348 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 7045124 | 7045124 | PRJNA685607_P_NODE_81726_length_245_cov_3.581395_g81367_i0 | PRJNA685607 | 81726 | 245 | 3.581395 | 8.77441775 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 279 | 9.32e-71 | NTclustered | gi|330791385|ref|XM_003283726.1| | 5786 | g81367 | i0 | 88.085 | 92.5387755102041 | 235 | 28 | 96 | 0 | 11 | 245 | 10 | 244 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_91170), partial mRNA | blastn | 22672 | 279 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 8829366 | 8829366 | PRJNA685607_P_NODE_60547_length_258_cov_1.627027_g60188_i0 | PRJNA685607 | 60547 | 258 | 1.627027 | 4.19772966 | root | 1 | Root_unresolved | Root_unresolved | 477 | 3.2699999999999985e-130 | NTclustered | gi|1057487664|gb|KX539393.1| | 133408 | g60188 | i0 | 100 | 99.9883720930233 | 258 | 0 | 100 | 0 | 1 | 258 | 366 | 623 | Acytostelium leptosomum strain FG12A RNA polymerase I (rpa1) gene, partial cds | blastn | 25797 | 477 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium leptosomum | ||
| 9594928 | 9594928 | PRJNA685607_P_NODE_47288_length_284_cov_0.900474_g46929_i0 | PRJNA685607 | 47288 | 284 | 0.900474 | 2.55734616 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 346 | 1.07e-90 | NTclustered | gi|330799499|ref|XM_003287734.1| | 5786 | g46929 | i0 | 88.693 | 98.7711267605634 | 283 | 32 | 99 | 0 | 1 | 283 | 418 | 136 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_72359), partial mRNA | blastn | 28051 | 346 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 10870450 | 10870450 | PRJNA685607_P_NODE_78309_length_247_cov_0.885057_g77950_i0 | PRJNA685607 | 78309 | 247 | 0.885057 | 2.18609079 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 124 | 4.66e-24 | NTclustered | gi|470241167|ref|XM_004352107.1| | 261658 | g77950 | i0 | 82.517 | 0.578947368421053 | 143 | 23 | 57 | 2 | 106 | 247 | 584 | 443 | Cavenderia fasciculata 40S ribosomal protein S3 (rps3), partial mRNA | blastn | 143 | 124 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 12145760 | 12145760 | PRJNA685607_P_NODE_71490_length_249_cov_0.875000_g71131_i0 | PRJNA685607 | 71490 | 249 | 0.875 | 2.17875 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 200 | 7.61e-47 | NTclustered | gi|1160573488|ref|XM_020576922.1| | 670386 | g71131 | i0 | 81.377 | 3.54618473895582 | 247 | 44 | 99 | 2 | 2 | 247 | 137 | 382 | Polysphondylium pallidum PN500 Ras GTPase (rasG), partial mRNA | blastn | 883 | 200 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 14695290 | 14695290 | PRJNA685607_P_NODE_48032_length_282_cov_1.344498_g47673_i0 | PRJNA685607 | 48032 | 282 | 1.344498 | 3.79148436 | Didymium iridis | 5793 | Evosea | other_Eukaryota | 388 | 1.7499999999999998e-103 | NTclustered | gi|116010574|emb|AM407419.1| | 5793 | g47673 | i0 | 91.873 | 69.2446808510638 | 283 | 16 | 99 | 7 | 2 | 280 | 1225 | 946 | Didymium iridis partial 26S rRNA gene, isolate Pan3-3 | blastn | 19527 | 388 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis | ||
| 15204803 | 15204803 | PRJNA685607_P_NODE_13552_length_435_cov_1.676796_g13194_i0 | PRJNA685607 | 13552 | 435 | 1.676796 | 7.2940626 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 213 | 1.82e-50 | NTclustered | gi|167940|gb|M23750.1|DDIUBIQC | 44689 | g13194 | i0 | 83.406 | 62.2666666666667 | 229 | 38 | 53 | 0 | 1 | 229 | 1 | 229 | D.discoideum ubiquitin mRNA, complete cds, clone DCUBV20 | blastn | 27086 | 213 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 17244340 | 17244340 | PRJNA685607_P_NODE_6714_length_593_cov_2.184615_g6364_i0 | PRJNA685607 | 6714 | 593 | 2.184615 | 12.95476695 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 658 | 0 | NTclustered | gi|330791385|ref|XM_003283726.1| | 5786 | g6364 | i0 | 86.678 | 98.3389544688027 | 593 | 79 | 100 | 0 | 1 | 593 | 19 | 611 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_91170), partial mRNA | blastn | 58315 | 658 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 17244400 | 17244400 | PRJNA685607_P_NODE_78734_length_246_cov_3.323699_g78375_i0 | PRJNA685607 | 78734 | 246 | 3.323699 | 8.17629954 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 291 | 4.33e-74 | NTclustered | gi|330840543|ref|XM_003292226.1| | 5786 | g78375 | i0 | 88.936 | 91.6707317073171 | 235 | 26 | 96 | 0 | 12 | 246 | 24 | 258 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_92832), mRNA | blastn | 22551 | 291 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 18518363 | 18518363 | PRJNA685607_P_NODE_31535_length_325_cov_0.916667_g31176_i0 | PRJNA685607 | 31535 | 325 | 0.916667 | 2.97916775 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 222 | 2.1999999999999993e-53 | NTclustered | gi|831771569|ref|XM_012897887.1| | 1410327 | g31176 | i0 | 81.648 | 70.4276923076923 | 267 | 49 | 82 | 0 | 37 | 303 | 276 | 10 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 22889 | 222 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 21068650 | 21068650 | PRJNA685607_P_NODE_10057_length_491_cov_2.002392_g9701_i0 | PRJNA685607 | 10057 | 491 | 2.002392 | 9.83174472 | Stemonitopsis subcaespitosa | 1048528 | Evosea | other_Eukaryota | 634 | 3.739999999999999e-177 | NTclustered | gi|426281760|gb|JX681133.1| | 1048528 | g9701 | i0 | 91.361 | 86.7576374745418 | 463 | 40 | 94 | 0 | 22 | 484 | 6 | 468 | Stemonitopsis subcaespitosa actin gene, partial cds | blastn | 42598 | 634 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Stemonitopsis | Stemonitopsis subcaespitosa |
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);;