contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA685607" and tax_phylum = "Tubulinea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7045107 | 7045107 | PRJNA685607_P_NODE_77006_length_247_cov_0.885057_g76647_i0 | PRJNA685607 | 77006 | 247 | 0.885057 | 2.18609079 | Arcella hemisphaerica | 497998 | Tubulinea | other_Eukaryota | 142 | 3.5099999999999993e-40 | NR | ACA04822.1 | 497998 | g76647 | i0 | 82.3 | 1.91902834008097 | 79 | 14 | 96 | 0 | 246 | 10 | 59 | 137 | ACA04822.1 alpha-tubulin, partial [Arcella hemisphaerica] | diamond | 474 | 142 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Arcellidae | Arcella | Arcella hemisphaerica | ||
| 8319347 | 8319347 | PRJNA685607_P_NODE_1047_length_1601_cov_5.287958_g912_i0 | PRJNA685607 | 1047 | 1601 | 5.287958 | 84.66020758 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 757 | 8.169999999999998e-272 | NR | BAN33737.1 | 931554 | g912 | i0 | 79.3 | 0.86945658963148 | 464 | 91 | 86 | 1 | 1566 | 190 | 1 | 464 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 1392 | 757 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 10104768 | 10104768 | PRJNA685607_P_NODE_14428_length_424_cov_2.584046_g14070_i0 | PRJNA685607 | 14428 | 424 | 2.584046 | 10.95635504 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 235 | 6.16e-74 | NR | AAP88974.1 | 5775 | g14070 | i0 | 82.3 | 0.919811320754717 | 130 | 23 | 92 | 0 | 31 | 420 | 7 | 136 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 390 | 235 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 15969025 | 15969025 | PRJNA685607_P_NODE_4693_length_716_cov_1.511664_g4365_i0 | PRJNA685607 | 4693 | 716 | 1.511664 | 10.82351424 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 370 | 4.239999999999999e-125 | NR | AAP88974.1 | 5775 | g4365 | i0 | 81.3 | 1.88128491620112 | 224 | 40 | 93.9 | 1 | 715 | 44 | 169 | 390 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 1347 | 370 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 17244214 | 17244214 | PRJNA685607_P_NODE_1614_length_1283_cov_4.082645_g1426_i0 | PRJNA685607 | 1614 | 1283 | 4.082645 | 52.38033535 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 693 | 2.3999999999999992e-248 | NR | BAN33737.1 | 931554 | g1426 | i0 | 80.1 | 5.85035074045207 | 422 | 78 | 97.3 | 1 | 34 | 1281 | 1 | 422 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 7506 | 693 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 18518432 | 18518432 | PRJNA685607_P_NODE_56415_length_266_cov_1.196891_g56056_i0 | PRJNA685607 | 56415 | 266 | 1.196891 | 3.18373006 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 136 | 1.87e-36 | NR | AAP88974.1 | 5775 | g56056 | i0 | 80.3 | 0.857142857142857 | 76 | 15 | 85.7 | 0 | 261 | 34 | 83 | 158 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 228 | 136 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 21068652 | 21068652 | PRJNA685607_P_NODE_1077_length_1584_cov_5.450033_g912_i1 | PRJNA685607 | 1077 | 1584 | 5.450033 | 86.32852272 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 758 | 4.7399999999999985e-272 | NR | BAN33737.1 | 931554 | g912 | i1 | 79.3 | 0.878787878787879 | 464 | 91 | 86.9 | 1 | 19 | 1395 | 1 | 464 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 1392 | 758 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 21068681 | 21068681 | PRJNA685607_P_NODE_18237_length_389_cov_1.218354_g17879_i0 | PRJNA685607 | 18237 | 389 | 1.218354 | 4.73939706 | Chaos carolinense | 160823 | Tubulinea | other_Eukaryota | 197 | 1.29e-60 | NR | AFX73090.1 | 160823 | g17879 | i0 | 75.2 | 1.98971722365039 | 129 | 32 | 99.5 | 0 | 2 | 388 | 3 | 131 | AFX73090.1 elongation factor 2 alpha, partial [Chaos carolinense] | diamond | 774 | 197 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Chaos | Chaos carolinense | ||
| 23619122 | 23619122 | PRJNA685607_P_NODE_21859_length_365_cov_1.263699_g21500_i0 | PRJNA685607 | 21859 | 365 | 1.263699 | 4.61250135 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 204 | 2.17e-63 | NR | AFX84537.1 | 5775 | g21500 | i0 | 79.3 | 0.994520547945206 | 121 | 25 | 99.5 | 0 | 365 | 3 | 122 | 242 | AFX84537.1 alpha tubulin, partial [Amoeba proteus] | diamond | 363 | 204 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 26733639 | 26733639 | PRJNA685607_P_NODE_11001_length_474_cov_1.331671_g10645_i0 | PRJNA685607 | 11001 | 474 | 1.331671 | 6.31212054 | Saccamoeba lacustris | 704142 | Tubulinea | other_Eukaryota | 209 | 1.05e-64 | NR | AFX73097.1 | 704142 | g10645 | i0 | 64.7 | 3.95569620253165 | 156 | 51 | 98.7 | 1 | 470 | 3 | 83 | 234 | AFX73097.1 elongation factor 2 alpha, partial [Saccamoeba lacustris] | diamond | 1875 | 209 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba lacustris | ||
| 28830571 | 28830571 | PRJNA685607_P_NODE_58568_length_262_cov_1.222222_g58209_i0 | PRJNA685607 | 58568 | 262 | 1.222222 | 3.20222164 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 140 | 3.16e-37 | NR | BAN33737.1 | 931554 | g58209 | i0 | 77 | 5.97709923664122 | 87 | 20 | 99.6 | 0 | 262 | 2 | 7 | 93 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 1566 | 140 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 28945665 | 28945665 | PRJNA685607_P_NODE_27788_length_338_cov_1.120755_g27429_i0 | PRJNA685607 | 27788 | 338 | 1.120755 | 3.7881519 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 115 | 4.83e-27 | NR | AAD33718.1 | 5775 | g27429 | i0 | 50.9 | 1.01183431952663 | 114 | 51 | 99.4 | 2 | 336 | 1 | 737 | 847 | AAD33718.1 myosin heavy chain [Amoeba proteus] | diamond | 342 | 115 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 30745736 | 30745736 | PRJNA685607_P_NODE_92194_length_242_cov_0.911243_g91835_i0 | PRJNA685607 | 92194 | 242 | 0.911243 | 2.20520806 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 127 | 3.1e-33 | NR | AAY34140.1 | 5778 | g91835 | i0 | 85 | 0.991735537190083 | 80 | 12 | 99.2 | 0 | 240 | 1 | 256 | 335 | AAY34140.1 Nop58p, partial [Vermamoeba vermiformis] | diamond | 240 | 127 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 32642623 | 32642623 | PRJNA685607_P_NODE_39900_length_300_cov_1.867841_g39541_i0 | PRJNA685607 | 39900 | 300 | 1.867841 | 5.603523 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 171 | 5.28e-49 | NR | BAN33737.1 | 931554 | g39541 | i0 | 79 | 1 | 100 | 21 | 100 | 0 | 300 | 1 | 312 | 411 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 300 | 171 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea |
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);;