contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA724011" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1986827 | 1986827 | PRJNA724011_P_NODE_70702_length_299_cov_1.017699_g69679_i0 | PRJNA724011 | 70702 | 299 | 1.017699 | 3.04292001 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 63.9 | 1.28e-5 | NTclustered | gi|923139112|ref|XM_013907567.1| | 461836 | g69679 | i0 | 91.489 | 0.929765886287625 | 47 | 2 | 15 | 2 | 208 | 253 | 1582 | 1627 | Thecamonas trahens ATCC 50062 uncharacterized protein (AMSG_00160), mRNA | blastn | 278 | 63.9 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 4538795 | 4538795 | PRJNA724011_P_NODE_109444_length_241_cov_0.916667_g108421_i0 | PRJNA724011 | 109444 | 241 | 0.916667 | 2.20916747 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 111 | 3.53e-20 | NTclustered | gi|923130938|ref|XM_013903481.1| | 461836 | g108421 | i0 | 79.739 | 1.18257261410788 | 153 | 31 | 63 | 0 | 44 | 196 | 863 | 1015 | Thecamonas trahens ATCC 50062 GDP-L-fucose synthase (AMSG_04147), mRNA | blastn | 285 | 111 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 12190227 | 12190227 | PRJNA724011_P_NODE_8430_length_1087_cov_14.652860_g7710_i0 | PRJNA724011 | 8430 | 1087 | 14.65286 | 159.2765882 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 422 | 7.31e-113 | NTclustered | gi|923134252|ref|XM_013905138.1| | 461836 | g7710 | i0 | 76.857 | 17.1425942962282 | 821 | 144 | 73 | 32 | 98 | 895 | 200 | 997 | Thecamonas trahens ATCC 50062 adenine nucleotide translocator (AMSG_02751), mRNA | blastn | 18634 | 422 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 16013494 | 16013494 | PRJNA724011_P_NODE_913_length_2644_cov_23.352392_g764_i0 | PRJNA724011 | 913 | 2644 | 23.352392 | 617.43724448 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 60.2 | 0.002 | NTclustered | gi|923135816|ref|XM_013905920.1| | 461836 | g764 | i0 | 90.909 | 0.0166414523449319 | 44 | 4 | 2 | 0 | 469 | 512 | 1372 | 1415 | Thecamonas trahens ATCC 50062 uncharacterized protein (AMSG_01870), partial mRNA | blastn | 44 | 60.2 | 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);;