contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJEB64798" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5231840 | 5231840 | PRJEB64798_P_NODE_61545_length_248_cov_3.929648_g59780_i0 | PRJEB64798 | 61545 | 248 | 3.929648 | 9.74552704 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 118 | 5.0899999999999994e-30 | NR | XP_013760592.1 | 461836 | g59780 | i0 | 75.3 | 2.96370967741935 | 81 | 20 | 98 | 0 | 244 | 2 | 118 | 198 | XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062] | diamond | 735 | 118 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 6506253 | 6506253 | PRJEB64798_P_NODE_210626_length_164_cov_10.130435_g208860_i0 | PRJEB64798 | 210626 | 164 | 10.130435 | 16.6139134 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 82 | 3.48e-17 | NR | XP_013758080.1 | 461836 | g208860 | i0 | 67.9 | 0.969512195121951 | 53 | 17 | 97 | 0 | 161 | 3 | 124 | 176 | XP_013758080.1 60S ribosomal protein L8 [Thecamonas trahens ATCC 50062] | diamond | 159 | 82 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 9055488 | 9055488 | PRJEB64798_P_NODE_224908_length_160_cov_14.621622_g223142_i0 | PRJEB64798 | 224908 | 160 | 14.621622 | 23.3945952 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 52.8 | 3.41e-6 | NR | XP_013754989.1 | 461836 | g223142 | i0 | 69.7 | 0.61875 | 33 | 10 | 61.9 | 0 | 159 | 61 | 152 | 184 | XP_013754989.1 rRNA 2'-O-methyltransferase fibrillarin [Thecamonas trahens ATCC 50062] | diamond | 99 | 52.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 23080949 | 23080949 | PRJEB64798_P_NODE_45639_length_291_cov_3.024793_g43874_i0 | PRJEB64798 | 45639 | 291 | 3.024793 | 8.80214763 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 139 | 9.13e-38 | NR | XP_013760592.1 | 461836 | g43874 | i0 | 72.3 | 0.969072164948454 | 94 | 26 | 96.9 | 0 | 283 | 2 | 161 | 254 | XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062] | diamond | 282 | 139 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 26678414 | 26678414 | PRJEB64798_P_NODE_59081_length_253_cov_11.480392_g57316_i0 | PRJEB64798 | 59081 | 253 | 11.480392 | 29.04539176 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 108 | 1.73e-26 | NR | XP_013757165.1 | 461836 | g57316 | i0 | 64.6 | 4.86166007905138 | 82 | 29 | 97.2 | 0 | 6 | 251 | 93 | 174 | XP_013757165.1 L10e/P0 [Thecamonas trahens ATCC 50062] | diamond | 1230 | 108 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 26748433 | 26748433 | PRJEB64798_P_NODE_196001_length_168_cov_6.865546_g194235_i0 | PRJEB64798 | 196001 | 168 | 6.865546 | 11.53411728 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 64.7 | 2.37e-10 | NR | XP_013754784.1 | 461836 | g194235 | i0 | 51.9 | 1.91071428571429 | 54 | 26 | 96.4 | 0 | 2 | 163 | 524 | 577 | XP_013754784.1 major vault protein [Thecamonas trahens ATCC 50062] | diamond | 321 | 64.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27001916 | 27001916 | PRJEB64798_P_NODE_227742_length_159_cov_10.290909_g225976_i0 | PRJEB64798 | 227742 | 159 | 10.290909 | 16.36254531 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 45.8 | 9.68e-4 | NR | XP_013761543.1 | 461836 | g225976 | i0 | 37.3 | 0.962264150943396 | 51 | 29 | 90.6 | 1 | 15 | 158 | 2868 | 2918 | XP_013761543.1 dynein heavy chain 2 [Thecamonas trahens ATCC 50062] | diamond | 153 | 45.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 27286612 | 27286612 | PRJEB64798_P_NODE_192083_length_169_cov_9.391667_g190317_i0 | PRJEB64798 | 192083 | 169 | 9.391667 | 15.87191723 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 49.7 | 4.9e-5 | NR | XP_013759968.1 | 461836 | g190317 | i0 | 44.1 | 1.04733727810651 | 59 | 28 | 95.9 | 1 | 4 | 165 | 222 | 280 | XP_013759968.1 flavohemoprotein [Thecamonas trahens ATCC 50062] | diamond | 177 | 49.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28455233 | 28455233 | PRJEB64798_P_NODE_35906_length_329_cov_8.900000_g34148_i0 | PRJEB64798 | 35906 | 329 | 8.9 | 29.281 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 64.7 | 1.63e-9 | NR | XP_013753886.1 | 461836 | g34148 | i0 | 39.5 | 0.78419452887538 | 86 | 49 | 78.4 | 1 | 269 | 12 | 21 | 103 | XP_013753886.1 cysteine proteinase 1 [Thecamonas trahens ATCC 50062] | diamond | 258 | 64.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29086654 | 29086654 | PRJEB64798_P_NODE_28648_length_368_cov_2.840125_g26892_i0 | PRJEB64798 | 28648 | 368 | 2.840125 | 10.45166 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 45.4 | 0.018 | NR | XP_013757898.1 | 461836 | g26892 | i0 | 28.6 | 0.970108695652174 | 119 | 78 | 92.9 | 4 | 360 | 19 | 772 | 888 | XP_013757898.1 uncharacterized protein AMSG_05495 [Thecamonas trahens ATCC 50062] | diamond | 357 | 45.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29339010 | 29339010 | PRJEB64798_P_NODE_110069_length_210_cov_5.888199_g108303_i0 | PRJEB64798 | 110069 | 210 | 5.888199 | 12.3652179 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 46.6 | 0.00108 | NR | XP_013753128.1 | 461836 | g108303 | i0 | 39.7 | 0.828571428571429 | 58 | 23 | 82.9 | 1 | 35 | 208 | 3979 | 4024 | XP_013753128.1 dynein heavy chain [Thecamonas trahens ATCC 50062] | diamond | 174 | 46.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31170883 | 31170883 | PRJEB64798_P_NODE_132435_length_197_cov_4.722973_g130669_i0 | PRJEB64798 | 132435 | 197 | 4.722973 | 9.30425681 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 89 | 2.33e-20 | NR | XP_013757499.1 | 461836 | g130669 | i0 | 60 | 1.69035532994924 | 55 | 22 | 83.8 | 0 | 166 | 2 | 8 | 62 | XP_013757499.1 cysteine and glycine-rich protein 2 [Thecamonas trahens ATCC 50062] | diamond | 333 | 89 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31202244 | 31202244 | PRJEB64798_P_NODE_117755_length_207_cov_11.436709_g115989_i0 | PRJEB64798 | 117755 | 207 | 11.436709 | 23.67398763 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 45.1 | 0.00362 | NR | XP_013761416.1 | 461836 | g115989 | i0 | 25.4 | 1.82608695652174 | 126 | 35 | 97.1 | 2 | 206 | 6 | 1549 | 1674 | XP_013761416.1 uncharacterized protein AMSG_01915 [Thecamonas trahens ATCC 50062] | diamond | 378 | 45.1 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31512397 | 31512397 | PRJEB64798_P_NODE_248176_length_152_cov_6.475728_g246410_i0 | PRJEB64798 | 248176 | 152 | 6.475728 | 9.84310656 | root | 1 | Root_unresolved | Root_unresolved | 50.8 | 1.48e-5 | NR | XP_013754695.1 | 461836 | g246410 | i0 | 52.5 | 3.11842105263158 | 40 | 19 | 78.9 | 0 | 33 | 152 | 454 | 493 | XP_013754695.1 methylenetetrahydrofolate reductase [Thecamonas trahens ATCC 50062] | diamond | 474 | 51.2 | 0.9921875 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31550849 | 31550849 | PRJEB64798_P_NODE_113576_length_209_cov_7.368750_g111810_i0 | PRJEB64798 | 113576 | 209 | 7.36875 | 15.4006875 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 50.4 | 4.53e-5 | NR | XP_013755302.1 | 461836 | g111810 | i0 | 62.5 | 0.91866028708134 | 32 | 12 | 45.9 | 0 | 96 | 1 | 396 | 427 | XP_013755302.1 uncharacterized protein AMSG_08072 [Thecamonas trahens ATCC 50062] | diamond | 192 | 50.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31551029 | 31551029 | PRJEB64798_P_NODE_59516_length_252_cov_14.886700_g57751_i0 | PRJEB64798 | 59516 | 252 | 14.8867 | 37.514484 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 45.1 | 0.00575 | NR | XP_013753140.1 | 461836 | g57751 | i0 | 43.2 | 0.523809523809524 | 44 | 25 | 52.4 | 0 | 8 | 139 | 159 | 202 | XP_013753140.1 uncharacterized protein AMSG_10829 [Thecamonas trahens ATCC 50062] | diamond | 132 | 45.1 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31614001 | 31614001 | PRJEB64798_P_NODE_223816_length_161_cov_3.535714_g222050_i0 | PRJEB64798 | 223816 | 161 | 3.535714 | 5.69249954 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 52.8 | 3.42e-6 | NR | XP_013755573.1 | 461836 | g222050 | i0 | 62.2 | 1.37888198757764 | 37 | 13 | 68.9 | 1 | 9 | 119 | 246 | 281 | XP_013755573.1 cysteine protease CP19 [Thecamonas trahens ATCC 50062] | diamond | 222 | 52.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31930221 | 31930221 | PRJEB64798_P_NODE_209037_length_165_cov_1.465517_g207271_i0 | PRJEB64798 | 209037 | 165 | 1.465517 | 2.41810305 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 78.2 | 4.27e-15 | NR | XP_013756296.1 | 461836 | g207271 | i0 | 73.6 | 3.72727272727273 | 53 | 14 | 96.4 | 0 | 4 | 162 | 1739 | 1791 | XP_013756296.1 uncharacterized protein AMSG_12057 [Thecamonas trahens ATCC 50062] | diamond | 615 | 78.2 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32752127 | 32752127 | PRJEB64798_P_NODE_252920_length_150_cov_8.891089_g251154_i0 | PRJEB64798 | 252920 | 150 | 8.891089 | 13.3366335 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 67.8 | 1.48e-11 | NR | XP_013762088.1 | 461836 | g251154 | i0 | 76.5 | 0.68 | 34 | 8 | 68 | 0 | 143 | 42 | 384 | 417 | XP_013762088.1 acid ceramidase subunit beta [Thecamonas trahens ATCC 50062] | diamond | 102 | 67.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32846378 | 32846378 | PRJEB64798_P_NODE_145680_length_190_cov_11.035461_g143914_i0 | PRJEB64798 | 145680 | 190 | 11.035461 | 20.9673759 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 62 | 2.97e-9 | NR | XP_013758156.1 | 461836 | g143914 | i0 | 43.3 | 0.947368421052632 | 60 | 34 | 94.7 | 0 | 7 | 186 | 546 | 605 | XP_013758156.1 HIRA-interacting protein 5 [Thecamonas trahens ATCC 50062] | diamond | 180 | 62 | 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);;