metadata: contig_metadata: 5 rows where bioproject = "PRJNA682078", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA682078", 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
28440245	28440245	PRJNA682078_P_NODE_53906_length_467_cov_1.218274_g52135_i0	PRJNA682078	53906	467	1.218274	5.68933958	Oopsacas minuta	111878	Porifera	other_Eukaryota	74.7	6.66e-13	NR	KAI6646063.1	111878	g52135	i0	34.9	3.07708779443255	126	82	80.9	0	381	4	16	141	KAI6646063.1 hypothetical protein LOD99_9511 [Oopsacas minuta]	diamond	1437	74.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
29481734	29481734	PRJNA682078_P_NODE_240530_length_248_cov_1.662857_g238753_i0	PRJNA682078	240530	248	1.662857	4.12388536	Corticium candelabrum	121492	Porifera	other_Eukaryota	72.8	1.04e-12	NR	XP_062513405.1	121492	g238753	i0	49.3	0.883064516129032	73	37	88.3	0	28	246	588	660	XP_062513405.1 uncharacterized protein LOC134189182 [Corticium candelabrum]	diamond	219	72.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
30599149	30599149	PRJNA682078_P_NODE_229733_length_250_cov_0.870056_g227956_i0	PRJNA682078	229733	250	0.870056	2.17514	Metazoa	33208	Porifera	other_Eukaryota	58.9	8.31e-8	NR	XP_064402603.1	6063	g227956	i0	47.1	3.612	68	33	81.6	2	46	249	542	606	XP_064402603.1 uncharacterized protein K02A2.6-like [Halichondria panicea]	diamond	903	58.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
30777261	30777261	PRJNA682078_P_NODE_264414_length_245_cov_0.895349_g262637_i0	PRJNA682078	264414	245	0.895349	2.19360505	Oopsacas minuta	111878	Porifera	other_Eukaryota	63.5	3.66e-10	NR	KAI6651224.1	111878	g262637	i0	43.1	0.795918367346939	65	37	79.6	0	14	208	36	100	KAI6651224.1 Transposase [Oopsacas minuta]	diamond	195	63.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
32105183	32105183	PRJNA682078_P_NODE_170018_length_281_cov_1.004808_g168241_i0	PRJNA682078	170018	281	1.004808	2.82351048	Geodia barretti	519541	Porifera	other_Eukaryota	43.1	0.0409	NR	CAI8025343.1	519541	g168241	i0	30	1.70818505338078	80	53	85.4	1	7	246	301	377	CAI8025343.1 TBC1 domain family member 5 [Geodia barretti]	diamond	480	43.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti

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