contig_metadata
14 rows where bioproject = "PRJNA1087264", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2744779 | 2744779 | PRJNA1087264_P_NODE_4623_length_301_cov_1.373016_g4541_i0 | PRJNA1087264 | 4623 | 301 | 1.373016 | 4.13277816 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 169 | 2.29e-49 | NR | XP_004352945.1 | 1257118 | g4541 | i0 | 80.8 | 0.98671096345515 | 99 | 19 | 98.7 | 0 | 3 | 299 | 48 | 146 | XP_004352945.1 UDPglucuronate decarboxylase, putative [Acanthamoeba castellanii str. Neff] | diamond | 297 | 169 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 10397321 | 10397321 | PRJNA1087264_P_NODE_11829_length_183_cov_1.641791_g11747_i0 | PRJNA1087264 | 11829 | 183 | 1.641791 | 3.00447753 | Vannella sp. BEN3V | 1215631 | Discosea | other_Eukaryota | 259 | 8.56e-65 | NTclustered | gi|399764216|gb|JQ271727.1| | 1215631 | g11747 | i0 | 92.473 | 100.666666666667 | 186 | 7 | 100 | 5 | 1 | 183 | 626 | 807 | Vannella sp. BEN3V 18S ribosomal RNA gene, partial sequence | blastn | 18422 | 259 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. BEN3V | |||
| 12947787 | 12947787 | PRJNA1087264_P_NODE_371_length_1032_cov_2.307223_g321_i0 | PRJNA1087264 | 371 | 1032 | 2.307223 | 23.81054136 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 837 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g321 | i0 | 94.679 | 52.9147286821705 | 545 | 19 | 53 | 8 | 1 | 542 | 538 | 1 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 54608 | 837 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 13770797 | 13770797 | PRJNA1087264_P_NODE_3491_length_351_cov_2.298013_g3409_i0 | PRJNA1087264 | 3491 | 351 | 2.298013 | 8.06602563 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 278 | 5.03e-70 | NTclustered | gi|53829569|gb|AY582837.1| | 43142 | g3409 | i0 | 80.966 | 83.0740740740741 | 352 | 65 | 100 | 2 | 1 | 351 | 574 | 924 | Acanthamoeba culbertsoni HSP70 gene, partial cds | blastn | 29159 | 278 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba culbertsoni | |||
| 14222745 | 14222745 | PRJNA1087264_P_NODE_1812_length_500_cov_1.432373_g1732_i0 | PRJNA1087264 | 1812 | 500 | 1.432373 | 7.161865 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 649 | 0 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g1732 | i0 | 91.649 | 46.942 | 479 | 23 | 100 | 12 | 1 | 468 | 625 | 153 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 23471 | 649 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 26624293 | 26624293 | PRJNA1087264_P_NODE_4761_length_296_cov_1.712551_g4679_i0 | PRJNA1087264 | 4761 | 296 | 1.712551 | 5.06915096 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 68.6 | 1.73e-12 | NR | XP_004333362.1 | 1257118 | g4679 | i0 | 52.7 | 1.48986486486486 | 74 | 35 | 75 | 0 | 295 | 74 | 35 | 108 | XP_004333362.1 ribosomal protein L21e, putative [Acanthamoeba castellanii str. Neff] | diamond | 441 | 68.6 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 26814457 | 26814457 | PRJNA1087264_P_NODE_19801_length_163_cov_0.894737_g19719_i0 | PRJNA1087264 | 19801 | 163 | 0.894737 | 1.45842131 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 46.6 | 5.58e-4 | NR | XP_004341866.1 | 1257118 | g19719 | i0 | 46.9 | 0.901840490797546 | 49 | 25 | 90.2 | 1 | 2 | 148 | 168 | 215 | XP_004341866.1 transmembrane 9 superfamily protein member 4, putative [Acanthamoeba castellanii str. Neff] | diamond | 147 | 46.6 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28172860 | 28172860 | PRJNA1087264_P_NODE_16306_length_166_cov_0.871795_g16224_i0 | PRJNA1087264 | 16306 | 166 | 0.871795 | 1.4471797 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 63.9 | 4.42e-10 | NR | XP_004344035.1 | 1257118 | g16224 | i0 | 53.7 | 0.975903614457831 | 54 | 25 | 97.6 | 0 | 166 | 5 | 491 | 544 | XP_004344035.1 TNF receptor-associated protein 1, putative [Acanthamoeba castellanii str. Neff] | diamond | 162 | 63.9 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29814712 | 29814712 | PRJNA1087264_P_NODE_13671_length_170_cov_1.264463_g13589_i0 | PRJNA1087264 | 13671 | 170 | 1.264463 | 2.1495871 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 99.4 | 6.53e-23 | NR | XP_004341541.1 | 1257118 | g13589 | i0 | 82.1 | 0.988235294117647 | 56 | 10 | 98.8 | 0 | 2 | 169 | 307 | 362 | XP_004341541.1 GTP binding protein [Acanthamoeba castellanii str. Neff] | diamond | 168 | 99.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30098969 | 30098969 | PRJNA1087264_P_NODE_1472_length_554_cov_1.124752_g1395_i0 | PRJNA1087264 | 1472 | 554 | 1.124752 | 6.23112608 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 72 | 1.87e-12 | NR | XP_004349605.1 | 1257118 | g1395 | i0 | 46 | 0.471119133574007 | 87 | 44 | 46 | 2 | 469 | 215 | 49 | 134 | XP_004349605.1 uncharacterized protein ACA1_142080 [Acanthamoeba castellanii str. Neff] | diamond | 261 | 72 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30415428 | 30415428 | PRJNA1087264_P_NODE_213_length_1323_cov_3.309262_g178_i0 | PRJNA1087264 | 213 | 1323 | 3.309262 | 43.78153626 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 109 | 2.15e-22 | NR | AFD36233.1 | 5755 | g178 | i0 | 25.2 | 1.63718820861678 | 333 | 175 | 74.6 | 8 | 993 | 7 | 77 | 339 | AFD36233.1 protein kinase C4, partial [Acanthamoeba castellanii] | diamond | 2166 | 109 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31236452 | 31236452 | PRJNA1087264_P_NODE_10475_length_195_cov_1.047945_g10393_i0 | PRJNA1087264 | 10475 | 195 | 1.047945 | 2.04349275 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 80.1 | 2.36e-17 | NR | XP_004348720.1 | 1257118 | g10393 | i0 | 57.1 | 0.969230769230769 | 63 | 27 | 96.9 | 0 | 194 | 6 | 51 | 113 | XP_004348720.1 actin binding protein [Acanthamoeba castellanii str. Neff] | diamond | 189 | 80.1 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31797111 | 31797111 | PRJNA1087264_P_NODE_19077_length_163_cov_0.894737_g18995_i0 | PRJNA1087264 | 19077 | 163 | 0.894737 | 1.45842131 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 41.2 | 0.0426 | NR | XP_004352916.1 | 1257118 | g18995 | i0 | 53.1 | 1.39877300613497 | 32 | 15 | 58.9 | 0 | 59 | 154 | 40 | 71 | XP_004352916.1 Lysozyme, putative [Acanthamoeba castellanii str. Neff] | diamond | 228 | 41.6 | 0.990384615384615 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32090699 | 32090699 | PRJNA1087264_P_NODE_6638_length_246_cov_1.040609_g6556_i0 | PRJNA1087264 | 6638 | 246 | 1.040609 | 2.55989814 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 94.4 | 6.359999999999999e-23 | NR | XP_004333362.1 | 1257118 | g6556 | i0 | 61.7 | 0.98780487804878 | 81 | 31 | 98.8 | 0 | 245 | 3 | 16 | 96 | XP_004333362.1 ribosomal protein L21e, putative [Acanthamoeba castellanii str. Neff] | diamond | 243 | 94.4 | 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);;