contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA689790" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4496786 | 4496786 | PRJNA689790_S_NODE_5284_length_262_cov_1.368889_g5169_i0 | PRJNA689790 | 5284 | 262 | 1.368889 | 3.58648918 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 163 | 1.06e-35 | NTclustered | gi|923129792|ref|XM_013902908.1| | 461836 | g5169 | i0 | 80.269 | 13.8282442748092 | 223 | 38 | 84 | 5 | 1 | 220 | 209 | 428 | Thecamonas trahens ATCC 50062 Ras-like C3 botulinum toxin substrate 1 (AMSG_04690), mRNA | blastn | 3623 | 163 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 4496811 | 4496811 | PRJNA689790_S_NODE_8724_length_200_cov_1.435583_g8609_i0 | PRJNA689790 | 8724 | 200 | 1.435583 | 2.871166 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 93.5 | 1.02e-14 | NTclustered | gi|923138884|ref|XM_013907453.1| | 461836 | g8609 | i0 | 76.757 | 3.705 | 185 | 32 | 91 | 9 | 18 | 198 | 878 | 701 | Thecamonas trahens ATCC 50062 elongation factor 2 (AMSG_00036), mRNA | blastn | 741 | 93.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 5772282 | 5772282 | PRJNA689790_S_NODE_1145_length_624_cov_5.143101_g1052_i0 | PRJNA689790 | 1145 | 624 | 5.143101 | 32.09295024 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 483 | 1.8499999999999996e-131 | NTclustered | gi|923129792|ref|XM_013902908.1| | 461836 | g1052 | i0 | 83.716 | 55.8814102564103 | 522 | 73 | 83 | 8 | 109 | 624 | 545 | 30 | Thecamonas trahens ATCC 50062 Ras-like C3 botulinum toxin substrate 1 (AMSG_04690), mRNA | blastn | 34870 | 483 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 12148004 | 12148004 | PRJNA689790_S_NODE_10070_length_187_cov_1.173333_g9955_i0 | PRJNA689790 | 10070 | 187 | 1.173333 | 2.19413271 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 241 | 3.18e-59 | NTclustered | gi|923138884|ref|XM_013907453.1| | 461836 | g9955 | i0 | 91.429 | 44.475935828877 | 175 | 15 | 94 | 0 | 2 | 176 | 502 | 328 | Thecamonas trahens ATCC 50062 elongation factor 2 (AMSG_00036), mRNA | blastn | 8317 | 241 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 12148061 | 12148061 | PRJNA689790_S_NODE_5010_length_270_cov_1.927039_g4895_i0 | PRJNA689790 | 5010 | 270 | 1.927039 | 5.2030053 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 143 | 1.43e-29 | NTclustered | gi|923138884|ref|XM_013907453.1| | 461836 | g4895 | i0 | 78.873 | 0.788888888888889 | 213 | 43 | 79 | 2 | 53 | 264 | 945 | 1156 | Thecamonas trahens ATCC 50062 elongation factor 2 (AMSG_00036), mRNA | blastn | 213 | 143 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 12148077 | 12148077 | PRJNA689790_S_NODE_7890_length_210_cov_2.589595_g7775_i0 | PRJNA689790 | 7890 | 210 | 2.589595 | 5.4381495 | Amastigomonas marina | 234594 | Root_unresolved | Root_unresolved | 172 | 1.36e-38 | NTclustered | gi|31982973|gb|AY236711.1| | 234594 | g7775 | i0 | 84.153 | 95.852380952381 | 183 | 23 | 86 | 4 | 1 | 180 | 1480 | 1659 | Amastigomonas marina heat shock protein 90 (Hsp90) gene, partial cds | blastn | 20129 | 172 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Amastigomonas | Amastigomonas marina | ||||
| 12148081 | 12148081 | PRJNA689790_S_NODE_8810_length_199_cov_1.654321_g8695_i0 | PRJNA689790 | 8810 | 199 | 1.654321 | 3.29209879 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 200 | 5.829999999999999e-47 | NTclustered | gi|923120664|ref|XM_013898350.1| | 461836 | g8695 | i0 | 85 | 98.5075376884422 | 200 | 26 | 99 | 4 | 1 | 198 | 1035 | 1232 | Thecamonas trahens ATCC 50062 ATP-dependent RNA helicase eIF4A (AMSG_10343), partial mRNA | blastn | 19603 | 200 | 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);;