metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1059246" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1059246" 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
4003558	4003558	PRJNA1059246_P_NODE_43484_length_319_cov_1.471545_g42858_i0	PRJNA1059246	43484	319	1.471545	4.69422855	Priapulus caudatus	37621	Priapulida	other_Eukaryota	188	2.9999999999999995e-54	NR	XP_014673112.1	37621	g42858	i0	88.7	62.012539184953	106	12	99.7	0	318	1	162	267	XP_014673112.1 PREDICTED: heat shock 70 kDa protein II-like [Priapulus caudatus]	diamond	19782	189	0.994708994708995	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
18028962	18028962	PRJNA1059246_P_NODE_52175_length_283_cov_0.990476_g51549_i0	PRJNA1059246	52175	283	0.990476	2.80304708	Metazoa	33208	Priapulida	other_Eukaryota	105	3.0499999999999998e-24	NR	XP_014663805.1	37621	g51549	i0	82.8	6.78445229681979	58	10	61.5	0	3	176	459	516	XP_014663805.1 PREDICTED: beta-TrCP-like [Priapulus caudatus]	diamond	1920	106	0.990566037735849	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
27153199	27153199	PRJNA1059246_P_NODE_55462_length_272_cov_1.422111_g54836_i0	PRJNA1059246	55462	272	1.422111	3.86814192	Metazoa	33208	Priapulida	other_Eukaryota	54.3	4.23e-6	NR	XP_014667831.1	37621	g54836	i0	33	3.94852941176471	91	58	99.3	2	1	270	14	102	XP_014667831.1 PREDICTED: uncharacterized protein LOC106809304 [Priapulus caudatus]	diamond	1074	54.3	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
27817136	27817136	PRJNA1059246_P_NODE_27104_length_426_cov_1.016997_g26479_i0	PRJNA1059246	27104	426	1.016997	4.33240722	Metazoa	33208	Priapulida	other_Eukaryota	88.6	3.05e-18	NR	XP_014681859.1	37621	g26479	i0	35.3	9.83802816901408	139	62	97.9	2	1	417	115	225	XP_014681859.1 PREDICTED: Golgi to ER traffic protein 4 homolog isoform X2 [Priapulus caudatus]	diamond	4191	88.6	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
30888543	30888543	PRJNA1059246_P_NODE_66534_length_247_cov_0.885057_g65908_i0	PRJNA1059246	66534	247	0.885057	2.18609079	Priapulus caudatus	37621	Priapulida	other_Eukaryota	54.3	3.24e-6	NR	XP_014671248.1	37621	g65908	i0	36.4	5.23481781376518	66	24	80.2	2	247	50	383	430	XP_014671248.1 PREDICTED: neurogenic locus notch homolog protein 1-like [Priapulus caudatus]	diamond	1293	54.3	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
31109534	31109534	PRJNA1059246_P_NODE_69875_length_243_cov_1.541176_g69249_i0	PRJNA1059246	69875	243	1.541176	3.74505768	Priapulus caudatus	37621	Priapulida	other_Eukaryota	87	9.36e-18	NR	XP_014680940.1	37621	g69249	i0	59.2	5.23456790123457	71	29	87.7	0	26	238	67	137	XP_014680940.1 PREDICTED: cAMP-specific 3',5'-cyclic phosphodiesterase, isoforms N/G-like [Priapulus caudatus]	diamond	1272	87	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
31900313	31900313	PRJNA1059246_P_NODE_41357_length_329_cov_3.023438_g40731_i0	PRJNA1059246	41357	329	3.023438	9.94711102	Priapulus caudatus	37621	Priapulida	other_Eukaryota	52.8	6.13e-6	NR	XP_014678601.1	37621	g40731	i0	35.2	0.829787234042553	91	52	78.4	4	284	27	6	94	XP_014678601.1 PREDICTED: CDGSH iron-sulfur domain-containing protein 2 homolog A-like [Priapulus caudatus]	diamond	273	52.8	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
31995297	31995297	PRJNA1059246_P_NODE_69058_length_244_cov_0.900585_g68432_i0	PRJNA1059246	69058	244	0.900585	2.1974274	Priapulus caudatus	37621	Priapulida	other_Eukaryota	50.4	7.15e-5	NR	XP_014669685.1	37621	g68432	i0	55.6	0.885245901639344	36	15	43	1	106	2	57	92	XP_014669685.1 PREDICTED: nef-associated protein 1-like [Priapulus caudatus]	diamond	216	50.4	1	Eukaryota	Opisthokonta	Metazoa	Priapulida	Priapulimorpha	Priapulimorphida	Priapulidae	Priapulus	Priapulus caudatus
32902832	32902832	PRJNA1059246_P_NODE_23440_length_464_cov_1.803069_g22817_i0	PRJNA1059246	23440	464	1.803069	8.36624016	Metazoa	33208	Priapulida	other_Eukaryota	83.2	1.34e-17	NR	XP_014662384.1	37621	g22817	i0	48.6	3.03879310344828	74	38	47.8	0	84	305	17	90	XP_014662384.1 PREDICTED: lipopolysaccharide-induced tumor necrosis factor-alpha factor homolog [Priapulus caudatus]	diamond	1410	84	0.990476190476191	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);;