contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA493827" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3022358 | 3022358 | PRJNA493827_P_NODE_193343_length_249_cov_1.056818_g191145_i0 | PRJNA493827 | 193343 | 249 | 1.056818 | 2.63147682 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 76.8 | 1.34e-9 | NTclustered | gi|585648419|ref|XM_002732897.2| | 10224 | g191145 | i0 | 94 | 0.200803212851406 | 50 | 3 | 20 | 0 | 62 | 111 | 239 | 288 | PREDICTED: Saccoglossus kowalevskii 116 kDa U5 small nuclear ribonucleoprotein component-like (LOC100378261), mRNA | blastn | 50 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 6850606 | 6850606 | PRJNA493827_P_NODE_43746_length_547_cov_1.822785_g41560_i0 | PRJNA493827 | 43746 | 547 | 1.822785 | 9.97063395 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 65.8 | 6.91e-6 | NTclustered | gi|585650273|ref|XM_006814484.1| | 10224 | g41560 | i0 | 95.122 | 0.0749542961608775 | 41 | 2 | 7 | 0 | 180 | 220 | 2557 | 2597 | PREDICTED: Saccoglossus kowalevskii multidrug resistance protein 2-like (LOC100368266), mRNA | blastn | 41 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 10675094 | 10675094 | PRJNA493827_P_NODE_187869_length_250_cov_1.807910_g185671_i0 | PRJNA493827 | 187869 | 250 | 1.80791 | 4.519775 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 84.2 | 8.03e-12 | NTclustered | gi|585691881|ref|XM_006821267.1| | 10224 | g185671 | i0 | 76.871 | 3.68 | 147 | 34 | 59 | 0 | 65 | 211 | 7132 | 7278 | PREDICTED: Saccoglossus kowalevskii serine/threonine-protein kinase SMG1-like (LOC102809421), mRNA | blastn | 920 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 17050284 | 17050284 | PRJNA493827_P_NODE_44094_length_544_cov_5.127389_g41907_i0 | PRJNA493827 | 44094 | 544 | 5.127389 | 27.89299616 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 65.8 | 6.87e-6 | NTclustered | gi|585643258|ref|XM_002730519.2| | 10224 | g41907 | i0 | 90 | 0.275735294117647 | 50 | 5 | 9 | 0 | 385 | 434 | 524 | 573 | PREDICTED: Saccoglossus kowalevskii 14-3-3-like protein 2-like (LOC100373095), transcript variant X1, mRNA | blastn | 150 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 22147741 | 22147741 | PRJNA493827_P_NODE_180098_length_254_cov_1.309392_g177900_i0 | PRJNA493827 | 180098 | 254 | 1.309392 | 3.32585568 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 248 | 2.74e-61 | NTclustered | gi|2875677321|ref|XM_070723428.1| | 63121 | g177900 | i0 | 85.366 | 100.188976377953 | 246 | 28 | 95 | 8 | 13 | 254 | 608 | 367 | PREDICTED: Ptychodera flava actin, non-muscle 6.2 (LOC139150945), transcript variant X1, mRNA | blastn | 25448 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 23424393 | 23424393 | PRJNA493827_P_NODE_21559_length_834_cov_2.768725_g19746_i0 | PRJNA493827 | 21559 | 834 | 2.768725 | 23.0911665 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 78.7 | 1.38e-9 | NTclustered | gi|2875709116|ref|XM_070685159.1| | 63121 | g19746 | i0 | 92.727 | 0.065947242206235 | 55 | 3 | 6 | 1 | 109 | 162 | 3298 | 3244 | PREDICTED: Ptychodera flava protein FAM184A-like (LOC139120641), mRNA | blastn | 55 | 78.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);;