contig_metadata
6 rows where bioproject = "PRJNA312615" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13132068 | 13132068 | PRJNA312615_P_NODE_39691_length_195_cov_0.945205_g39540_i0 | PRJNA312615 | 39691 | 195 | 0.945205 | 1.84314975 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 67 | 5.35e-11 | NR | XP_013761457.1 | 461836 | g39540 | i0 | 49.2 | 2.83076923076923 | 63 | 31 | 96.9 | 1 | 2 | 190 | 596 | 657 | XP_013761457.1 uncharacterized protein AMSG_01959 [Thecamonas trahens ATCC 50062] | diamond | 552 | 67 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 23330878 | 23330878 | PRJNA312615_P_NODE_8979_length_411_cov_4.651934_g8829_i0 | PRJNA312615 | 8979 | 411 | 4.651934 | 19.11944874 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 207 | 7.96e-49 | NTclustered | gi|923134252|ref|XM_013905138.1| | 461836 | g8829 | i0 | 77.32 | 54.4184914841849 | 388 | 64 | 91 | 14 | 1 | 373 | 165 | 543 | Thecamonas trahens ATCC 50062 adenine nucleotide translocator (AMSG_02751), mRNA | blastn | 22366 | 207 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 24604030 | 24604030 | PRJNA312615_P_NODE_21380_length_263_cov_5.471963_g21229_i0 | PRJNA312615 | 21380 | 263 | 5.471963 | 14.39126269 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 125 | 9.82e-33 | NR | XP_013760592.1 | 461836 | g21229 | i0 | 67.8 | 0.992395437262357 | 87 | 26 | 99.2 | 1 | 2 | 262 | 192 | 276 | XP_013760592.1 adenine nucleotide translocator [Thecamonas trahens ATCC 50062] | diamond | 261 | 125 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29789814 | 29789814 | PRJNA312615_P_NODE_5531_length_515_cov_1.744635_g5383_i0 | PRJNA312615 | 5531 | 515 | 1.744635 | 8.98487025 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 67.4 | 9.09e-10 | NR | XP_013753393.1 | 461836 | g5383 | i0 | 29.3 | 0.87378640776699 | 150 | 89 | 78.1 | 4 | 16 | 417 | 71 | 219 | XP_013753393.1 uncharacterized protein AMSG_10185 [Thecamonas trahens ATCC 50062] | diamond | 450 | 67.4 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 29884883 | 29884883 | PRJNA312615_P_NODE_2211_length_748_cov_4.469242_g2089_i0 | PRJNA312615 | 2211 | 748 | 4.469242 | 33.42993016 | Thecamonas trahens ATCC 5 | 529818 | Root_unresolved | Root_unresolved | 87.8 | 8.5e-16 | NR | XP_013758183.1 | 461836 | g2089 | i0 | 31 | 0.906417112299465 | 226 | 130 | 89.8 | 4 | 715 | 44 | 150 | 351 | XP_013758183.1 cystatin-A2 [Thecamonas trahens ATCC 50062] | diamond | 678 | 87.8 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 31260923 | 31260923 | PRJNA312615_P_NODE_16295_length_304_cov_1.992157_g16144_i0 | PRJNA312615 | 16295 | 304 | 1.992157 | 6.05615728 | root | 1 | Root_unresolved | Root_unresolved | 128 | 1.9e-35 | NR | XP_013759960.1 | 461836 | g16144 | i0 | 66.3 | 5.08223684210526 | 89 | 30 | 87.8 | 0 | 37 | 303 | 21 | 109 | XP_013759960.1 40S ribosomal protein S12 [Thecamonas trahens ATCC 50062] | diamond | 1545 | 128 | 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);;