metadata: contig_metadata: 7 rows where bioproject = "PRJNA550047", tax_kingdom = "Metazoa" and tax

7 rows where bioproject = "PRJNA550047", tax_kingdom = "Metazoa" and tax_phylum = "Porifera"

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
27204402	27204402	PRJNA550047_P_NODE_61442_length_345_cov_14.488971_g59482_i0	PRJNA550047	61442	345	14.488971	49.98694995	Oscarella lobularis	121494	Porifera	other_Eukaryota	49.7	4.57e-4	NR	XP_065845155.1	121494	g59482	i0	48	1.7304347826087	50	26	43.5	0	195	344	608	657	XP_065845155.1 dedicator of cytokinesis protein 1-like [Oscarella lobularis]	diamond	597	49.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
27882459	27882459	PRJNA550047_P_NODE_86805_length_345_cov_9.819853_g84845_i0	PRJNA550047	86805	345	9.819853	33.87849285	Porifera	6040	Porifera	other_Eukaryota	54.7	7.81e-6	NR	XP_064395912.1	6063	g84845	i0	50	1.97391304347826	46	23	40	0	144	7	197	242	XP_064395912.1 uncharacterized protein LOC135342948 isoform X2 [Halichondria panicea]	diamond	681	55.1	0.992740471869329	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
28513946	28513946	PRJNA550047_P_NODE_113907_length_345_cov_7.246324_g111947_i0	PRJNA550047	113907	345	7.246324	24.9998178	Metazoa	33208	Porifera	other_Eukaryota	119	1.47e-28	NR	KAI6658876.1	111878	g111947	i0	48.5	7.94782608695652	130	50	98.3	1	3	341	447	576	KAI6658876.1 HSP70 [Oopsacas minuta]	diamond	2742	120	0.991666666666667	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
28688790	28688790	PRJNA550047_P_NODE_110907_length_345_cov_7.488971_g108947_i0	PRJNA550047	110907	345	7.488971	25.83694995	Halichondria panicea	6063	Porifera	other_Eukaryota	70.5	2.14e-11	NR	XP_064391030.1	6063	g108947	i0	62	0.434782608695652	50	19	43.5	0	2	151	311	360	XP_064391030.1 putative glycerol kinase 5 isoform X2 [Halichondria panicea]	diamond	150	70.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
29541143	29541143	PRJNA550047_P_NODE_544290_length_215_cov_15.514085_g542317_i0	PRJNA550047	544290	215	15.514085	33.35528275	Oopsacas minuta	111878	Porifera	other_Eukaryota	124	1.43e-32	NR	KAI6651194.1	111878	g542317	i0	77.1	4.82790697674419	70	16	97.7	0	5	214	19	88	KAI6651194.1 hypothetical protein LOD99_5545 [Oopsacas minuta]	diamond	1038	124	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
29825271	29825271	PRJNA550047_P_NODE_526971_length_221_cov_11.668919_g524998_i0	PRJNA550047	526971	221	11.668919	25.78831099	Oopsacas minuta	111878	Porifera	other_Eukaryota	65.5	2.01e-10	NR	KAI6658263.1	111878	g524998	i0	53.6	3.04072398190045	56	26	76	0	168	1	121	176	KAI6658263.1 hypothetical protein LOD99_15532 [Oopsacas minuta]	diamond	672	65.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
31784563	31784563	PRJNA550047_P_NODE_114997_length_345_cov_7.161765_g113037_i0	PRJNA550047	114997	345	7.161765	24.70808925	Halichondria panicea	6063	Porifera	other_Eukaryota	75.9	3.06e-13	NR	XP_064396523.1	6063	g113037	i0	81.8	1.13913043478261	44	8	38.3	0	1	132	305	348	XP_064396523.1 anoctamin-7-like isoform X2 [Halichondria panicea]	diamond	393	75.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea

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