contig_metadata
15 rows where bioproject = "PRJEB39643", tax_clade = "Apusozoa" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3884287 | 3884287 | PRJEB39643_P_NODE_54224_length_284_cov_1.459716_g54031_i0 | PRJEB39643 | 54224 | 284 | 1.459716 | 4.14559344 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 71.6 | 4.09e-12 | NR | XP_013761075.1 | 461836 | g54031 | i0 | 58.3 | 3.44366197183099 | 60 | 25 | 63.4 | 0 | 105 | 284 | 247 | 306 | XP_013761075.1 TKL/DRK protein kinase [Thecamonas trahens ATCC 50062] | diamond | 978 | 71.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 6435632 | 6435632 | PRJEB39643_P_NODE_133346_length_247_cov_1.770115_g133153_i0 | PRJEB39643 | 133346 | 247 | 1.770115 | 4.37218405 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 141 | 4.63e-29 | NTclustered | gi|923138958|ref|XM_013907490.1| | 461836 | g133153 | i0 | 82.53 | 55.4210526315789 | 166 | 23 | 66 | 6 | 10 | 172 | 2254 | 2416 | Thecamonas trahens ATCC 50062 plasma membrane calcium ATPase (AMSG_00078), partial mRNA | blastn | 13689 | 141 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 6435971 | 6435971 | PRJEB39643_P_NODE_18486_length_425_cov_2.980114_g18293_i0 | PRJEB39643 | 18486 | 425 | 2.980114 | 12.6654845 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 258 | 1.01e-76 | NR | XP_013759657.1 | 461836 | g18293 | i0 | 83 | 35.0611764705882 | 141 | 24 | 99.5 | 0 | 424 | 2 | 90 | 230 | XP_013759657.1 uncharacterized protein AMSG_03752 [Thecamonas trahens ATCC 50062] | diamond | 14901 | 258 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 12811258 | 12811258 | PRJEB39643_P_NODE_17511_length_437_cov_5.137363_g17318_i0 | PRJEB39643 | 17511 | 437 | 5.137363 | 22.45027631 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 219 | 5.3999999999999996e-70 | NR | XP_013755111.1 | 461836 | g17318 | i0 | 75.2 | 12.7620137299771 | 133 | 33 | 91.3 | 0 | 2 | 400 | 70 | 202 | XP_013755111.1 peroxiredoxin [Thecamonas trahens ATCC 50062] | diamond | 5577 | 219 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27286211 | 27286211 | PRJEB39643_P_NODE_105683_length_258_cov_3.210811_g105490_i0 | PRJEB39643 | 105683 | 258 | 3.210811 | 8.28389238 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 95.9 | 8.25e-21 | NR | XP_013759182.1 | 461836 | g105490 | i0 | 60.7 | 0.976744186046512 | 84 | 33 | 97.7 | 0 | 254 | 3 | 387 | 470 | XP_013759182.1 peptidase S8 and S53 domain-containing protein [Thecamonas trahens ATCC 50062] | diamond | 252 | 95.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28075639 | 28075639 | PRJEB39643_P_NODE_93625_length_264_cov_1.612565_g93432_i0 | PRJEB39643 | 93625 | 264 | 1.612565 | 4.2571716 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 77.4 | 2.82e-14 | NR | XP_013752865.1 | 461836 | g93432 | i0 | 51.3 | 0.863636363636364 | 76 | 35 | 84.1 | 2 | 223 | 2 | 78 | 153 | XP_013752865.1 Mboat2 protein [Thecamonas trahens ATCC 50062] | diamond | 228 | 77.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28581031 | 28581031 | PRJEB39643_P_NODE_44447_length_289_cov_1.425926_g44254_i0 | PRJEB39643 | 44447 | 289 | 1.425926 | 4.12092614 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 60.1 | 4.71e-8 | NR | XP_013757307.1 | 461836 | g44254 | i0 | 60.4 | 0.498269896193772 | 48 | 19 | 49.8 | 0 | 2 | 145 | 295 | 342 | XP_013757307.1 uncharacterized protein AMSG_11914 [Thecamonas trahens ATCC 50062] | diamond | 144 | 60.1 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29212601 | 29212601 | PRJEB39643_P_NODE_84369_length_269_cov_1.571429_g84176_i0 | PRJEB39643 | 84369 | 269 | 1.571429 | 4.22714401 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 74.7 | 2.82e-13 | NR | XP_013763132.1 | 461836 | g84176 | i0 | 38.5 | 1.01486988847584 | 91 | 54 | 99.3 | 1 | 1 | 267 | 115 | 205 | XP_013763132.1 uncharacterized protein AMSG_00274 [Thecamonas trahens ATCC 50062] | diamond | 273 | 74.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29780722 | 29780722 | PRJEB39643_P_NODE_96951_length_263_cov_1.621053_g96758_i0 | PRJEB39643 | 96951 | 263 | 1.621053 | 4.26336939 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 47.8 | 8.17e-4 | NR | XP_013762065.1 | 461836 | g96758 | i0 | 34.1 | 1.90494296577947 | 88 | 53 | 97 | 4 | 8 | 262 | 84 | 169 | XP_013762065.1 phospholipase C delta isoform [Thecamonas trahens ATCC 50062] | diamond | 501 | 47.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31044774 | 31044774 | PRJEB39643_P_NODE_130795_length_248_cov_1.760000_g130602_i0 | PRJEB39643 | 130795 | 248 | 1.76 | 4.3648 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 119 | 3e-29 | NR | XP_013754039.1 | 461836 | g130602 | i0 | 67.1 | 2.93951612903226 | 82 | 27 | 99.2 | 0 | 246 | 1 | 482 | 563 | XP_013754039.1 proline dehydrogenase 1 [Thecamonas trahens ATCC 50062] | diamond | 729 | 119 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31163921 | 31163921 | PRJEB39643_P_NODE_153775_length_232_cov_2.842767_g153582_i0 | PRJEB39643 | 153775 | 232 | 2.842767 | 6.59521944 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 71.2 | 2.95e-12 | NR | XP_013755517.1 | 461836 | g153582 | i0 | 50.6 | 4.06034482758621 | 77 | 37 | 98.3 | 1 | 2 | 229 | 520 | 596 | XP_013755517.1 fumarate reductase flavoprotein subunit [Thecamonas trahens ATCC 50062] | diamond | 942 | 71.6 | 0.994413407821229 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31487314 | 31487314 | PRJEB39643_P_NODE_17076_length_443_cov_4.864865_g16883_i0 | PRJEB39643 | 17076 | 443 | 4.864865 | 21.55135195 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 130 | 2.46e-34 | NR | XP_013761184.1 | 461836 | g16883 | i0 | 43.5 | 1.0902934537246 | 161 | 77 | 99.5 | 3 | 442 | 2 | 12 | 172 | XP_013761184.1 sterol-binding domain-containing protein [Thecamonas trahens ATCC 50062] | diamond | 483 | 130 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32246714 | 32246714 | PRJEB39643_P_NODE_41698_length_291_cov_3.486239_g41505_i0 | PRJEB39643 | 41698 | 291 | 3.486239 | 10.14495549 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 106 | 2.5499999999999998e-24 | NR | XP_013759182.1 | 461836 | g41505 | i0 | 55.1 | 1.01030927835052 | 98 | 40 | 97.9 | 2 | 287 | 3 | 207 | 303 | XP_013759182.1 peptidase S8 and S53 domain-containing protein [Thecamonas trahens ATCC 50062] | diamond | 294 | 106 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32563000 | 32563000 | PRJEB39643_P_NODE_20299_length_405_cov_1.855422_g20106_i0 | PRJEB39643 | 20299 | 405 | 1.855422 | 7.5144591 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 86.3 | 1.38e-16 | NR | XP_013762411.1 | 461836 | g20106 | i0 | 37.8 | 1 | 135 | 81 | 98.5 | 2 | 403 | 5 | 792 | 925 | XP_013762411.1 uncharacterized protein AMSG_00680 [Thecamonas trahens ATCC 50062] | diamond | 405 | 86.3 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32720258 | 32720258 | PRJEB39643_P_NODE_23460_length_376_cov_3.643564_g23267_i0 | PRJEB39643 | 23460 | 376 | 3.643564 | 13.69980064 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 78.2 | 6.72e-14 | NR | XP_013755131.1 | 461836 | g23267 | i0 | 53.8 | 0.518617021276596 | 65 | 30 | 51.9 | 0 | 167 | 361 | 498 | 562 | XP_013755131.1 uncharacterized protein AMSG_12189 [Thecamonas trahens ATCC 50062] | diamond | 195 | 78.2 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens |
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);;