contig_metadata
9 rows where bioproject = "PRJNA922890", tax_clade = "Amoebozoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18749128 | 18749128 | PRJNA922890_P_NODE_14755_length_498_cov_1.303030_g14347_i0 | PRJNA922890 | 14755 | 498 | 1.30303 | 6.4890894 | Ripella tribonemae | 2047823 | Discosea | other_Eukaryota | 797 | 0 | NTclustered | gi|1269228472|gb|MF683597.1| | 2047823 | g14347 | i0 | 95.618 | 102.347389558233 | 502 | 12 | 100 | 7 | 1 | 498 | 1031 | 536 | Ripella tribonemae clone 22.1.15 18S ribosomal RNA gene, partial sequence | blastn | 50969 | 797 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella tribonemae | |||
| 20024280 | 20024280 | PRJNA922890_P_NODE_20256_length_424_cov_1.095775_g19846_i0 | PRJNA922890 | 20256 | 424 | 1.095775 | 4.646086 | Vannella persistens | 303303 | Discosea | other_Eukaryota | 767 | 0 | NTclustered | gi|261599932|dbj|AB525840.1| | 303303 | g19846 | i0 | 99.292 | 99.8372641509434 | 424 | 3 | 100 | 0 | 1 | 424 | 554 | 131 | Vannella persistens gene for 18S ribosomal RNA, partial sequence, strain: NHE(Vp)1-IR | blastn | 42331 | 767 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella persistens | |||
| 31225174 | 31225174 | PRJNA922890_P_NODE_51395_length_272_cov_1.428571_g50985_i0 | PRJNA922890 | 51395 | 272 | 1.428571 | 3.88571312 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 95.5 | 1.04e-20 | NR | XP_004367854.1 | 1257118 | g50985 | i0 | 53.2 | 1.69852941176471 | 77 | 36 | 84.9 | 0 | 4 | 234 | 211 | 287 | XP_004367854.1 NEDD8activating enzyme E1 catalytic subunit [Acanthamoeba castellanii str. Neff] | diamond | 462 | 95.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31351920 | 31351920 | PRJNA922890_P_NODE_60716_length_250_cov_1.596685_g60306_i0 | PRJNA922890 | 60716 | 250 | 1.596685 | 3.9917125 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 140 | 5.63e-40 | NR | XP_004336000.1 | 1257118 | g60306 | i0 | 81.9 | 5.976 | 83 | 15 | 99.6 | 0 | 2 | 250 | 72 | 154 | XP_004336000.1 ribosomal protein S4, putative, partial [Acanthamoeba castellanii str. Neff] | diamond | 1494 | 140 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31359258 | 31359258 | PRJNA922890_P_NODE_55496_length_262_cov_1.694301_g55086_i0 | PRJNA922890 | 55496 | 262 | 1.694301 | 4.43906862 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 112 | 4.79e-29 | NR | XP_004358287.1 | 1257118 | g55086 | i0 | 66.3 | 2.94274809160305 | 86 | 29 | 98.5 | 0 | 260 | 3 | 96 | 181 | XP_004358287.1 eukaryotic ribosomal protein L18, putative [Acanthamoeba castellanii str. Neff] | diamond | 771 | 113 | 0.991150442477876 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31446772 | 31446772 | PRJNA922890_P_NODE_72936_length_233_cov_0.890244_g72526_i0 | PRJNA922890 | 72936 | 233 | 0.890244 | 2.07426852 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 117 | 2.31e-29 | NR | XP_004341646.1 | 1257118 | g72526 | i0 | 79.4 | 0.811158798283262 | 63 | 13 | 81.1 | 0 | 43 | 231 | 136 | 198 | XP_004341646.1 papain family cysteine protease containing protein [Acanthamoeba castellanii str. Neff] | diamond | 189 | 117 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31675295 | 31675295 | PRJNA922890_P_NODE_73857_length_233_cov_0.878049_g73447_i0 | PRJNA922890 | 73857 | 233 | 0.878049 | 2.04585417 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 113 | 3.18e-27 | NR | XP_004334901.1 | 1257118 | g73447 | i0 | 63.2 | 5.84549356223176 | 76 | 28 | 97.9 | 0 | 6 | 233 | 315 | 390 | XP_004334901.1 plastin 3 (T isoform), putative [Acanthamoeba castellanii str. Neff] | diamond | 1362 | 113 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31921199 | 31921199 | PRJNA922890_P_NODE_67977_length_236_cov_0.874251_g67567_i0 | PRJNA922890 | 67977 | 236 | 0.874251 | 2.06323236 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 119 | 1.69e-30 | NR | XP_004356728.1 | 1257118 | g67567 | i0 | 75.6 | 4.95762711864407 | 78 | 19 | 99.2 | 0 | 234 | 1 | 53 | 130 | XP_004356728.1 ribosomal protein L19e, putative [Acanthamoeba castellanii str. Neff] | diamond | 1170 | 119 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32111113 | 32111113 | PRJNA922890_P_NODE_69978_length_235_cov_0.867470_g69568_i0 | PRJNA922890 | 69978 | 235 | 0.86747 | 2.0385545 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 67 | 9.53e-11 | NR | XP_004336224.1 | 1257118 | g69568 | i0 | 60 | 1.41702127659574 | 50 | 20 | 63.8 | 0 | 85 | 234 | 709 | 758 | XP_004336224.1 dynamin family protein [Acanthamoeba castellanii str. Neff] | diamond | 333 | 67 | 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);;