contig_metadata
17 rows where bioproject = "PRJEB76780" and tax_clade = "Apusozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 138732 | 138732 | PRJEB76780_P_NODE_4421_length_387_cov_1.238854_g4321_i0 | PRJEB76780 | 4421 | 387 | 1.238854 | 4.79436498 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 189 | 2.7e-43 | NTclustered | gi|923126900|ref|XM_013901463.1| | 461836 | g4321 | i0 | 79.336 | 3.87855297157623 | 271 | 54 | 70 | 2 | 118 | 387 | 994 | 1263 | Thecamonas trahens ATCC 50062 serine/threonine-protein phosphatase 2A regulatory subunit pppA (AMSG_06862), partial mRNA | blastn | 1501 | 189 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 1413388 | 1413388 | PRJEB76780_P_NODE_2122_length_569_cov_6.885081_g2022_i0 | PRJEB76780 | 2122 | 569 | 6.885081 | 39.17611089 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 207 | 1.13e-48 | NTclustered | gi|923125359|ref|XM_013900694.1| | 461836 | g2022 | i0 | 81.712 | 9.5817223198594 | 257 | 39 | 44 | 6 | 195 | 447 | 277 | 529 | Thecamonas trahens ATCC 50062 calmodulin (AMSG_07687), mRNA | blastn | 5452 | 207 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 11617306 | 11617306 | PRJEB76780_P_NODE_550_length_1080_cov_4.658391_g491_i0 | PRJEB76780 | 550 | 1080 | 4.658391 | 50.3106228 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 431 | 1.2099999999999999e-115 | NTclustered | gi|923134252|ref|XM_013905138.1| | 461836 | g491 | i0 | 77.007 | 15.5962962962963 | 822 | 145 | 74 | 31 | 160 | 959 | 997 | 198 | Thecamonas trahens ATCC 50062 adenine nucleotide translocator (AMSG_02751), mRNA | blastn | 16844 | 431 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 23090759 | 23090759 | PRJEB76780_P_NODE_839_length_903_cov_4.239759_g761_i0 | PRJEB76780 | 839 | 903 | 4.239759 | 38.28502377 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 361 | 2.05e-121 | NR | XP_013760592.1 | 461836 | g761 | i0 | 66.1 | 0.930232558139535 | 280 | 90 | 92 | 3 | 1 | 831 | 63 | 340 | XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062] | diamond | 840 | 361 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 26970822 | 26970822 | PRJEB76780_P_NODE_12022_length_247_cov_0.896552_g11922_i0 | PRJEB76780 | 12022 | 247 | 0.896552 | 2.21448344 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 48.5 | 3.49e-4 | NR | XP_013753357.1 | 461836 | g11922 | i0 | 52.8 | 0.437246963562753 | 36 | 17 | 43.7 | 0 | 110 | 3 | 215 | 250 | XP_013753357.1 calmodulin [Thecamonas trahens ATCC 50062] | diamond | 108 | 48.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27058590 | 27058590 | PRJEB76780_P_NODE_4042_length_406_cov_1.405405_g3942_i0 | PRJEB76780 | 4042 | 406 | 1.405405 | 5.7059443 | root | 1 | Root_unresolved | Root_unresolved | 84.7 | 1.24e-16 | NR | XP_013761608.1 | 461836 | g3942 | i0 | 50 | 2.79310344827586 | 80 | 39 | 58.4 | 1 | 260 | 24 | 53 | 132 | XP_013761608.1 uncharacterized protein AMSG_01558 [Thecamonas trahens ATCC 50062] | diamond | 1134 | 85.1 | 0.995299647473561 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27382021 | 27382021 | PRJEB76780_P_NODE_4703_length_374_cov_2.003322_g4603_i0 | PRJEB76780 | 4703 | 374 | 2.003322 | 7.49242428 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 106 | 2.78e-27 | NR | XP_013753308.1 | 461836 | g4603 | i0 | 59.5 | 0.67379679144385 | 84 | 34 | 67.4 | 0 | 64 | 315 | 9 | 92 | XP_013753308.1 cystatin-B thiol proteinase inhibitor [Thecamonas trahens ATCC 50062] | diamond | 252 | 106 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27729606 | 27729606 | PRJEB76780_P_NODE_2924_length_481_cov_1.406863_g2824_i0 | PRJEB76780 | 2924 | 481 | 1.406863 | 6.76701103 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 47 | 0.0102 | NR | XP_013759479.1 | 461836 | g2824 | i0 | 53.8 | 0.324324324324324 | 52 | 23 | 31.8 | 1 | 433 | 281 | 1 | 52 | XP_013759479.1 uncharacterized protein AMSG_02572 [Thecamonas trahens ATCC 50062] | diamond | 156 | 47 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28297490 | 28297490 | PRJEB76780_P_NODE_6006_length_330_cov_0.894942_g5906_i0 | PRJEB76780 | 6006 | 330 | 0.894942 | 2.9533086 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 46.2 | 9.28e-4 | NR | XP_013760674.1 | 461836 | g5906 | i0 | 28.1 | 1.67272727272727 | 96 | 67 | 87.3 | 1 | 33 | 320 | 1 | 94 | XP_013760674.1 uncharacterized protein AMSG_02833 [Thecamonas trahens ATCC 50062] | diamond | 552 | 46.2 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28802490 | 28802490 | PRJEB76780_P_NODE_2068_length_578_cov_2.776238_g1969_i0 | PRJEB76780 | 2068 | 578 | 2.776238 | 16.04665564 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 103 | 2.99e-24 | NR | XP_013758370.1 | 461836 | g1969 | i0 | 40.3 | 0.773356401384083 | 149 | 81 | 77.3 | 2 | 549 | 103 | 8 | 148 | XP_013758370.1 uncharacterized protein AMSG_04698 [Thecamonas trahens ATCC 50062] | diamond | 447 | 103 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28897369 | 28897369 | PRJEB76780_P_NODE_5028_length_362_cov_1.349481_g4928_i0 | PRJEB76780 | 5028 | 362 | 1.349481 | 4.88512122 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 48.5 | 0.00126 | NR | XP_013758283.1 | 461836 | g4928 | i0 | 40.6 | 0.530386740331492 | 64 | 38 | 53 | 0 | 238 | 47 | 28 | 91 | XP_013758283.1 3-hydroxy-3-methylglutaryl-coenzyme A reductase 1 [Thecamonas trahens ATCC 50062] | diamond | 192 | 48.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30634378 | 30634378 | PRJEB76780_P_NODE_12533_length_245_cov_0.906977_g12433_i0 | PRJEB76780 | 12533 | 245 | 0.906977 | 2.22209365 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 47.8 | 6.75e-4 | NR | XP_013763169.1 | 461836 | g12433 | i0 | 43.8 | 0.783673469387755 | 64 | 34 | 78.4 | 2 | 204 | 13 | 1042 | 1103 | XP_013763169.1 uncharacterized protein AMSG_00313 [Thecamonas trahens ATCC 50062] | diamond | 192 | 47.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 30761029 | 30761029 | PRJEB76780_P_NODE_7074_length_304_cov_1.000000_g6974_i0 | PRJEB76780 | 7074 | 304 | 1 | 3.04 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 136 | 9.47e-35 | NR | XP_013760369.1 | 461836 | g6974 | i0 | 63.3 | 7.76644736842105 | 98 | 36 | 96.7 | 0 | 3 | 296 | 198 | 295 | XP_013760369.1 threonyl-tRNA synthetase [Thecamonas trahens ATCC 50062] | diamond | 2361 | 136 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31962365 | 31962365 | PRJEB76780_P_NODE_1918_length_600_cov_1.347249_g1819_i0 | PRJEB76780 | 1918 | 600 | 1.347249 | 8.083494 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 75.1 | 7.35e-12 | NR | XP_013762572.1 | 461836 | g1819 | i0 | 32.4 | 0.94 | 188 | 106 | 92 | 8 | 27 | 578 | 265 | 435 | XP_013762572.1 superoxide dismutase [Thecamonas trahens ATCC 50062] | diamond | 564 | 75.1 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32025759 | 32025759 | PRJEB76780_P_NODE_5078_length_360_cov_1.358885_g4978_i0 | PRJEB76780 | 5078 | 360 | 1.358885 | 4.891986 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 95.5 | 1.19e-21 | NR | XP_013752724.1 | 461836 | g4978 | i0 | 42.5 | 0.941666666666667 | 113 | 65 | 94.2 | 0 | 21 | 359 | 9 | 121 | XP_013752724.1 dual specificity protein phosphatase [Thecamonas trahens ATCC 50062] | diamond | 339 | 95.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32057306 | 32057306 | PRJEB76780_P_NODE_3558_length_434_cov_1.121884_g3458_i0 | PRJEB76780 | 3558 | 434 | 1.121884 | 4.86897656 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 48.5 | 0.00252 | NR | XP_013754178.1 | 461836 | g3458 | i0 | 34.7 | 0.497695852534562 | 72 | 46 | 49.1 | 1 | 412 | 200 | 447 | 518 | XP_013754178.1 uncharacterized protein AMSG_09624 [Thecamonas trahens ATCC 50062] | diamond | 216 | 48.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32310787 | 32310787 | PRJEB76780_P_NODE_5219_length_354_cov_2.807829_g5119_i0 | PRJEB76780 | 5219 | 354 | 2.807829 | 9.93971466 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 93.6 | 1.22e-19 | NR | XP_013760602.1 | 461836 | g5119 | i0 | 48.4 | 0.805084745762712 | 95 | 47 | 79.7 | 2 | 22 | 303 | 91 | 184 | XP_013760602.1 transcription factor lim1, variant [Thecamonas trahens ATCC 50062] | diamond | 285 | 93.6 | 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);;