contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA379145" and tax_phylum = "Xenacoelomorpha"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6778908 | 6778908 | PRJNA379145_P_NODE_726_length_2654_cov_4.752766_g606_i0 | PRJNA379145 | 726 | 2654 | 4.752766 | 126.13840964 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 156 | 4.2999999999999995e-36 | NR | XP_063712757.1 | 84072 | g606 | i0 | 47.6 | 0.19216277317257 | 170 | 84 | 19.1 | 3 | 1315 | 1821 | 308 | 473 | XP_063712757.1 uncharacterized protein LOC134840704 [Symsagittifera roscoffensis] | diamond | 510 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 26790223 | 26790223 | PRJNA379145_P_NODE_3841_length_1487_cov_7.784732_g3347_i0 | PRJNA379145 | 3841 | 1487 | 7.784732 | 115.75896484 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 53.1 | 0.00243 | NR | XP_063726532.1 | 84072 | g3347 | i0 | 37.3 | 0.421654337592468 | 83 | 46 | 15.9 | 3 | 1405 | 1169 | 249 | 329 | XP_063726532.1 uncharacterized protein LOC134854268 [Symsagittifera roscoffensis] | diamond | 627 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27106427 | 27106427 | PRJNA379145_P_NODE_5362_length_1302_cov_2.160757_g4705_i0 | PRJNA379145 | 5362 | 1302 | 2.160757 | 28.13305614 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 162 | 3.88e-40 | NR | XP_063712757.1 | 84072 | g4705 | i0 | 41.7 | 0.569124423963134 | 247 | 125 | 56 | 7 | 745 | 17 | 299 | 530 | XP_063712757.1 uncharacterized protein LOC134840704 [Symsagittifera roscoffensis] | diamond | 741 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27422887 | 27422887 | PRJNA379145_P_NODE_683_length_2700_cov_27.387702_g569_i0 | PRJNA379145 | 683 | 2700 | 27.387702 | 739.467954 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 171 | 4.069999999999999e-41 | NR | XP_063712757.1 | 84072 | g569 | i0 | 33.3 | 2.02888888888889 | 330 | 203 | 35.7 | 7 | 1459 | 497 | 228 | 549 | XP_063712757.1 uncharacterized protein LOC134840704 [Symsagittifera roscoffensis] | diamond | 5478 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27565804 | 27565804 | PRJNA379145_P_NODE_61284_length_184_cov_1.920530_g59130_i0 | PRJNA379145 | 61284 | 184 | 1.92053 | 3.5337752 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 49.7 | 5.87e-5 | NR | XP_063715445.1 | 84072 | g59130 | i0 | 44.8 | 2.73913043478261 | 58 | 27 | 94.6 | 2 | 9 | 182 | 457 | 509 | XP_063715445.1 ATP-binding cassette sub-family F member 1-like [Symsagittifera roscoffensis] | diamond | 504 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 27738721 | 27738721 | PRJNA379145_P_NODE_5924_length_1246_cov_2.204452_g4705_i1 | PRJNA379145 | 5924 | 1246 | 2.204452 | 27.46747192 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 156 | 2.35e-38 | NR | XP_063712757.1 | 84072 | g4705 | i1 | 42.4 | 0.556179775280899 | 231 | 114 | 54.7 | 7 | 550 | 1230 | 315 | 530 | XP_063712757.1 uncharacterized protein LOC134840704 [Symsagittifera roscoffensis] | diamond | 693 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 28369701 | 28369701 | PRJNA379145_P_NODE_17146_length_668_cov_2.757480_g15413_i0 | PRJNA379145 | 17146 | 668 | 2.75748 | 18.4199664 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 50.1 | 0.00364 | NR | XP_063712757.1 | 84072 | g15413 | i0 | 40.7 | 0.844311377245509 | 54 | 31 | 23.8 | 1 | 667 | 509 | 416 | 469 | XP_063712757.1 uncharacterized protein LOC134840704 [Symsagittifera roscoffensis] | diamond | 564 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 28797101 | 28797101 | PRJNA379145_P_NODE_11787_length_863_cov_8.007229_g10454_i0 | PRJNA379145 | 11787 | 863 | 8.007229 | 69.10238627 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 215 | 1.92e-65 | NR | XP_063716466.1 | 84072 | g10454 | i0 | 70.1 | 3.75086906141367 | 154 | 44 | 53.2 | 2 | 845 | 387 | 1 | 153 | XP_063716466.1 N-alpha-acetyltransferase daf-31-like [Symsagittifera roscoffensis] | diamond | 3237 | 216 | 0.99537037037037 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 28811586 | 28811586 | PRJNA379145_P_NODE_71888_length_155_cov_1.516393_g69733_i0 | PRJNA379145 | 71888 | 155 | 1.516393 | 2.35040915 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 54.7 | 6.75e-7 | NR | XP_063710428.1 | 84072 | g69733 | i0 | 46.3 | 5.80645161290323 | 54 | 26 | 98.7 | 1 | 153 | 1 | 221 | 274 | XP_063710428.1 b(0,+)-type amino acid transporter 1-like [Symsagittifera roscoffensis] | diamond | 900 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 29317033 | 29317033 | PRJNA379145_P_NODE_42529_length_282_cov_2.562249_g40377_i0 | PRJNA379145 | 42529 | 282 | 2.562249 | 7.22554218 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 106 | 1.73e-24 | NR | XP_063712757.1 | 84072 | g40377 | i0 | 58.2 | 0.840425531914894 | 79 | 33 | 84 | 0 | 241 | 5 | 341 | 419 | XP_063712757.1 uncharacterized protein LOC134840704 [Symsagittifera roscoffensis] | diamond | 237 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 29917179 | 29917179 | PRJNA379145_P_NODE_48811_length_240_cov_2.014493_g46657_i0 | PRJNA379145 | 48811 | 240 | 2.014493 | 4.8347832 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 60.8 | 1.05e-9 | NR | XP_063718067.1 | 84072 | g46657 | i0 | 44.1 | 1.1625 | 59 | 30 | 73.8 | 1 | 180 | 4 | 32 | 87 | XP_063718067.1 NAD-dependent deacetylase sir2A-like [Symsagittifera roscoffensis] | diamond | 279 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 30074742 | 30074742 | PRJNA379145_P_NODE_1132_length_2296_cov_31.896156_g956_i0 | PRJNA379145 | 1132 | 2296 | 31.896156 | 732.33574176 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 191 | 1.8099999999999994e-48 | NR | XP_063712757.1 | 84072 | g956 | i0 | 36.5 | 0.440331010452962 | 337 | 197 | 43.2 | 7 | 1121 | 129 | 227 | 552 | XP_063712757.1 uncharacterized protein LOC134840704 [Symsagittifera roscoffensis] | diamond | 1011 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 30485783 | 30485783 | PRJNA379145_P_NODE_64193_length_175_cov_1.521127_g62039_i0 | PRJNA379145 | 64193 | 175 | 1.521127 | 2.66197225 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 77.4 | 8.69e-15 | NR | XP_063715760.1 | 84072 | g62039 | i0 | 61.4 | 0.977142857142857 | 57 | 22 | 97.7 | 0 | 3 | 173 | 794 | 850 | XP_063715760.1 DNA-directed RNA polymerase II subunit RPB2 [Symsagittifera roscoffensis] | diamond | 171 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 30991320 | 30991320 | PRJNA379145_P_NODE_27274_length_457_cov_1.978774_g25204_i0 | PRJNA379145 | 27274 | 457 | 1.978774 | 9.04299718 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 46.2 | 0.0189 | NR | XP_063712757.1 | 84072 | g25204 | i0 | 58.8 | 0.223194748358862 | 34 | 14 | 22.3 | 0 | 200 | 99 | 394 | 427 | XP_063712757.1 uncharacterized protein LOC134840704 [Symsagittifera roscoffensis] | diamond | 102 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 31117368 | 31117368 | PRJNA379145_P_NODE_59275_length_191_cov_2.696203_g57121_i0 | PRJNA379145 | 59275 | 191 | 2.696203 | 5.14974773 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 82 | 2.63e-16 | NR | XP_063712757.1 | 84072 | g57121 | i0 | 55.6 | 4.90052356020942 | 63 | 28 | 99 | 0 | 3 | 191 | 379 | 441 | XP_063712757.1 uncharacterized protein LOC134840704 [Symsagittifera roscoffensis] | diamond | 936 | 82.4 | 0.995145631067961 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 31402395 | 31402395 | PRJNA379145_P_NODE_676_length_2712_cov_5.322135_g563_i0 | PRJNA379145 | 676 | 2712 | 5.322135 | 144.3363012 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 168 | 6.15e-40 | NR | XP_063712757.1 | 84072 | g563 | i0 | 37.9 | 0.580752212389381 | 280 | 161 | 30.9 | 6 | 1087 | 1923 | 179 | 446 | XP_063712757.1 uncharacterized protein LOC134840704 [Symsagittifera roscoffensis] | diamond | 1575 | 168 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 31623503 | 31623503 | PRJNA379145_P_NODE_25456_length_488_cov_2.008791_g23417_i0 | PRJNA379145 | 25456 | 488 | 2.008791 | 9.80290008 | Paratomella rubra | 90914 | Xenacoelomorpha | other_Eukaryota | 134 | 5.26e-34 | NR | ACU55154.1 | 90914 | g23417 | i0 | 42.1 | 7.94262295081967 | 159 | 85 | 95.3 | 3 | 23 | 487 | 74 | 229 | ACU55154.1 sodium/potassium ATPase alpha subunit, partial [Paratomella rubra] | diamond | 3876 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Paratomellidae | Paratomella | Paratomella rubra | ||
| 31654982 | 31654982 | PRJNA379145_P_NODE_13917_length_774_cov_2.726046_g12403_i0 | PRJNA379145 | 13917 | 774 | 2.726046 | 21.09959604 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 50.8 | 0.00324 | NR | XP_063712757.1 | 84072 | g12403 | i0 | 40 | 0.213178294573643 | 55 | 32 | 20.9 | 1 | 773 | 612 | 416 | 470 | XP_063712757.1 uncharacterized protein LOC134840704 [Symsagittifera roscoffensis] | diamond | 165 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 32020313 | 32020313 | PRJNA379145_P_NODE_57838_length_197_cov_1.835366_g55684_i0 | PRJNA379145 | 57838 | 197 | 1.835366 | 3.61567102 | Metazoa | 33208 | Xenacoelomorpha | other_Eukaryota | 88.6 | 1.42e-18 | NR | XP_063712757.1 | 84072 | g55684 | i0 | 62.5 | 1.96446700507614 | 64 | 24 | 97.5 | 0 | 1 | 192 | 374 | 437 | XP_063712757.1 uncharacterized protein LOC134840704 [Symsagittifera roscoffensis] | diamond | 387 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 32382896 | 32382896 | PRJNA379145_P_NODE_68659_length_163_cov_1.246154_g66505_i0 | PRJNA379145 | 68659 | 163 | 1.246154 | 2.03123102 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 58.2 | 7.64e-9 | NR | XP_063728427.1 | 84072 | g66505 | i0 | 57.8 | 2.48466257668712 | 45 | 19 | 82.8 | 0 | 152 | 18 | 5 | 49 | XP_063728427.1 glutathione S-transferase B-like [Symsagittifera roscoffensis] | diamond | 405 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis | ||
| 32495014 | 32495014 | PRJNA379145_P_NODE_19299_length_613_cov_2.274138_g17458_i0 | PRJNA379145 | 19299 | 613 | 2.274138 | 13.94046594 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 103 | 1.0100000000000002e-21 | NR | XP_063714287.1 | 84072 | g17458 | i0 | 34.7 | 4.46818923327896 | 147 | 95 | 71.5 | 1 | 1 | 438 | 117 | 263 | XP_063714287.1 LOW QUALITY PROTEIN: ran-binding protein 10-like [Symsagittifera roscoffensis] | diamond | 2739 | 104 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis |
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);;