contig_metadata
4 rows where bioproject = "PRJNA560029" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28026656 | 28026656 | PRJNA560029_S_NODE_28285_length_265_cov_3.906250_g28061_i0 | PRJNA560029 | 28285 | 265 | 3.90625 | 10.3515625 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 61.2 | 1.43e-8 | NR | XP_004367846.1 | 1257118 | g28061 | i0 | 38.3 | 0.916981132075472 | 81 | 50 | 91.7 | 0 | 245 | 3 | 1 | 81 | XP_004367846.1 Leucinerich repeat protein lrrA, putative [Acanthamoeba castellanii str. Neff] | diamond | 243 | 61.2 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29889568 | 29889568 | PRJNA560029_S_NODE_8431_length_382_cov_5.313916_g8207_i0 | PRJNA560029 | 8431 | 382 | 5.313916 | 20.29915912 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 57 | 1.39e-6 | NR | XP_004344132.1 | 1257118 | g8207 | i0 | 34 | 0.832460732984293 | 106 | 61 | 83.2 | 2 | 375 | 58 | 197 | 293 | XP_004344132.1 Olinked GlcNAc transferase-like protein [Acanthamoeba castellanii str. Neff] | diamond | 318 | 57 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30346245 | 30346245 | PRJNA560029_S_NODE_18112_length_312_cov_3.966527_g17888_i0 | PRJNA560029 | 18112 | 312 | 3.966527 | 12.37556424 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 57.8 | 4.4e-7 | NR | XP_004341420.1 | 1257118 | g17888 | i0 | 40 | 1.42307692307692 | 70 | 34 | 59.6 | 1 | 3 | 188 | 742 | 811 | XP_004341420.1 vacuolar sorting protein, putative [Acanthamoeba castellanii str. Neff] | diamond | 444 | 57.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30458529 | 30458529 | PRJNA560029_S_NODE_8053_length_387_cov_2.767516_g7829_i0 | PRJNA560029 | 8053 | 387 | 2.767516 | 10.71028692 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 115 | 3.15e-28 | NR | XP_004339668.1 | 1257118 | g7829 | i0 | 64.4 | 2.66666666666667 | 90 | 23 | 62.8 | 1 | 377 | 135 | 211 | 300 | XP_004339668.1 Ras subfamily protein, putative [Acanthamoeba castellanii str. Neff] | diamond | 1032 | 115 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;