contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA915212" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2170594 | 2170594 | PRJNA915212_P_NODE_9522_length_188_cov_1.467626_g9484_i0 | PRJNA915212 | 9522 | 188 | 1.467626 | 2.75913688 | Synstelium polycarpum | 361085 | Evosea | other_Eukaryota | 113 | 7.290000000000001e-21 | NTclustered | gi|1057487789|gb|KX539455.1| | 361085 | g9484 | i0 | 85.849 | 34.968085106383 | 106 | 15 | 56 | 0 | 79 | 184 | 1901 | 1796 | Dictyostelium polycarpum strain OhioWILDS phosphoenolpyruvate carboxykinase (gtp) gene, complete cds | blastn | 6574 | 113 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Synstelium | Synstelium polycarpum | ||||
| 5079332 | 5079332 | PRJNA915212_P_NODE_9064_length_193_cov_1.416667_g9026_i0 | PRJNA915212 | 9064 | 193 | 1.416667 | 2.73416731 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 183 | 5.6499999999999996e-42 | NTclustered | gi|167787|gb|M26017.1|DDIEF2 | 44689 | g9026 | i0 | 85 | 4.88082901554404 | 180 | 27 | 93 | 0 | 1 | 180 | 1770 | 1591 | D.discoideum elongation factor 2 mRNA, complete cds | blastn | 942 | 183 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 7273394 | 7273394 | PRJNA915212_P_NODE_5806_length_245_cov_1.561224_g5768_i0 | PRJNA915212 | 5806 | 245 | 1.561224 | 3.8249988 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 132 | 2.76e-26 | NTclustered | gi|831792467|ref|XM_012904599.1| | 1410327 | g5768 | i0 | 80.702 | 16.0897959183673 | 171 | 31 | 69 | 2 | 42 | 211 | 344 | 513 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 3942 | 132 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 8903862 | 8903862 | PRJNA915212_P_NODE_11187_length_171_cov_1.254098_g11149_i0 | PRJNA915212 | 11187 | 171 | 1.254098 | 2.14450758 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 122 | 1.0799999999999999e-23 | NTclustered | gi|330844028|ref|XM_003293893.1| | 5786 | g11149 | i0 | 80.745 | 28.812865497076 | 161 | 27 | 93 | 4 | 12 | 170 | 316 | 474 | Dictyostelium purpureum S-adenosylmethionine synthetase (DICPUDRAFT_51206), mRNA | blastn | 4927 | 122 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 12374337 | 12374337 | PRJNA915212_P_NODE_9390_length_189_cov_2.300000_g9352_i0 | PRJNA915212 | 9390 | 189 | 2.3 | 4.347 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 87.9 | 4.45e-13 | NTclustered | gi|831788452|ref|XM_012903297.1| | 1410327 | g9352 | i0 | 79.688 | 0.677248677248677 | 128 | 20 | 66 | 5 | 65 | 189 | 1907 | 1783 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 128 | 87.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 17473313 | 17473313 | PRJNA915212_P_NODE_13914_length_163_cov_0.894737_g13876_i0 | PRJNA915212 | 13914 | 163 | 0.894737 | 1.45842131 | Mastigamoeba balamuthi | 108607 | Evosea | other_Eukaryota | 95.3 | 2.23e-15 | NTclustered | gi|148536468|gb|EF410004.1| | 108607 | g13876 | i0 | 87.805 | 1.48466257668712 | 82 | 8 | 50 | 2 | 1 | 81 | 1572 | 1492 | Mastigamoeba balamuthi chaperonin 60 (Cpn60) mRNA, complete cds | blastn | 242 | 95.3 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Mastigamoebidae | Mastigamoeba | Mastigamoeba balamuthi | |||
| 17828566 | 17828566 | PRJNA915212_P_NODE_8174_length_204_cov_0.987097_g8136_i0 | PRJNA915212 | 8174 | 204 | 0.987097 | 2.01367788 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 272 | 1.25e-68 | NTclustered | gi|426281754|gb|JX681130.1| | 289989 | g8136 | i0 | 91.045 | 98.5343137254902 | 201 | 18 | 99 | 0 | 4 | 204 | 806 | 606 | Didymium squamulosum actin gene, partial cds | blastn | 20101 | 272 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium squamulosum | ||
| 18746718 | 18746718 | PRJNA915212_P_NODE_2515_length_410_cov_1.576177_g2479_i0 | PRJNA915212 | 2515 | 410 | 1.576177 | 6.4623257 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 263 | 1.67e-65 | NTclustered | gi|831769224|ref|XM_012897186.1| | 1410327 | g2479 | i0 | 78.624 | 2.59756097560976 | 407 | 80 | 98 | 5 | 9 | 410 | 85 | 489 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 1065 | 263 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 21297095 | 21297095 | PRJNA915212_P_NODE_12617_length_165_cov_1.353448_g12579_i0 | PRJNA915212 | 12617 | 165 | 1.353448 | 2.2331892 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 76.8 | 8.19e-10 | NTclustered | gi|831762324|ref|XM_012895069.1| | 1410327 | g12579 | i0 | 77.465 | 5.03030303030303 | 142 | 23 | 84 | 7 | 2 | 140 | 496 | 631 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 830 | 76.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum |
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);;