metadata: contig_metadata: 9 rows where bioproject = "PRJEB14803" and tax

9 rows where bioproject = "PRJEB14803" and tax_phylum = "Priapulida"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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
3847560	3847560	PRJEB14803_P_NODE_13184_length_340_cov_2.049180_g12719_i0	PRJEB14803	13184	340	2.04918	6.967212	Priapulus caudatus	37621	Priapulida	other_Eukaryota	54.7	0.009	NTclustered	gi\|957861093\|ref\|XM_014823686.1\|	37621	g12719	i0	100	0.0852941176470588	29	0	9	0	97	125	292	264	PREDICTED: Priapulus caudatus putative leucine-rich repeat-containing protein DDB_G0290503 (LOC106819028), mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
7673805	7673805	PRJEB14803_P_NODE_6707_length_522_cov_2.394251_g6260_i0	PRJEB14803	6707	522	2.394251	12.49799022	Priapulus caudatus	37621	Priapulida	other_Eukaryota	110	2.99e-19	NTclustered	gi\|957851544\|ref\|XM_014820516.1\|	37621	g6260	i0	80.556	12.992337164751	144	26	27	2	292	434	89	231	PREDICTED: Priapulus caudatus 26S proteasome complex subunit DSS1-like (LOC106815982), mRNA	blastn	6782	110	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
19146930	19146930	PRJEB14803_P_NODE_24256_length_227_cov_2.645833_g23790_i0	PRJEB14803	24256	227	2.645833	6.00604091	Metazoa	33208	Priapulida	other_Eukaryota	110	7.12e-27	NR	XP_014670397.1	37621	g23790	i0	70.4	7.50660792951542	71	21	93.8	0	1	213	318	388	XP_014670397.1 PREDICTED: actin-related protein 2 [Priapulus caudatus]	diamond	1704	111	0.990990990990991	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
28106915	28106915	PRJEB14803_P_NODE_37665_length_172_cov_1.138686_g37199_i0	PRJEB14803	37665	172	1.138686	1.95853992	Priapulus caudatus	37621	Priapulida	other_Eukaryota	57.4	9.81e-8	NR	XP_014670796.1	37621	g37199	i0	53.8	1.81395348837209	52	21	85.5	1	151	5	560	611	XP_014670796.1 PREDICTED: uncharacterized protein LOC106811606 [Priapulus caudatus]	diamond	312	57.4	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
28953354	28953354	PRJEB14803_P_NODE_19548_length_263_cov_1.741228_g19082_i0	PRJEB14803	19548	263	1.741228	4.57942964	Metazoa	33208	Priapulida	other_Eukaryota	48.5	4.01e-4	NR	XP_014669842.1	37621	g19082	i0	47.3	4.38022813688213	55	12	43.3	1	262	149	255	309	XP_014669842.1 PREDICTED: CCR4-NOT transcription complex subunit 7-like [Priapulus caudatus]	diamond	1152	48.5	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
29016592	29016592	PRJEB14803_P_NODE_9308_length_428_cov_1.513995_g8844_i0	PRJEB14803	9308	428	1.513995	6.4798986	Priapulida	33467	Priapulida	other_Eukaryota	174	1.3599999999999999e-47	NR	XP_014663752.1	37621	g8844	i0	67.4	5.85280373831776	138	45	96.7	0	414	1	326	463	XP_014663752.1 PREDICTED: ABC transporter B family member 25-like isoform X2 [Priapulus caudatus]	diamond	2505	175	0.994285714285714	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
29079501	29079501	PRJEB14803_P_NODE_33568_length_184_cov_2.020134_g33102_i0	PRJEB14803	33568	184	2.020134	3.71704656	Metazoa	33208	Priapulida	other_Eukaryota	80.5	4.48e-16	NR	XP_014665093.1	37621	g33102	i0	71.7	25.4510869565217	60	17	97.8	0	5	184	167	226	XP_014665093.1 PREDICTED: zinc transporter 2-like [Priapulus caudatus]	diamond	4683	80.5	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
32182896	32182896	PRJEB14803_P_NODE_42458_length_160_cov_0.960000_g41992_i0	PRJEB14803	42458	160	0.96	1.536	Priapulus caudatus	37621	Priapulida	other_Eukaryota	68.6	9.37e-12	NR	XP_014662272.1	37621	g41992	i0	51	6.675	49	24	91.9	0	157	11	252	300	XP_014662272.1 PREDICTED: paxillin-like [Priapulus caudatus]	diamond	1068	68.6	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
32625344	32625344	PRJEB14803_P_NODE_28180_length_206_cov_1.456140_g27714_i0	PRJEB14803	28180	206	1.45614	2.9996484	Priapulus caudatus	37621	Priapulida	other_Eukaryota	70.5	3.31e-13	NR	XP_014674802.1	37621	g27714	i0	50.8	0.91747572815534	63	31	91.7	0	7	195	12	74	XP_014674802.1 PREDICTED: xaa-Pro dipeptidase-like [Priapulus caudatus]	diamond	189	70.5	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus

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);;