metadata: contig_metadata: 10 rows where bioproject = "PRJNA1132896", tax_clade = "Opisthokonta" and tax

10 rows where bioproject = "PRJNA1132896", 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
7936623	7936623	PRJNA1132896_P_NODE_2287_length_360_cov_5.885017_g2196_i0	PRJNA1132896	2287	360	5.885017	21.1860612	Demospongiae	6042	Porifera	other_Eukaryota	174	1.0699999999999996e-52	NR	XP_065898136.1	196820	g2196	i0	74.6	4.78333333333333	114	29	95	0	18	359	1	114	XP_065898136.1 small ribosomal subunit protein eS8-like [Dysidea avara]	diamond	1722	174	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
10487194	10487194	PRJNA1132896_P_NODE_909_length_541_cov_4.205128_g818_i0	PRJNA1132896	909	541	4.205128	22.74974248	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	258	1.37e-84	NR	XP_065908390.1	196820	g818	i0	68.7	23.90573012939	179	56	99.3	0	540	4	11	189	XP_065908390.1 large ribosomal subunit protein uL13-like [Dysidea avara]	diamond	12933	259	0.996138996138996	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
18135428	18135428	PRJNA1132896_P_NODE_8075_length_247_cov_1.327586_g7984_i0	PRJNA1132896	8075	247	1.327586	3.27913742	Sycon ciliatum	27933	Porifera	other_Eukaryota	102	2.19e-17	NTclustered	gi\|2732940014\|ref\|XM_065337196.1\|	27933	g7984	i0	83.186	2.53846153846154	113	17	45	2	116	227	1034	923	PREDICTED: Sycon ciliatum procathepsin L-like (LOC135824458), mRNA	blastn	627	102	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
27564744	27564744	PRJNA1132896_P_NODE_1824_length_397_cov_1.959877_g1733_i0	PRJNA1132896	1824	397	1.959877	7.78071169	Metazoa	33208	Porifera	other_Eukaryota	144	6.76e-37	NR	KAI6649799.1	111878	g1733	i0	64.4	2.41813602015113	104	34	77.1	2	385	80	7	109	KAI6649799.1 hypothetical protein LOD99_6588 [Oopsacas minuta]	diamond	960	144	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
27702483	27702483	PRJNA1132896_P_NODE_6164_length_258_cov_1.664865_g6073_i0	PRJNA1132896	6164	258	1.664865	4.2953517	Halichondria panicea	6063	Porifera	other_Eukaryota	46.6	0.00199	NR	XP_064401596.1	6063	g6073	i0	42.4	0.767441860465116	66	36	74.4	1	36	227	153	218	XP_064401596.1 uncharacterized protein LOC135347509 [Halichondria panicea]	diamond	198	46.6	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
28291025	28291025	PRJNA1132896_P_NODE_786_length_579_cov_2.907115_g696_i0	PRJNA1132896	786	579	2.907115	16.83219585	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	215	7.529999999999999e-67	NR	XP_062521049.1	121492	g696	i0	56.7	13.5958549222798	187	81	96.9	0	561	1	27	213	XP_062521049.1 large ribosomal subunit protein uL30-like [Corticium candelabrum]	diamond	7872	217	0.990783410138249	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
28744113	28744113	PRJNA1132896_P_NODE_1447_length_438_cov_1.035616_g1356_i0	PRJNA1132896	1447	438	1.035616	4.53599808	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	118	1.4e-27	NR	XP_019848677.1	400682	g1356	i0	43	1.08219178082192	158	74	100	4	1	438	380	533	XP_019848677.1 PREDICTED: probable alpha-glucosidase Os06g0675700 [Amphimedon queenslandica]	diamond	474	118	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
29975562	29975562	PRJNA1132896_P_NODE_6191_length_258_cov_1.275676_g6100_i0	PRJNA1132896	6191	258	1.275676	3.29124408	Corticium candelabrum	121492	Porifera	other_Eukaryota	116	1.9499999999999999e-31	NR	XP_062521640.1	121492	g6100	i0	63.8	1.09302325581395	94	24	97.7	2	5	256	5	98	XP_062521640.1 uncharacterized protein LOC134196512 [Corticium candelabrum]	diamond	282	116	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
30122492	30122492	PRJNA1132896_P_NODE_2892_length_327_cov_1.736220_g2801_i0	PRJNA1132896	2892	327	1.73622	5.6774394	root	1	Root_unresolved	Root_unresolved	47.4	0.00249	NR	KAI6661894.1	111878	g2801	i0	33.3	2.57798165137615	90	46	78.9	4	70	327	573	652	KAI6661894.1 Neurogenic locus Notch protein-like [Oopsacas minuta]	diamond	843	47.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
30733794	30733794	PRJNA1132896_P_NODE_7394_length_249_cov_1.528409_g7303_i0	PRJNA1132896	7394	249	1.528409	3.80573841	Dysidea avara	196820	Porifera	other_Eukaryota	90.9	4.53e-19	NR	XP_065889894.1	196820	g7303	i0	55.8	0.927710843373494	77	34	92.8	0	232	2	452	528	XP_065889894.1 uncharacterized protein [Dysidea avara]	diamond	231	90.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara

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