contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA416866" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11898497 | 11898497 | PRJNA416866_P_NODE_6510_length_255_cov_1.608247_g6366_i0 | PRJNA416866 | 6510 | 255 | 1.608247 | 4.10102985 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 131 | 8.76e-37 | NR | XP_004341446.1 | 1257118 | g6366 | i0 | 89.3 | 67.0235294117647 | 75 | 8 | 88.2 | 0 | 254 | 30 | 80 | 154 | XP_004341446.1 core histone h2a/h2b/h3/h4 superfamily protein [Acanthamoeba castellanii str. Neff] | diamond | 17091 | 131 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27170180 | 27170180 | PRJNA416866_P_NODE_8162_length_226_cov_1.551515_g8018_i0 | PRJNA416866 | 8162 | 226 | 1.551515 | 3.5064239 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 58.2 | 1.8e-8 | NR | XP_004347153.1 | 1257118 | g8018 | i0 | 39.2 | 3.82300884955752 | 74 | 42 | 94.2 | 2 | 224 | 12 | 1 | 74 | XP_004347153.1 EF hand domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 864 | 58.2 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28875625 | 28875625 | PRJNA416866_P_NODE_7388_length_238_cov_1.446328_g7244_i0 | PRJNA416866 | 7388 | 238 | 1.446328 | 3.44226064 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 85.9 | 2.78e-19 | NR | XP_004337874.1 | 1257118 | g7244 | i0 | 63 | 1.61344537815126 | 73 | 21 | 89.5 | 3 | 22 | 234 | 1 | 69 | XP_004337874.1 uncharacterized protein ACA1_187480 [Acanthamoeba castellanii str. Neff] | diamond | 384 | 85.9 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30423496 | 30423496 | PRJNA416866_P_NODE_3333_length_366_cov_4.573770_g3190_i0 | PRJNA416866 | 3333 | 366 | 4.57377 | 16.7399982 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 77.4 | 2.13e-15 | NR | XP_004338485.1 | 1257118 | g3190 | i0 | 42.1 | 0.778688524590164 | 95 | 54 | 77 | 1 | 297 | 16 | 32 | 126 | XP_004338485.1 uncharacterized protein ACA1_034100 [Acanthamoeba castellanii str. Neff] | diamond | 285 | 77.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30707457 | 30707457 | PRJNA416866_P_NODE_5934_length_268_cov_1.236715_g5790_i0 | PRJNA416866 | 5934 | 268 | 1.236715 | 3.3143962 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 108 | 3.89e-28 | NR | XP_004348720.1 | 1257118 | g5790 | i0 | 66.3 | 0.895522388059702 | 80 | 27 | 89.6 | 0 | 13 | 252 | 49 | 128 | XP_004348720.1 actin binding protein [Acanthamoeba castellanii str. Neff] | diamond | 240 | 108 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31339476 | 31339476 | PRJNA416866_P_NODE_9516_length_209_cov_0.864865_g9372_i0 | PRJNA416866 | 9516 | 209 | 0.864865 | 1.80756785 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 58.5 | 2.29e-8 | NR | XP_004339465.1 | 1257118 | g9372 | i0 | 44.9 | 0.990430622009569 | 69 | 31 | 99 | 1 | 209 | 3 | 50 | 111 | XP_004339465.1 isochorismatase family superfamily protein [Acanthamoeba castellanii str. Neff] | diamond | 207 | 58.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32098705 | 32098705 | PRJNA416866_P_NODE_4558_length_308_cov_2.072874_g4414_i0 | PRJNA416866 | 4558 | 308 | 2.072874 | 6.38445192 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 100 | 7.6e-25 | NR | XP_004349605.1 | 1257118 | g4414 | i0 | 48 | 0.993506493506494 | 102 | 50 | 99.4 | 1 | 307 | 2 | 1 | 99 | XP_004349605.1 uncharacterized protein ACA1_142080 [Acanthamoeba castellanii str. Neff] | diamond | 306 | 100 | 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);;