metadata: contig_metadata: 8 rows where bioproject = "PRJNA575566", tax_clade = "Opisthokonta" and tax

8 rows where bioproject = "PRJNA575566", tax_clade = "Opisthokonta" 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
560092	560092	PRJNA575566_P_NODE_21221_length_227_cov_1.156627_g21024_i0	PRJNA575566	21221	227	1.156627	2.62554329	Dysidea avara	196820	Porifera	other_Eukaryota	62.1	3.36e-5	NTclustered	gi\|2749576058\|ref\|XM_066054339.1\|	196820	g21024	i0	94.872	0.171806167400881	39	2	17	0	188	226	918	956	PREDICTED: Dysidea avara pseudouridylate synthase 7 homolog (LOC136260550), mRNA	blastn	39	62.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
1835336	1835336	PRJNA575566_P_NODE_12682_length_295_cov_1.072650_g12485_i0	PRJNA575566	12682	295	1.07265	3.1643175	Opisthokonta	33154	Porifera	other_Eukaryota	171	8.38e-51	NR	XP_065846395.1	121494	g12485	i0	78.4	27.5796610169492	97	21	98.6	0	293	3	71	167	XP_065846395.1 large ribosomal subunit protein uL16-like [Oscarella lobularis]	diamond	8136	171	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
10764540	10764540	PRJNA575566_P_NODE_8689_length_355_cov_3.241497_g8492_i0	PRJNA575566	8689	355	3.241497	11.50731435	Pseudocorticium jarrei	61082	Porifera	other_Eukaryota	113	1.52e-20	NTclustered	gi\|308912677\|gb\|HQ269357.1\|	61082	g8492	i0	89.011	17.4225352112676	91	10	26	0	265	355	12569	12479	Pseudocorticium jarrei isolate DL028 mitochondrion, complete genome	blastn	6185	113	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Pseudocorticium	Pseudocorticium jarrei
27269124	27269124	PRJNA575566_P_NODE_13383_length_287_cov_1.699115_g13186_i0	PRJNA575566	13383	287	1.699115	4.87646005	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	115	1.47e-30	NR	XP_003388638.1	400682	g13186	i0	63.5	0.888501742160279	85	31	88.9	0	281	27	14	98	XP_003388638.1 PREDICTED: 40S ribosomal protein S10-like [Amphimedon queenslandica]	diamond	255	115	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
27566942	27566942	PRJNA575566_P_NODE_13704_length_284_cov_1.210762_g13507_i0	PRJNA575566	13704	284	1.210762	3.43856408	Opisthokonta	33154	Porifera	other_Eukaryota	128	4.709999999999999e-32	NR	XP_065917099.1	196820	g13507	i0	71.3	8.76760563380282	94	27	99.3	0	282	1	275	368	XP_065917099.1 endoplasmic reticulum chaperone BiP-like [Dysidea avara]	diamond	2490	128	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
27774678	27774678	PRJNA575566_P_NODE_10264_length_326_cov_1.909434_g10067_i0	PRJNA575566	10264	326	1.909434	6.22475484	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	82	1.6e-15	NR	XP_011404797.1	400682	g10067	i0	47.1	2.82515337423313	85	45	78.2	0	324	70	51	135	XP_011404797.1 PREDICTED: filamin-A-like [Amphimedon queenslandica]	diamond	921	82	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
31628123	31628123	PRJNA575566_P_NODE_25356_length_207_cov_1.671233_g25159_i0	PRJNA575566	25356	207	1.671233	3.45945231	Oopsacas minuta	111878	Porifera	other_Eukaryota	92.8	2.55e-20	NR	KAI6661215.1	111878	g25159	i0	67.6	0.985507246376812	68	22	98.6	0	206	3	135	202	KAI6661215.1 Ribosomal protein L4/L1 family [Oopsacas minuta]	diamond	204	92.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
32766096	32766096	PRJNA575566_P_NODE_29000_length_202_cov_0.907801_g28803_i0	PRJNA575566	29000	202	0.907801	1.83375802	Halichondria panicea	6063	Porifera	other_Eukaryota	47	4.11e-4	NR	XP_064396276.1	6063	g28803	i0	46.2	0.965346534653465	65	30	92.1	4	200	15	23	85	XP_064396276.1 uncharacterized protein LOC135343210 [Halichondria panicea]	diamond	195	47	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);;