contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1022139" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1436441 | 1436441 | PRJNA1022139_P_NODE_28682_length_271_cov_2.878788_g28577_i0 | PRJNA1022139 | 28682 | 271 | 2.878788 | 7.80151548 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 134 | 8.630000000000001e-27 | NTclustered | gi|923136453|ref|XM_013906238.1| | 461836 | g28577 | i0 | 83.688 | 0.774907749077491 | 141 | 23 | 52 | 0 | 58 | 198 | 290 | 150 | Thecamonas trahens ATCC 50062 50S ribosomal protein L36e (AMSG_01644), partial mRNA | blastn | 210 | 134 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 2711928 | 2711928 | PRJNA1022139_P_NODE_15843_length_346_cov_0.978022_g15738_i0 | PRJNA1022139 | 15843 | 346 | 0.978022 | 3.38395612 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 106 | 2.48e-18 | NTclustered | gi|923122075|ref|XM_013899054.1| | 461836 | g15738 | i0 | 85.294 | 16.121387283237 | 102 | 15 | 29 | 0 | 3 | 104 | 1543 | 1644 | Thecamonas trahens ATCC 50062 PL10b protein (AMSG_08727), partial mRNA | blastn | 5578 | 106 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 16738665 | 16738665 | PRJNA1022139_P_NODE_3274_length_693_cov_1.700000_g3174_i0 | PRJNA1022139 | 3274 | 693 | 1.7 | 11.781 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 324 | 1.33e-83 | NTclustered | gi|923134252|ref|XM_013905138.1| | 461836 | g3174 | i0 | 78.464 | 19.3376623376623 | 534 | 87 | 75 | 21 | 108 | 624 | 720 | 198 | Thecamonas trahens ATCC 50062 adenine nucleotide translocator (AMSG_02751), mRNA | blastn | 13401 | 324 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 18013381 | 18013381 | PRJNA1022139_P_NODE_15015_length_353_cov_2.017857_g14910_i0 | PRJNA1022139 | 15015 | 353 | 2.017857 | 7.12303521 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 320 | 8.29e-83 | NTclustered | gi|923137248|ref|XM_013906635.1| | 461836 | g14910 | i0 | 83.728 | 92.9348441926346 | 338 | 55 | 96 | 0 | 1 | 338 | 1215 | 1552 | Thecamonas trahens ATCC 50062 inositol-3-phosphate synthase (AMSG_00912), mRNA | blastn | 32806 | 320 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 18013651 | 18013651 | PRJNA1022139_P_NODE_815_length_1262_cov_2.507990_g767_i0 | PRJNA1022139 | 815 | 1262 | 2.50799 | 31.6508338 | Amastigomonas marina | 234594 | Root_unresolved | Root_unresolved | 959 | 0 | NTclustered | gi|31982973|gb|AY236711.1| | 234594 | g767 | i0 | 80.577 | 95.3058637083994 | 1282 | 217 | 99 | 22 | 1 | 1257 | 353 | 1627 | Amastigomonas marina heat shock protein 90 (Hsp90) gene, partial cds | blastn | 120276 | 959 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Amastigomonas | Amastigomonas marina | ||||
| 20562758 | 20562758 | PRJNA1022139_P_NODE_19697_length_315_cov_1.181818_g19592_i0 | PRJNA1022139 | 19697 | 315 | 1.181818 | 3.7227267 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 285 | 2.67e-72 | NTclustered | gi|923123076|ref|XM_013899554.1| | 461836 | g19592 | i0 | 83.121 | 109.552380952381 | 314 | 51 | 99 | 2 | 1 | 313 | 4278 | 3966 | Thecamonas trahens ATCC 50062 uncharacterized protein (AMSG_12222), partial mRNA | blastn | 34509 | 285 | 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);;