contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA615351" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 595811 | 595811 | PRJNA615351_P_NODE_41781_length_866_cov_4.202166_g31128_i0 | PRJNA615351 | 41781 | 866 | 4.202166 | 36.39075756 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 364 | 9.869999999999999e-96 | NTclustered | gi|923129792|ref|XM_013902908.1| | 461836 | g31128 | i0 | 84.865 | 34.2090069284065 | 370 | 46 | 42 | 8 | 462 | 826 | 376 | 12 | Thecamonas trahens ATCC 50062 Ras-like C3 botulinum toxin substrate 1 (AMSG_04690), mRNA | blastn | 29625 | 364 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 3146370 | 3146370 | PRJNA615351_P_NODE_137423_length_211_cov_1.488636_g123323_i0 | PRJNA615351 | 137423 | 211 | 1.488636 | 3.14102196 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 67.6 | 6.62e-7 | NTclustered | gi|923119197|ref|XM_013897619.1| | 461836 | g123323 | i0 | 88.889 | 0.255924170616114 | 54 | 6 | 26 | 0 | 103 | 156 | 521 | 574 | Thecamonas trahens ATCC 50062 poly-zinc finger protein 1 (AMSG_11014), partial mRNA | blastn | 54 | 67.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 14624484 | 14624484 | PRJNA615351_P_NODE_153392_length_185_cov_1.726667_g139292_i0 | PRJNA615351 | 153392 | 185 | 1.726667 | 3.19433395 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 102 | 1.55e-17 | NTclustered | gi|923134252|ref|XM_013905138.1| | 461836 | g139292 | i0 | 95.312 | 1.09189189189189 | 64 | 3 | 35 | 0 | 56 | 119 | 198 | 261 | Thecamonas trahens ATCC 50062 adenine nucleotide translocator (AMSG_02751), mRNA | blastn | 202 | 102 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 15898449 | 15898449 | PRJNA615351_P_NODE_140153_length_206_cov_1.526316_g126053_i0 | PRJNA615351 | 140153 | 206 | 1.526316 | 3.14421096 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 191 | 3.66e-44 | NTclustered | gi|923138884|ref|XM_013907453.1| | 461836 | g126053 | i0 | 84.158 | 4 | 202 | 27 | 97 | 5 | 8 | 206 | 647 | 448 | Thecamonas trahens ATCC 50062 elongation factor 2 (AMSG_00036), mRNA | blastn | 824 | 191 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 19722139 | 19722139 | PRJNA615351_P_NODE_12776_length_1830_cov_5.194986_g9178_i0 | PRJNA615351 | 12776 | 1830 | 5.194986 | 95.0682438 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 60.2 | 0.001 | NTclustered | gi|923137364|ref|XM_013906693.1| | 461836 | g9178 | i0 | 100 | 0.0174863387978142 | 32 | 0 | 2 | 0 | 923 | 954 | 84 | 53 | Thecamonas trahens ATCC 50062 AGC protein kinase (AMSG_00970), mRNA | blastn | 32 | 60.2 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 19722182 | 19722182 | PRJNA615351_P_NODE_142296_length_202_cov_1.856287_g128196_i0 | PRJNA615351 | 142296 | 202 | 1.856287 | 3.74969974 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 119 | 1.71e-22 | NTclustered | gi|923134338|ref|XM_013905181.1| | 461836 | g128196 | i0 | 80.519 | 0.762376237623762 | 154 | 30 | 76 | 0 | 42 | 195 | 1042 | 889 | Thecamonas trahens ATCC 50062 chaperonin containing TCP1 (AMSG_02794), mRNA | blastn | 154 | 119 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 22272788 | 22272788 | PRJNA615351_P_NODE_160218_length_176_cov_1.985816_g146118_i0 | PRJNA615351 | 160218 | 176 | 1.985816 | 3.49503616 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 143 | 8.56e-30 | NTclustered | gi|923139166|ref|XM_013907594.1| | 461836 | g146118 | i0 | 81.356 | 17.4375 | 177 | 31 | 100 | 2 | 1 | 176 | 217 | 42 | Thecamonas trahens ATCC 50062 peptidyl-prolyl cis-trans isomerase (AMSG_00186), partial mRNA | blastn | 3069 | 143 | 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);;