metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA1111082" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA1111082" and tax_kingdom = "Metazoa"

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
9143016	9143016	PRJNA1111082_P_NODE_5328_length_343_cov_1.155556_g5283_i0	PRJNA1111082	5328	343	1.155556	3.96355708	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	225	4.8e-66	NR	RNA17792.1	10195	g5283	i0	96.5	1.99416909620991	114	4	99.7	0	2	343	848	961	RNA17792.1 coatomer subunit beta [Brachionus plicatilis]	diamond	684	225	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
27289028	27289028	PRJNA1111082_P_NODE_9923_length_258_cov_1.308108_g9878_i0	PRJNA1111082	9923	258	1.308108	3.37491864	Cordylochernes scorpioides	51811	Arthropoda	Arthropoda	83.2	2.64e-16	NR	UYV67927.1	51811	g9878	i0	47.5	2.88372093023256	80	42	93	0	254	15	769	848	UYV67927.1 hypothetical protein LAZ67_5002522 [Cordylochernes scorpioides]	diamond	744	83.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Pseudoscorpiones	Chernetidae	Cordylochernes	Cordylochernes scorpioides
28267760	28267760	PRJNA1111082_P_NODE_8586_length_277_cov_1.617647_g8541_i0	PRJNA1111082	8586	277	1.617647	4.48088219	Pleurodeles waltl	8319	Chordata	Chordata	57	5.54e-7	NR	KAJ1171611.1	8319	g8541	i0	37.3	0.89891696750902494	83	51	89.9	1	252	4	874	955	KAJ1171611.1 hypothetical protein NDU88_003471 [Pleurodeles waltl]	diamond	249	57	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl
28299451	28299451	PRJNA1111082_P_NODE_9126_length_269_cov_1.602041_g9081_i0	PRJNA1111082	9126	269	1.602041	4.30949029	Hydra vulgaris	6087	Cnidaria	other_Eukaryota	83.2	2.91e-16	NR	XP_065680193.1	6087	g9081	i0	57.5	0.814126394052045	73	30	80.3	1	52	267	386	458	XP_065680193.1 uncharacterized protein LOC124806266 [Hydra vulgaris]	diamond	219	83.2	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Anthoathecata	Hydridae	Hydra	Hydra vulgaris
28858977	28858977	PRJNA1111082_P_NODE_10648_length_252_cov_0.871508_g10603_i0	PRJNA1111082	10648	252	0.871508	2.19620016	root	1	Root_unresolved	Root_unresolved	45.8	0.00274	NR	YP_009480269.1	1580118	g10603	i0	68	2.17857142857143	25	8	29.8	0	252	178	193	217	YP_009480269.1 cytochrome c oxidase subunit II [Navis striatus]	diamond	549	45.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Argasidae	Navis	Navis striatus
29625147	29625147	PRJNA1111082_P_NODE_7310_length_299_cov_1.247788_g7265_i0	PRJNA1111082	7310	299	1.247788	3.73088612	Adineta vaga	104782	Rotifera	other_Eukaryota	43.1	0.0472	NR	UJR23850.1	104782	g7265	i0	32.9	0.792642140468227	79	53	79.3	0	31	267	11	89	UJR23850.1 hypothetical protein I4U23_026825 [Adineta vaga]	diamond	237	43.1	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
31806175	31806175	PRJNA1111082_P_NODE_11877_length_245_cov_2.872093_g11832_i0	PRJNA1111082	11877	245	2.872093	7.03662785	Erpetoichthys calabaricus	27687	Chordata	Chordata	70.9	3.39e-12	NR	XP_051791274.1	27687	g11832	i0	73.5	3.6734693877551	49	12	58.8	1	10	153	156	204	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	900	70.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus

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