contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA1148190" and tax_phylum = "Hemichordata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1573010 | 1573010 | PRJNA1148190_P_NODE_644942_length_248_cov_0.880000_g633769_i0 | PRJNA1148190 | 644942 | 248 | 0.88 | 2.1824 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 73.9 | 3.96e-13 | NR | XP_070540000.1 | 63121 | g633769 | i0 | 74.4 | 0.520161290322581 | 43 | 11 | 52 | 0 | 13 | 141 | 415 | 457 | XP_070540000.1 2,3-bisphosphoglycerate-independent phosphoglycerate mutase-like [Ptychodera flava] | diamond | 129 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 11770697 | 11770697 | PRJNA1148190_P_NODE_194270_length_381_cov_1.461039_g183100_i0 | PRJNA1148190 | 194270 | 381 | 1.461039 | 5.56655859 | Metazoa | 33208 | Hemichordata | other_Eukaryota | 82.8 | 1.61e-15 | NR | XP_070562566.1 | 63121 | g183100 | i0 | 72 | 17.3228346456693 | 50 | 14 | 39.4 | 0 | 150 | 1 | 354 | 403 | XP_070562566.1 LOW QUALITY PROTEIN: succinyl-CoA:3-ketoacid coenzyme A transferase 1, mitochondrial-like [Ptychodera flava] | diamond | 6600 | 83.6 | 0.990430622009569 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 18150407 | 18150407 | PRJNA1148190_P_NODE_66535_length_690_cov_1.777958_g55480_i0 | PRJNA1148190 | 66535 | 690 | 1.777958 | 12.2679102 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 337 | 1.8400000000000001e-109 | NR | XP_070535478.1 | 63121 | g55480 | i0 | 70.3 | 127.85652173913 | 229 | 68 | 99.6 | 0 | 3 | 689 | 9 | 237 | XP_070535478.1 GTP-binding protein 4-like [Ptychodera flava] | diamond | 88221 | 338 | 0.997041420118343 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 26996164 | 26996164 | PRJNA1148190_P_NODE_687402_length_246_cov_0.890173_g676229_i0 | PRJNA1148190 | 687402 | 246 | 0.890173 | 2.18982558 | Metazoa | 33208 | Hemichordata | other_Eukaryota | 51.6 | 2.75e-5 | NR | XP_006822105.1 | 10224 | g676229 | i0 | 46 | 2.47560975609756 | 50 | 27 | 61 | 0 | 77 | 226 | 155 | 204 | XP_006822105.1 PREDICTED: RNA-directed DNA polymerase from mobile element jockey-like, partial [Saccoglossus kowalevskii] | diamond | 609 | 52 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 27628444 | 27628444 | PRJNA1148190_P_NODE_329724_length_308_cov_1.310638_g318551_i0 | PRJNA1148190 | 329724 | 308 | 1.310638 | 4.03676504 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 165 | 1.32e-47 | NR | NP_001171749.1 | 10224 | g318551 | i0 | 77.5 | 35.7467532467532 | 102 | 23 | 99.4 | 0 | 2 | 307 | 124 | 225 | NP_001171749.1 pyruvate dehydrogenase E1 component subunit beta, mitochondrial [Saccoglossus kowalevskii] | diamond | 11010 | 166 | 0.993975903614458 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 27703588 | 27703588 | PRJNA1148190_P_NODE_566464_length_254_cov_1.276243_g555291_i0 | PRJNA1148190 | 566464 | 254 | 1.276243 | 3.24165722 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 45.4 | 0.00479 | NR | XP_006814467.1 | 10224 | g555291 | i0 | 67.2 | 0.68503937007874 | 58 | 19 | 68.5 | 0 | 3 | 176 | 274 | 331 | XP_006814467.1 PREDICTED: radial spoke head 10 homolog B-like, partial [Saccoglossus kowalevskii] | diamond | 174 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 28322806 | 28322806 | PRJNA1148190_P_NODE_472526_length_272_cov_1.271357_g461353_i0 | PRJNA1148190 | 472526 | 272 | 1.271357 | 3.45809104 | Metazoa | 33208 | Hemichordata | other_Eukaryota | 46.6 | 0.00232 | NR | XP_070540329.1 | 63121 | g461353 | i0 | 32.8 | 1.40073529411765 | 61 | 41 | 67.3 | 0 | 23 | 205 | 162 | 222 | XP_070540329.1 uncharacterized protein [Ptychodera flava] | diamond | 381 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 28397910 | 28397910 | PRJNA1148190_P_NODE_609846_length_250_cov_0.870056_g598673_i0 | PRJNA1148190 | 609846 | 250 | 0.870056 | 2.17514 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 43.1 | 0.0315 | NR | XP_006813086.1 | 10224 | g598673 | i0 | 38.2 | 1.32 | 55 | 32 | 66 | 1 | 183 | 19 | 4378 | 4430 | XP_006813086.1 PREDICTED: dystonin isoform X1 [Saccoglossus kowalevskii] | diamond | 330 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 28575466 | 28575466 | PRJNA1148190_P_NODE_585347_length_251_cov_0.865169_g574174_i0 | PRJNA1148190 | 585347 | 251 | 0.865169 | 2.17157419 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 42.7 | 0.038 | NR | XP_006823943.1 | 10224 | g574174 | i0 | 75 | 1.13545816733068 | 24 | 6 | 28.7 | 0 | 145 | 216 | 69 | 92 | XP_006823943.1 PREDICTED: methylglutaconyl-CoA hydratase, mitochondrial-like [Saccoglossus kowalevskii] | diamond | 285 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 28870941 | 28870941 | PRJNA1148190_P_NODE_310588_length_315_cov_1.822314_g299415_i0 | PRJNA1148190 | 310588 | 315 | 1.822314 | 5.7402891 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 48.5 | 7.81e-4 | NR | XP_006826002.1 | 10224 | g299415 | i0 | 35.1 | 0.895238095238095 | 94 | 51 | 89.5 | 2 | 24 | 305 | 180 | 263 | XP_006826002.1 PREDICTED: pre-mRNA-processing factor 17-like [Saccoglossus kowalevskii] | diamond | 282 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 29882533 | 29882533 | PRJNA1148190_P_NODE_94191_length_553_cov_2.195833_g83044_i0 | PRJNA1148190 | 94191 | 553 | 2.195833 | 12.14295649 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 75.1 | 4.64e-12 | NR | XP_070575974.1 | 63121 | g83044 | i0 | 52 | 1.1880650994575 | 75 | 27 | 35.8 | 1 | 142 | 339 | 41 | 115 | XP_070575974.1 heat shock factor protein-like isoform X5 [Ptychodera flava] | diamond | 657 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 30387678 | 30387678 | PRJNA1148190_P_NODE_492733_length_268_cov_1.348718_g481560_i0 | PRJNA1148190 | 492733 | 268 | 1.348718 | 3.61456424 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 42.7 | 0.0467 | NR | XP_070560072.1 | 63121 | g481560 | i0 | 32.4 | 0.794776119402985 | 71 | 47 | 79.5 | 1 | 228 | 16 | 100 | 169 | XP_070560072.1 deoxynucleoside triphosphate triphosphohydrolase SAMHD1-like [Ptychodera flava] | diamond | 213 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 30513117 | 30513117 | PRJNA1148190_P_NODE_235233_length_352_cov_1.103943_g224063_i0 | PRJNA1148190 | 235233 | 352 | 1.103943 | 3.88587936 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 68.9 | 8.86e-11 | NR | XP_070578508.1 | 63121 | g224063 | i0 | 47 | 0.5625 | 66 | 33 | 56.3 | 1 | 145 | 342 | 683 | 746 | XP_070578508.1 CCAAT/enhancer-binding protein zeta-like [Ptychodera flava] | diamond | 198 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 30545627 | 30545627 | PRJNA1148190_P_NODE_722653_length_244_cov_0.900585_g711480_i0 | PRJNA1148190 | 722653 | 244 | 0.900585 | 2.1974274 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 68.9 | 1.47e-11 | NR | XP_002740734.1 | 10224 | g711480 | i0 | 62.5 | 0.590163934426229 | 48 | 18 | 59 | 0 | 239 | 96 | 198 | 245 | XP_002740734.1 PREDICTED: gamma-glutamyl hydrolase-like [Saccoglossus kowalevskii] | diamond | 144 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 30987843 | 30987843 | PRJNA1148190_P_NODE_589494_length_251_cov_0.865169_g578321_i0 | PRJNA1148190 | 589494 | 251 | 0.865169 | 2.17157419 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 58.2 | 1.52e-7 | NR | XP_070541096.1 | 63121 | g578321 | i0 | 40.6 | 5.21115537848606 | 64 | 31 | 68.1 | 1 | 19 | 189 | 624 | 687 | XP_070541096.1 E3 ubiquitin-protein ligase RNF38-like isoform X1 [Ptychodera flava] | diamond | 1308 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 31050386 | 31050386 | PRJNA1148190_P_NODE_118355_length_486_cov_1.038741_g107193_i0 | PRJNA1148190 | 118355 | 486 | 1.038741 | 5.04828126 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 67.4 | 1.19e-9 | NR | XP_070567441.1 | 63121 | g107193 | i0 | 29.9 | 1.95061728395062 | 117 | 75 | 69.8 | 2 | 478 | 140 | 115 | 228 | XP_070567441.1 uncharacterized protein [Ptychodera flava] | diamond | 948 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 31051501 | 31051501 | PRJNA1148190_P_NODE_763195_length_242_cov_0.911243_g752022_i0 | PRJNA1148190 | 763195 | 242 | 0.911243 | 2.20520806 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 52.8 | 1.04e-5 | NR | XP_006812459.1 | 10224 | g752022 | i0 | 44.4 | 2.05785123966942 | 81 | 39 | 94.2 | 4 | 242 | 15 | 68 | 147 | XP_006812459.1 PREDICTED: DNA-directed RNA polymerase I subunit RPA49-like [Saccoglossus kowalevskii] | diamond | 498 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 32030810 | 32030810 | PRJNA1148190_P_NODE_225238_length_358_cov_1.343860_g214068_i0 | PRJNA1148190 | 225238 | 358 | 1.34386 | 4.8110188 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 54.7 | 8.33e-6 | NR | XP_070541506.1 | 63121 | g214068 | i0 | 60 | 0.335195530726257 | 40 | 16 | 33.5 | 0 | 237 | 356 | 73 | 112 | XP_070541506.1 nucleotide exchange factor SIL1-like [Ptychodera flava] | diamond | 120 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 32304482 | 32304482 | PRJNA1148190_P_NODE_464239_length_273_cov_2.680000_g453066_i0 | PRJNA1148190 | 464239 | 273 | 2.68 | 7.3164 | Opisthokonta | 33154 | Hemichordata | other_Eukaryota | 57.8 | 2.58e-7 | NR | XP_070579665.1 | 63121 | g453066 | i0 | 74.3 | 4.18681318681319 | 35 | 9 | 38.5 | 0 | 237 | 133 | 308 | 342 | XP_070579665.1 large ribosomal subunit protein uL3-like [Ptychodera flava] | diamond | 1143 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 32588990 | 32588990 | PRJNA1148190_P_NODE_283119_length_327_cov_1.437008_g271948_i0 | PRJNA1148190 | 283119 | 327 | 1.437008 | 4.69901616 | Metazoa | 33208 | Hemichordata | other_Eukaryota | 64.7 | 1.82e-9 | NR | XP_070569165.1 | 63121 | g271948 | i0 | 61.7 | 5.60550458715596 | 47 | 18 | 43.1 | 0 | 143 | 3 | 283 | 329 | XP_070569165.1 arginyl-tRNA--protein transferase 1-like isoform X2 [Ptychodera flava] | diamond | 1833 | 65.1 | 0.993855606758833 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava |
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);;