contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA533114" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1779929 | 1779929 | PRJNA533114_P_NODE_12902_length_630_cov_1.673250_g12659_i0 | PRJNA533114 | 12902 | 630 | 1.67325 | 10.541475 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 416 | 1.93e-111 | NTclustered | gi|923120664|ref|XM_013898350.1| | 461836 | g12659 | i0 | 84.856 | 57.6968253968254 | 416 | 59 | 66 | 4 | 217 | 630 | 1220 | 807 | Thecamonas trahens ATCC 50062 ATP-dependent RNA helicase eIF4A (AMSG_10343), partial mRNA | blastn | 36349 | 416 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 1780019 | 1780019 | PRJNA533114_P_NODE_17062_length_547_cov_5.613924_g16813_i0 | PRJNA533114 | 17062 | 547 | 5.613924 | 30.70816428 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 224 | 1.08e-53 | NTclustered | gi|923125359|ref|XM_013900694.1| | 461836 | g16813 | i0 | 82.879 | 12.180987202925 | 257 | 36 | 46 | 6 | 86 | 338 | 529 | 277 | Thecamonas trahens ATCC 50062 calmodulin (AMSG_07687), mRNA | blastn | 6663 | 224 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 1780734 | 1780734 | PRJNA533114_P_NODE_65542_length_295_cov_1.288288_g65290_i0 | PRJNA533114 | 65542 | 295 | 1.288288 | 3.8004496 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 132 | 3.42e-26 | NTclustered | gi|923123934|ref|XM_013899982.1| | 461836 | g65290 | i0 | 86.066 | 39.7728813559322 | 122 | 17 | 41 | 0 | 125 | 246 | 1267 | 1146 | Thecamonas trahens ATCC 50062 major vault protein (AMSG_08366), mRNA | blastn | 11733 | 132 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 5608257 | 5608257 | PRJNA533114_P_NODE_111005_length_244_cov_2.251462_g110753_i0 | PRJNA533114 | 111005 | 244 | 2.251462 | 5.49356728 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 172 | 1.62e-38 | NTclustered | gi|923124038|ref|XM_013900034.1| | 461836 | g110753 | i0 | 81.395 | 16.1762295081967 | 215 | 36 | 87 | 4 | 23 | 235 | 930 | 1142 | Thecamonas trahens ATCC 50062 seryl-tRNA synthetase (AMSG_08432), mRNA | blastn | 3947 | 172 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 8157837 | 8157837 | PRJNA533114_P_NODE_3247_length_1165_cov_3.614469_g3108_i0 | PRJNA533114 | 3247 | 1165 | 3.614469 | 42.10856385 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 110 | 6.95e-19 | NTclustered | gi|923121054|ref|XM_013898545.1| | 461836 | g3108 | i0 | 80 | 0.481545064377682 | 150 | 28 | 13 | 2 | 29 | 177 | 3761 | 3909 | Thecamonas trahens ATCC 50062 uncharacterized protein (AMSG_09969), partial mRNA | blastn | 561 | 110 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 8157944 | 8157944 | PRJNA533114_P_NODE_4007_length_1074_cov_10.257742_g3854_i0 | PRJNA533114 | 4007 | 1074 | 10.257742 | 110.16814908 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 409 | 5.62e-109 | NTclustered | gi|923134252|ref|XM_013905138.1| | 461836 | g3854 | i0 | 76.549 | 18.3175046554935 | 823 | 147 | 74 | 33 | 161 | 960 | 997 | 198 | Thecamonas trahens ATCC 50062 adenine nucleotide translocator (AMSG_02751), mRNA | blastn | 19673 | 409 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 13259296 | 13259296 | PRJNA533114_P_NODE_76011_length_277_cov_1.916667_g75759_i0 | PRJNA533114 | 76011 | 277 | 1.916667 | 5.30916759 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 178 | 4.029999999999999e-40 | NTclustered | gi|923133140|ref|XM_013904582.1| | 461836 | g75759 | i0 | 83.871 | 67.7184115523466 | 186 | 30 | 67 | 0 | 1 | 186 | 186 | 1 | Thecamonas trahens ATCC 50062 Ras-like protein rasG (AMSG_03185), partial mRNA | blastn | 18758 | 178 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 14533789 | 14533789 | PRJNA533114_P_NODE_31752_length_406_cov_2.228228_g31500_i0 | PRJNA533114 | 31752 | 406 | 2.228228 | 9.04660568 | Amastigomonas marina | 234594 | Root_unresolved | Root_unresolved | 377 | 5.66e-100 | NTclustered | gi|31982973|gb|AY236711.1| | 234594 | g31500 | i0 | 83.457 | 101.997536945813 | 405 | 67 | 99 | 0 | 1 | 405 | 1407 | 1003 | Amastigomonas marina heat shock protein 90 (Hsp90) gene, partial cds | blastn | 41411 | 377 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Amastigomonas | Amastigomonas marina | ||||
| 15807108 | 15807108 | PRJNA533114_P_NODE_111613_length_244_cov_0.900585_g111361_i0 | PRJNA533114 | 111613 | 244 | 0.900585 | 2.1974274 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 110 | 1.29e-19 | NTclustered | gi|923132782|ref|XM_013904403.1| | 461836 | g111361 | i0 | 86.275 | 0.909836065573771 | 102 | 12 | 41 | 2 | 120 | 220 | 418 | 318 | Thecamonas trahens ATCC 50062 60S ribosomal protein L23 (AMSG_03502), mRNA | blastn | 222 | 110 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 17083035 | 17083035 | PRJNA533114_P_NODE_87674_length_259_cov_1.897849_g87422_i0 | PRJNA533114 | 87674 | 259 | 1.897849 | 4.91542891 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 182 | 2.88e-41 | NTclustered | gi|923135134|ref|XM_013905579.1| | 461836 | g87422 | i0 | 84.699 | 18.2007722007722 | 183 | 26 | 70 | 2 | 78 | 259 | 246 | 65 | Thecamonas trahens ATCC 50062 60S ribosomal protein L27a (AMSG_02000), mRNA | blastn | 4714 | 182 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 19631614 | 19631614 | PRJNA533114_P_NODE_81496_length_269_cov_1.250000_g81244_i0 | PRJNA533114 | 81496 | 269 | 1.25 | 3.3625 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 56.5 | 0.002 | NTclustered | gi|923128178|ref|XM_013902102.1| | 461836 | g81244 | i0 | 100 | 0.643122676579926 | 30 | 0 | 11 | 0 | 77 | 106 | 577 | 548 | Thecamonas trahens ATCC 50062 uncharacterized protein (AMSG_06051), partial mRNA | blastn | 173 | 56.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 20907232 | 20907232 | PRJNA533114_P_NODE_45737_length_346_cov_1.908425_g45485_i0 | PRJNA533114 | 45737 | 346 | 1.908425 | 6.6031505 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 67.6 | 1.17e-6 | NTclustered | gi|923136249|ref|XM_013906136.1| | 461836 | g45485 | i0 | 97.436 | 1.85549132947977 | 39 | 1 | 11 | 0 | 68 | 106 | 863 | 825 | Thecamonas trahens ATCC 50062 uncharacterized protein (AMSG_01539), partial mRNA | blastn | 642 | 67.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 20907616 | 20907616 | PRJNA533114_P_NODE_81337_length_269_cov_1.571429_g81085_i0 | PRJNA533114 | 81337 | 269 | 1.571429 | 4.22714401 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 230 | 1.0599999999999998e-55 | NTclustered | gi|923126922|ref|XM_013901474.1| | 461836 | g81085 | i0 | 82.222 | 93.0669144981413 | 270 | 45 | 100 | 3 | 1 | 269 | 1051 | 784 | Thecamonas trahens ATCC 50062 26S protease regulatory subunit 6B (AMSG_06877), mRNA | blastn | 25035 | 230 | 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);;