contig_metadata
7 rows where bioproject = "PRJNA799842", tax_clade = "Apusozoa" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9723921 | 9723921 | PRJNA799842_P_NODE_86208_length_311_cov_7.394958_g84635_i0 | PRJNA799842 | 86208 | 311 | 7.394958 | 22.99831938 | Singekia montserratensis | 2925341 | Root_unresolved | Root_unresolved | 171 | 7.69e-38 | NTclustered | gi|2206682174|gb|OM966647.1| | 2925341 | g84635 | i0 | 81.25 | 73.2926045016077 | 224 | 30 | 69 | 11 | 1 | 216 | 1622 | 1403 | Singekia montserratensis strain MONTSE19P8 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 22794 | 171 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Singekia | Singekia montserratensis | ||||
| 27148421 | 27148421 | PRJNA799842_P_NODE_33482_length_498_cov_3.887059_g31913_i0 | PRJNA799842 | 33482 | 498 | 3.887059 | 19.35755382 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 85.9 | 7.13e-18 | NR | XP_013758370.1 | 461836 | g31913 | i0 | 39.6 | 0.837349397590361 | 139 | 77 | 81.3 | 4 | 485 | 81 | 6 | 141 | XP_013758370.1 uncharacterized protein AMSG_04698 [Thecamonas trahens ATCC 50062] | diamond | 417 | 85.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 28569899 | 28569899 | PRJNA799842_P_NODE_85067_length_313_cov_1.604167_g83494_i0 | PRJNA799842 | 85067 | 313 | 1.604167 | 5.02104271 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 60.5 | 3.7e-8 | NR | XP_013760900.1 | 461836 | g83494 | i0 | 32.4 | 1.00638977635783 | 105 | 63 | 93.9 | 3 | 311 | 18 | 102 | 205 | XP_013760900.1 tetraspanin family protein [Thecamonas trahens ATCC 50062] | diamond | 315 | 60.5 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31033809 | 31033809 | PRJNA799842_P_NODE_25115_length_589_cov_2.176357_g23571_i0 | PRJNA799842 | 25115 | 589 | 2.176357 | 12.81874273 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 84.7 | 6.86e-17 | NR | XP_013753243.1 | 461836 | g23571 | i0 | 34 | 0.764006791171477 | 150 | 96 | 74.9 | 2 | 467 | 27 | 12 | 161 | XP_013753243.1 uncharacterized protein AMSG_10809 [Thecamonas trahens ATCC 50062] | diamond | 450 | 84.7 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31476212 | 31476212 | PRJNA799842_P_NODE_118156_length_269_cov_1.964286_g116583_i0 | PRJNA799842 | 118156 | 269 | 1.964286 | 5.28392934 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 97.4 | 3.0600000000000003e-21 | NR | XP_013755941.1 | 461836 | g116583 | i0 | 53.9 | 2.0185873605948 | 89 | 39 | 99.3 | 1 | 1 | 267 | 352 | 438 | XP_013755941.1 nc protein [Thecamonas trahens ATCC 50062] | diamond | 543 | 97.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31887237 | 31887237 | PRJNA799842_P_NODE_139277_length_250_cov_1.734463_g137704_i0 | PRJNA799842 | 139277 | 250 | 1.734463 | 4.3361575 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 103 | 3.2099999999999994e-24 | NR | XP_013758079.1 | 461836 | g137704 | i0 | 63.4 | 0.984 | 82 | 29 | 98.4 | 1 | 2 | 247 | 125 | 205 | XP_013758079.1 uncharacterized protein AMSG_05004 [Thecamonas trahens ATCC 50062] | diamond | 246 | 103 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 32592388 | 32592388 | PRJNA799842_P_NODE_52639_length_391_cov_4.597484_g51066_i0 | PRJNA799842 | 52639 | 391 | 4.597484 | 17.97616244 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 145 | 9.559999999999998e-42 | NR | XP_013756220.1 | 461836 | g51066 | i0 | 60.9 | 2.70076726342711 | 110 | 43 | 84.4 | 0 | 331 | 2 | 26 | 135 | XP_013756220.1 peptidyl-prolyl cis-trans isomerase [Thecamonas trahens ATCC 50062] | diamond | 1056 | 145 | 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);;