contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA1120060" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1026129 | 1026129 | PRJNA1120060_P_NODE_2437261_length_256_cov_1.961749_g2419192_i0 | PRJNA1120060 | 2437261 | 256 | 1.961749 | 5.02207744 | Metazoa | 33208 | Hemichordata | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|585710113|ref|XM_002741067.2| | 10224 | g2419192 | i0 | 100 | 6.26953125 | 29 | 0 | 11 | 0 | 8 | 36 | 1318 | 1290 | PREDICTED: Saccoglossus kowalevskii radial spoke head protein 4 homolog A-like (LOC100376902), mRNA | blastn | 1605 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 2782494 | 2782494 | PRJNA1120060_P_NODE_1047543_length_311_cov_4.626050_g1029608_i0 | PRJNA1120060 | 1047543 | 311 | 4.62605 | 14.3870155 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2875694600|ref|XM_070680597.1| | 63121 | g1029608 | i0 | 100 | 0.192926045016077 | 30 | 0 | 10 | 0 | 211 | 240 | 4206 | 4235 | PREDICTED: Ptychodera flava atrial natriuretic peptide receptor 1-like (LOC139117470), transcript variant X2, mRNA | blastn | 60 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 4074754 | 4074754 | PRJNA1120060_P_NODE_2157104_length_266_cov_4.103627_g2139055_i0 | PRJNA1120060 | 2157104 | 266 | 4.103627 | 10.91564782 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2875682698|ref|XM_070725815.1| | 63121 | g2139055 | i0 | 100 | 0.109022556390977 | 29 | 0 | 11 | 0 | 8 | 36 | 657 | 629 | PREDICTED: Ptychodera flava deoxynucleotidyltransferase terminal-interacting protein 2-like (LOC139152582), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 4081858 | 4081858 | PRJNA1120060_P_NODE_2717144_length_248_cov_1.365714_g2699061_i0 | PRJNA1120060 | 2717144 | 248 | 1.365714 | 3.38697072 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|585672726|ref|XM_006818230.1| | 10224 | g2699061 | i0 | 100 | 0.225806451612903 | 28 | 0 | 11 | 0 | 206 | 233 | 3017 | 3044 | PREDICTED: Saccoglossus kowalevskii leucine-rich repeat-containing protein 56-like (LOC100378322), transcript variant X2, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 5338548 | 5338548 | PRJNA1120060_P_NODE_1261945_length_309_cov_1.961864_g1244004_i0 | PRJNA1120060 | 1261945 | 309 | 1.961864 | 6.06215976 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|2875708675|ref|XM_070684926.1| | 63121 | g1244004 | i0 | 100 | 0.0938511326860841 | 29 | 0 | 9 | 0 | 268 | 296 | 2722 | 2750 | PREDICTED: Ptychodera flava uncharacterized protein (LOC139120472), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 5354132 | 5354132 | PRJNA1120060_P_NODE_2387925_length_258_cov_1.367568_g2369860_i0 | PRJNA1120060 | 2387925 | 258 | 1.367568 | 3.52832544 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|585711481|ref|XM_002741225.2| | 10224 | g2369860 | i0 | 100 | 0.112403100775194 | 29 | 0 | 11 | 0 | 213 | 241 | 1369 | 1397 | PREDICTED: Saccoglossus kowalevskii tubulin beta chain-like (LOC100378597), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 5362670 | 5362670 | PRJNA1120060_P_NODE_3110885_length_235_cov_4.462963_g3092783_i0 | PRJNA1120060 | 3110885 | 235 | 4.462963 | 10.48796305 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|585666245|ref|XM_002735201.2| | 10224 | g3092783 | i0 | 100 | 0.123404255319149 | 29 | 0 | 12 | 0 | 67 | 95 | 1489 | 1517 | PREDICTED: Saccoglossus kowalevskii RIB43A-like with coiled-coils protein 2-like (LOC100375219), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 6130070 | 6130070 | PRJNA1120060_P_NODE_636465_length_343_cov_0.729630_g618703_i0 | PRJNA1120060 | 636465 | 343 | 0.72963 | 2.5026309 | Metazoa | 33208 | Hemichordata | other_Eukaryota | 58.4 | 6.97e-4 | NTclustered | gi|2875674006|ref|XM_070721740.1| | 63121 | g618703 | i0 | 97.059 | 8.65889212827988 | 34 | 1 | 10 | 0 | 88 | 121 | 2274 | 2307 | PREDICTED: Ptychodera flava monocarboxylate transporter 2-like (LOC139149767), mRNA | blastn | 2970 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 6627271 | 6627271 | PRJNA1120060_P_NODE_2274786_length_262_cov_1.883598_g2256731_i0 | PRJNA1120060 | 2274786 | 262 | 1.883598 | 4.93502676 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2875689507|ref|XM_070678005.1| | 63121 | g2256731 | i0 | 100 | 6.56488549618321 | 30 | 0 | 11 | 0 | 2 | 31 | 302 | 331 | PREDICTED: Ptychodera flava uncharacterized protein (LOC139115699), transcript variant X1, mRNA | blastn | 1720 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 9181382 | 9181382 | PRJNA1120060_P_NODE_2600268_length_251_cov_1.011236_g2582191_i0 | PRJNA1120060 | 2600268 | 251 | 1.011236 | 2.53820236 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2875669159|ref|XM_070719263.1| | 63121 | g2582191 | i0 | 100 | 0.239043824701195 | 30 | 0 | 12 | 0 | 81 | 110 | 776 | 747 | PREDICTED: Ptychodera flava probable ATP-dependent RNA helicase DDX27 (LOC139148008), mRNA | blastn | 60 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 9182230 | 9182230 | PRJNA1120060_P_NODE_2671168_length_249_cov_1.693182_g2653087_i0 | PRJNA1120060 | 2671168 | 249 | 1.693182 | 4.21602318 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2875736582|ref|XM_070699061.1| | 63121 | g2653087 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 24 | 51 | 341 | 368 | PREDICTED: Ptychodera flava neurofilament heavy polypeptide-like (LOC139132801), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 13010935 | 13010935 | PRJNA1120060_P_NODE_2927271_length_243_cov_1.270588_g2909178_i0 | PRJNA1120060 | 2927271 | 243 | 1.270588 | 3.08752884 | Rhabdopleura sp. f ZBRQ-2024a | 3115532 | Hemichordata | other_Eukaryota | 52.8 | 0.022 | NTclustered | gi|2675821514|gb|PP334099.1| | 3115532 | g2909178 | i0 | 100 | 0.11522633744856 | 28 | 0 | 12 | 0 | 183 | 210 | 13966 | 13993 | Rhabdopleura sp. f ZBRQ-2024a voucher NIWA158157 mitochondrion, partial genome | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Pterobranchia | Rhabdopleurida | Rhabdopleuridae | Rhabdopleura | Rhabdopleura sp. f ZBRQ-2024a | |
| 15565962 | 15565962 | PRJNA1120060_P_NODE_3450493_length_211_cov_5.434783_g3432368_i0 | PRJNA1120060 | 3450493 | 211 | 5.434783 | 11.46739213 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 52.8 | 0.019 | NTclustered | gi|585652697|ref|XM_002733503.2| | 10224 | g3432368 | i0 | 96.774 | 0.146919431279621 | 31 | 1 | 15 | 0 | 26 | 56 | 279 | 249 | PREDICTED: Saccoglossus kowalevskii CWF19-like protein 2-like (LOC100366505), mRNA | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 18083096 | 18083096 | PRJNA1120060_P_NODE_101355_length_567_cov_5.382591_g25669_i6 | PRJNA1120060 | 101355 | 567 | 5.382591 | 30.51929097 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 54.7 | 0.016 | NTclustered | gi|2875675441|ref|XM_070722464.1| | 63121 | g25669 | i6 | 100 | 0.0511463844797178 | 29 | 0 | 5 | 0 | 370 | 398 | 1063 | 1035 | PREDICTED: Ptychodera flava apoptosis-stimulating of p53 protein 1-like (LOC139150228), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 18122575 | 18122575 | PRJNA1120060_P_NODE_764135_length_325_cov_1.630952_g746273_i0 | PRJNA1120060 | 764135 | 325 | 1.630952 | 5.300594 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 58.4 | 6.56e-4 | NTclustered | gi|2875689108|ref|XM_070677796.1| | 63121 | g746273 | i0 | 100 | 0.0953846153846154 | 31 | 0 | 10 | 0 | 106 | 136 | 8617 | 8647 | PREDICTED: Ptychodera flava zinc finger protein 99-like (LOC139115561), mRNA | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 20645606 | 20645606 | PRJNA1120060_P_NODE_190557_length_474_cov_6.279302_g25669_i7 | PRJNA1120060 | 190557 | 474 | 6.279302 | 29.76389148 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 54.7 | 0.013 | NTclustered | gi|2875675441|ref|XM_070722464.1| | 63121 | g25669 | i7 | 100 | 0.0611814345991561 | 29 | 0 | 6 | 0 | 277 | 305 | 1063 | 1035 | PREDICTED: Ptychodera flava apoptosis-stimulating of p53 protein 1-like (LOC139150228), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 20665283 | 20665283 | PRJNA1120060_P_NODE_3540837_length_203_cov_6.261538_g3522710_i0 | PRJNA1120060 | 3540837 | 203 | 6.261538 | 12.71092214 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|2875703133|ref|XM_070703880.1| | 63121 | g3522710 | i0 | 100 | 0.142857142857143 | 29 | 0 | 14 | 0 | 163 | 191 | 1943 | 1971 | PREDICTED: Ptychodera flava uncharacterized protein (LOC139136098), mRNA | blastn | 29 | 54.7 | 1 | 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);;