contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1028258" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 164492 | 164492 | PRJNA1028258_P_NODE_28341_length_477_cov_2.522059_g27780_i0 | PRJNA1028258 | 28341 | 477 | 2.522059 | 12.03022143 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 224 | 9.3e-54 | NTclustered | gi|923134252|ref|XM_013905138.1| | 461836 | g27780 | i0 | 78.249 | 32.8805031446541 | 377 | 62 | 76 | 15 | 98 | 461 | 198 | 567 | Thecamonas trahens ATCC 50062 adenine nucleotide translocator (AMSG_02751), mRNA | blastn | 15684 | 224 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 1438063 | 1438063 | PRJNA1028258_P_NODE_121882_length_243_cov_1.005747_g121319_i0 | PRJNA1028258 | 121882 | 243 | 1.005747 | 2.44396521 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 302 | 1.97e-77 | NTclustered | gi|923122580|ref|XM_013899306.1| | 461836 | g121319 | i0 | 89.212 | 99.9917695473251 | 241 | 26 | 99 | 0 | 3 | 243 | 960 | 1200 | Thecamonas trahens ATCC 50062 heat shock protein 90A (AMSG_09389), mRNA | blastn | 24298 | 302 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 5267421 | 5267421 | PRJNA1028258_P_NODE_31765_length_450_cov_2.328084_g31203_i0 | PRJNA1028258 | 31765 | 450 | 2.328084 | 10.476378 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 224 | 8.729999999999998e-54 | NTclustered | gi|923125359|ref|XM_013900694.1| | 461836 | g31203 | i0 | 82.879 | 43.2266666666667 | 257 | 36 | 56 | 6 | 190 | 442 | 277 | 529 | Thecamonas trahens ATCC 50062 calmodulin (AMSG_07687), mRNA | blastn | 19452 | 224 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 5267580 | 5267580 | PRJNA1028258_P_NODE_39245_length_404_cov_1.289552_g38682_i0 | PRJNA1028258 | 39245 | 404 | 1.289552 | 5.20979008 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 213 | 1.68e-50 | NTclustered | gi|923134252|ref|XM_013905138.1| | 461836 | g38682 | i0 | 81.579 | 35.2722772277228 | 266 | 41 | 64 | 5 | 90 | 348 | 427 | 163 | Thecamonas trahens ATCC 50062 adenine nucleotide translocator (AMSG_02751), mRNA | blastn | 14250 | 213 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 6541449 | 6541449 | PRJNA1028258_P_NODE_121166_length_243_cov_1.632184_g120603_i0 | PRJNA1028258 | 121166 | 243 | 1.632184 | 3.96620712 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 154 | 5.84e-33 | NTclustered | gi|923123658|ref|XM_013899844.1| | 461836 | g120603 | i0 | 84.146 | 8.559670781893 | 164 | 20 | 67 | 3 | 30 | 193 | 265 | 422 | Thecamonas trahens ATCC 50062 ubiquitin/ribosomal protein S27 fusion protein (AMSG_08067), partial mRNA | blastn | 2080 | 154 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 10368527 | 10368527 | PRJNA1028258_P_NODE_65429_length_316_cov_1.834008_g64866_i0 | PRJNA1028258 | 65429 | 316 | 1.834008 | 5.79546528 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 220 | 7.67e-53 | NTclustered | gi|923123284|ref|XM_013899657.1| | 461836 | g64866 | i0 | 83.539 | 42.2246835443038 | 243 | 32 | 76 | 7 | 8 | 246 | 356 | 118 | Thecamonas trahens ATCC 50062 peroxiredoxin (AMSG_08693), mRNA | blastn | 13343 | 220 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 15468687 | 15468687 | PRJNA1028258_P_NODE_95693_length_265_cov_1.448980_g95130_i0 | PRJNA1028258 | 95693 | 265 | 1.44898 | 3.839797 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 63.9 | 1.12e-5 | NTclustered | gi|923118232|ref|XM_013897139.1| | 461836 | g95130 | i0 | 97.297 | 0.279245283018868 | 37 | 1 | 14 | 0 | 134 | 170 | 153 | 189 | Thecamonas trahens ATCC 50062 60S ribosomal protein L7 (AMSG_11553), partial mRNA | blastn | 74 | 63.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 16740556 | 16740556 | PRJNA1028258_P_NODE_138954_length_234_cov_0.860606_g138391_i0 | PRJNA1028258 | 138954 | 234 | 0.860606 | 2.01381804 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 56.5 | 0.002 | NTclustered | gi|923119197|ref|XM_013897619.1| | 461836 | g138391 | i0 | 96.97 | 0.141025641025641 | 33 | 1 | 14 | 0 | 200 | 232 | 573 | 541 | Thecamonas trahens ATCC 50062 poly-zinc finger protein 1 (AMSG_11014), partial mRNA | blastn | 33 | 56.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 19290660 | 19290660 | PRJNA1028258_P_NODE_46036_length_373_cov_1.802632_g45473_i0 | PRJNA1028258 | 46036 | 373 | 1.802632 | 6.72381736 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 124 | 7.41e-24 | NTclustered | gi|923118232|ref|XM_013897139.1| | 461836 | g45473 | i0 | 83.969 | 0.702412868632708 | 131 | 19 | 35 | 2 | 18 | 147 | 362 | 233 | Thecamonas trahens ATCC 50062 60S ribosomal protein L7 (AMSG_11553), partial mRNA | blastn | 262 | 124 | 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);;