contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA906294" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2162041 | 2162041 | PRJNA906294_P_NODE_161742_length_296_cov_1.363229_g157626_i0 | PRJNA906294 | 161742 | 296 | 1.363229 | 4.03515784 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 165 | 3.38e-36 | NTclustered | gi|330802570|ref|XM_003289241.1| | 5786 | g157626 | i0 | 78.022 | 45.2060810810811 | 273 | 52 | 92 | 5 | 4 | 275 | 266 | 1 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_153633), partial mRNA | blastn | 13381 | 165 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 2162493 | 2162493 | PRJNA906294_P_NODE_181102_length_274_cov_1.512438_g176986_i0 | PRJNA906294 | 181102 | 274 | 1.512438 | 4.14408012 | Entamoeba invadens | 33085 | Evosea | other_Eukaryota | 52.8 | 0.025 | NTclustered | gi|471198668|ref|XM_004256185.1| | 370355 | g176986 | i0 | 100 | 0.102189781021898 | 28 | 0 | 10 | 0 | 11 | 38 | 1691 | 1718 | Entamoeba invadens IP1 trichohyalin, putative (EIN_390870) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba invadens | |||
| 2524212 | 2524212 | PRJNA906294_P_NODE_202322_length_253_cov_1.283333_g198206_i0 | PRJNA906294 | 202322 | 253 | 1.283333 | 3.24683249 | Physaraceae | 1115744 | Evosea | other_Eukaryota | 322 | 1.58e-83 | NTclustered | gi|440919833|gb|JX035984.2| | 1216084 | g198206 | i0 | 90.079 | 84.7826086956522 | 252 | 20 | 99 | 5 | 2 | 251 | 1562 | 1314 | Physarum sp. LE 255721 18S ribosomal RNA gene, partial sequence | blastn | 21450 | 324 | 0.993827160493827 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum sp. LE 255721 | ||
| 5076549 | 5076549 | PRJNA906294_P_NODE_158524_length_300_cov_1.339207_g154408_i0 | PRJNA906294 | 158524 | 300 | 1.339207 | 4.017621 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 65.8 | 3.58e-6 | NTclustered | gi|330795376|ref|XM_003285702.1| | 5786 | g154408 | i0 | 97.368 | 8.29333333333333 | 38 | 1 | 13 | 0 | 7 | 44 | 11325 | 11362 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_86857), partial mRNA | blastn | 2488 | 65.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 7264831 | 7264831 | PRJNA906294_P_NODE_161066_length_297_cov_1.281250_g156950_i0 | PRJNA906294 | 161066 | 297 | 1.28125 | 3.8053125 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 93.5 | 1.63e-14 | NTclustered | gi|470246255|ref|XM_004366224.1| | 261658 | g156950 | i0 | 83.333 | 0.62962962962963 | 102 | 15 | 34 | 2 | 43 | 143 | 524 | 624 | Cavenderia fasciculata heat shock protein Hsp90 family protein (hspD), partial mRNA | blastn | 187 | 93.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 8542873 | 8542873 | PRJNA906294_P_NODE_93427_length_437_cov_3.717033_g89313_i0 | PRJNA906294 | 93427 | 437 | 3.717033 | 16.24343421 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 281 | 4.95e-71 | NTclustered | gi|262262899|gb|FJ766442.1| | 472931 | g89313 | i0 | 78.652 | 59.7139588100686 | 445 | 79 | 100 | 13 | 1 | 437 | 1231 | 1667 | Protostelium mycophagum strain TB-A2-1 small subunit ribosomal RNA gene, partial sequence | blastn | 26095 | 281 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 10176966 | 10176966 | PRJNA906294_P_NODE_168088_length_288_cov_2.227907_g163972_i0 | PRJNA906294 | 168088 | 288 | 2.227907 | 6.41637216 | Physarum | 5790 | Evosea | other_Eukaryota | 446 | 1.05e-120 | NTclustered | gi|374255711|emb|HE614611.2| | 35220 | g163972 | i0 | 94.502 | 100.180555555556 | 291 | 13 | 100 | 2 | 1 | 288 | 2295 | 2005 | Physarum flavicomum partial 18S rRNA gene, strain UFF-6 | blastn | 28852 | 446 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum flavicomum | ||
| 12365547 | 12365547 | PRJNA906294_P_NODE_151670_length_309_cov_1.618644_g147554_i0 | PRJNA906294 | 151670 | 309 | 1.618644 | 5.00160996 | Perichaena dictyonema | 2951132 | Evosea | other_Eukaryota | 531 | 3.0399999999999998e-146 | NTclustered | gi|2250222210|gb|ON713340.1| | 2951132 | g147554 | i0 | 97.727 | 95.2621359223301 | 308 | 7 | 99 | 0 | 1 | 308 | 892 | 1199 | Perichaena dictyonema voucher MA59057 small subunit ribosomal RNA gene, partial sequence | blastn | 29436 | 531 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Trichiidae | Perichaena | Perichaena dictyonema | ||
| 13639012 | 13639012 | PRJNA906294_P_NODE_102631_length_407_cov_3.865269_g98516_i0 | PRJNA906294 | 102631 | 407 | 3.865269 | 15.73164483 | Didymium spongiosum | 289992 | Evosea | other_Eukaryota | 390 | 7.289999999999999e-104 | NTclustered | gi|2161226356|gb|MZ313554.1| | 289992 | g98516 | i0 | 84.275 | 37.7346437346437 | 407 | 54 | 99 | 5 | 1 | 406 | 5217 | 5614 | Mucilago crustacea 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 15358 | 390 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium spongiosum | ||
| 14913360 | 14913360 | PRJNA906294_P_NODE_107172_length_394_cov_9.657321_g103057_i0 | PRJNA906294 | 107172 | 394 | 9.657321 | 38.04984474 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 355 | 2.57e-93 | NTclustered | gi|262262903|gb|FJ766446.1| | 472931 | g103057 | i0 | 83.208 | 54.997461928934 | 399 | 55 | 99 | 11 | 3 | 393 | 400 | 6 | Protostelium mycophagum strain KEN-5A-2 small subunit ribosomal RNA gene, partial sequence | blastn | 21669 | 355 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 17463893 | 17463893 | PRJNA906294_P_NODE_115914_length_372_cov_4.986622_g111799_i0 | PRJNA906294 | 115914 | 372 | 4.986622 | 18.55023384 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 189 | 2.5799999999999998e-43 | NTclustered | gi|831768583|ref|XM_012896994.1| | 1410327 | g111799 | i0 | 78.667 | 11.7983870967742 | 300 | 53 | 80 | 6 | 30 | 328 | 314 | 25 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 4389 | 189 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 21289754 | 21289754 | PRJNA906294_P_NODE_208317_length_249_cov_0.863636_g204201_i0 | PRJNA906294 | 208317 | 249 | 0.863636 | 2.15045364 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 165 | 2.77e-36 | NTclustered | gi|330797568|ref|XM_003286784.1| | 5786 | g204201 | i0 | 80.088 | 12.8955823293173 | 226 | 41 | 90 | 3 | 26 | 249 | 656 | 433 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_150832), partial mRNA | blastn | 3211 | 165 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 21290350 | 21290350 | PRJNA906294_P_NODE_234097_length_228_cov_2.470968_g229981_i0 | PRJNA906294 | 234097 | 228 | 2.470968 | 5.63380704 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 180 | 8.94e-41 | NTclustered | gi|330842002|ref|XM_003292928.1| | 5786 | g229981 | i0 | 86.207 | 13.1973684210526 | 174 | 15 | 85 | 6 | 16 | 183 | 238 | 68 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_95723), partial mRNA | blastn | 3009 | 180 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 21292016 | 21292016 | PRJNA906294_P_NODE_99017_length_419_cov_1.202312_g94902_i0 | PRJNA906294 | 99017 | 419 | 1.202312 | 5.03768728 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 54.7 | 0.011 | NTclustered | gi|1160572212|ref|XM_020576284.1| | 670386 | g94902 | i0 | 100 | 0.0692124105011933 | 29 | 0 | 7 | 0 | 251 | 279 | 972 | 944 | Polysphondylium pallidum PN500 hypothetical protein partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 22565364 | 22565364 | PRJNA906294_P_NODE_231358_length_241_cov_0.904762_g227242_i0 | PRJNA906294 | 231358 | 241 | 0.904762 | 2.18047642 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 193 | 1.23e-44 | NTclustered | gi|330795360|ref|XM_003285694.1| | 5786 | g227242 | i0 | 88.199 | 62.6348547717842 | 161 | 19 | 67 | 0 | 81 | 241 | 1156 | 996 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_91566), mRNA | blastn | 15095 | 193 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 25114192 | 25114192 | PRJNA906294_P_NODE_223400_length_243_cov_2.458824_g219284_i0 | PRJNA906294 | 223400 | 243 | 2.458824 | 5.97494232 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 298 | 2.55e-76 | NTclustered | gi|3221|emb|V01159.1| | 5791 | g219284 | i0 | 91.667 | 6.22633744855967 | 216 | 16 | 88 | 2 | 13 | 227 | 2209 | 1995 | Physarum polycephalum gene encoding 5.8S rRNA and 26S rRNA | blastn | 1513 | 298 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum |
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);;