metadata: contig_metadata: 8 rows where bioproject = "PRJNA792582", tax_kingdom = "Metazoa" and tax

8 rows where bioproject = "PRJNA792582", 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
22454195	22454195	PRJNA792582_P_NODE_34738_length_292_cov_1.493151_g33924_i0	PRJNA792582	34738	292	1.493151	4.36000092	Metazoa	33208	Porifera	other_Eukaryota	176	3.3200000000000002e-49	NR	XP_065194115.1	27933	g33924	i0	83.5	52.7979452054795	97	16	99.7	0	291	1	503	599	XP_065194115.1 dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit STT3A-like [Sycon ciliatum]	diamond	15417	176	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
29737655	29737655	PRJNA792582_P_NODE_44290_length_266_cov_1.538860_g43476_i0	PRJNA792582	44290	266	1.53886	4.0933676	Suberites domuncula	55567	Porifera	other_Eukaryota	132	2.75e-35	NR	CAH04631.1	55567	g43476	i0	67	2.96616541353383	88	29	99.2	0	265	2	128	215	CAH04631.1 cathepsin H [Suberites domuncula]	diamond	789	132	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Suberitidae	Suberites	Suberites domuncula
30663240	30663240	PRJNA792582_P_NODE_39573_length_279_cov_1.121359_g38759_i0	PRJNA792582	39573	279	1.121359	3.12859161	Metazoa	33208	Porifera	other_Eukaryota	71.6	1.18e-13	NR	XP_064396950.1	6063	g38759	i0	97	1.06451612903226	33	1	35.5	0	1	99	88	120	XP_064396950.1 V-type proton ATPase subunit F-like [Halichondria panicea]	diamond	297	71.6	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea
31127652	31127652	PRJNA792582_P_NODE_58795_length_241_cov_3.892857_g57981_i0	PRJNA792582	58795	241	3.892857	9.38178537	Sycon ciliatum	27933	Porifera	other_Eukaryota	49.7	1.27e-4	NR	XP_065182321.1	27933	g57981	i0	58.3	2.40248962655602	36	15	44.8	0	15	122	224	259	XP_065182321.1 uncharacterized protein K02A2.6-like [Sycon ciliatum]	diamond	579	49.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
31476004	31476004	PRJNA792582_P_NODE_40456_length_276_cov_2.418719_g39642_i0	PRJNA792582	40456	276	2.418719	6.67566444	Sycon ciliatum	27933	Porifera	other_Eukaryota	73.6	7.66e-13	NR	XP_065179229.1	27933	g39642	i0	45.6	0.978260869565217	90	44	97.8	3	6	275	333	417	XP_065179229.1 ammonium transporter Rh type A-like [Sycon ciliatum]	diamond	270	73.6	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
31602525	31602525	PRJNA792582_P_NODE_38796_length_281_cov_1.264423_g37982_i0	PRJNA792582	38796	281	1.264423	3.55302863	Halisarca dujardinii	2583056	Porifera	other_Eukaryota	74.7	1.99e-13	NR	QSX72227.1	2583056	g37982	i0	71.1	0.480427046263345	45	13	48	0	136	270	277	321	QSX72227.1 glutaredoxin 3 [Halisarca dujardinii]	diamond	135	74.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Chondrillida	Halisarcidae	Halisarca	Halisarca dujardinii
31665544	31665544	PRJNA792582_P_NODE_33077_length_300_cov_1.017621_g32263_i0	PRJNA792582	33077	300	1.017621	3.052863	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	64.7	1.4e-9	NR	XP_019859418.1	400682	g32263	i0	50	4.68	70	34	70	1	211	2	5	73	XP_019859418.1 PREDICTED: LOW QUALITY PROTEIN: uncharacterized protein K02A2.6-like [Amphimedon queenslandica]	diamond	1404	64.7	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
31665545	31665545	PRJNA792582_P_NODE_33917_length_296_cov_0.991031_g33103_i0	PRJNA792582	33917	296	0.991031	2.93345176	Corticium candelabrum	121492	Porifera	other_Eukaryota	85.5	6.63e-17	NR	XP_062507933.1	121492	g33103	i0	44.3	1.95608108108108	97	54	98.3	0	296	6	170	266	XP_062507933.1 tRNA endonuclease ANKZF1-like [Corticium candelabrum]	diamond	579	85.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum

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