metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA488043" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA488043" 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
9377811	9377811	PRJNA488043_P_NODE_7388_length_445_cov_7.225962_g5241_i0	PRJNA488043	7388	445	7.225962	32.1555309	Gnathostoma spinigerum	75299	Nematoda	Nematoda	144	5.84e-42	NR	MFH4985130.1	75299	g5241	i0	92.5	0.451685393258427	67	5	45.2	0	130	330	1	67	MFH4985130.1 hypothetical protein [Gnathostoma spinigerum]	diamond	201	144	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Gnathostomatidae	Gnathostoma	Gnathostoma spinigerum
27107740	27107740	PRJNA488043_P_NODE_17282_length_199_cov_3.111765_g15040_i0	PRJNA488043	17282	199	3.111765	6.19241235	Pleurodeles waltl	8319	Chordata	Chordata	56.6	1.54e-7	NR	KAJ1174501.1	8319	g15040	i0	55.9	1.0251256281407	68	13	76.9	2	155	3	128	195	KAJ1174501.1 hypothetical protein NDU88_006322 [Pleurodeles waltl]	diamond	204	56.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Caudata	Salamandridae	Pleurodeles	Pleurodeles waltl
27708577	27708577	PRJNA488043_P_NODE_13664_length_249_cov_2.109091_g11422_i0	PRJNA488043	13664	249	2.109091	5.25163659	Homalodisca vitripennis	197043	Arthropoda	Arthropoda	47.8	1.55e-4	NR	KAG8280132.1	197043	g11422	i0	50.9	3.43373493975904	57	28	68.7	0	177	7	23	79	KAG8280132.1 Proteasome subunit alpha type-4 [Homalodisca vitripennis]	diamond	855	47.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Cicadellidae	Homalodisca	Homalodisca vitripennis
27945261	27945261	PRJNA488043_P_NODE_14885_length_229_cov_3.255000_g12643_i0	PRJNA488043	14885	229	3.255	7.45395	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	82.8	2.31e-17	NR	XP_065585136.1	6661	g12643	i0	70.7	13.4803493449782	58	17	76	0	174	1	3	60	XP_065585136.1 large ribosomal subunit protein uL1-like [Artemia franciscana]	diamond	3087	83.2	0.995192307692308	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
28213070	28213070	PRJNA488043_P_NODE_16046_length_213_cov_3.184783_g13804_i0	PRJNA488043	16046	213	3.184783	6.78358779	Artemia franciscana	6661	Arthropoda	Arthropoda	80.5	1.47e-16	NR	XP_065585136.1	6661	g13804	i0	69.6	0.788732394366197	56	17	78.9	0	168	1	5	60	XP_065585136.1 large ribosomal subunit protein uL1-like [Artemia franciscana]	diamond	168	80.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
29696922	29696922	PRJNA488043_P_NODE_19850_length_173_cov_2.201389_g17608_i0	PRJNA488043	19850	173	2.201389	3.80840297	Gnathostoma spinigerum	75299	Nematoda	Nematoda	67	5.03e-13	NR	MFH4985130.1	75299	g17608	i0	87.9	0.572254335260116	33	4	57.2	0	101	3	1	33	MFH4985130.1 hypothetical protein [Gnathostoma spinigerum]	diamond	99	67	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Gnathostomatidae	Gnathostoma	Gnathostoma spinigerum
29918502	29918502	PRJNA488043_P_NODE_12811_length_265_cov_2.177966_g10570_i0	PRJNA488043	12811	265	2.177966	5.7716099	Gnathostoma spinigerum	75299	Nematoda	Nematoda	107	1.66e-28	NR	MFH4985130.1	75299	g10570	i0	89.8	0.554716981132075	49	5	55.5	0	263	117	19	67	MFH4985130.1 hypothetical protein [Gnathostoma spinigerum]	diamond	147	107	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Gnathostomatidae	Gnathostoma	Gnathostoma spinigerum
30297995	30297995	PRJNA488043_P_NODE_8832_length_379_cov_9.160000_g6613_i0	PRJNA488043	8832	379	9.16	34.7164	Gnathostoma spinigerum	75299	Nematoda	Nematoda	149	2.65e-44	NR	MFH4985130.1	75299	g6613	i0	100	0.530343007915567	67	0	53	0	127	327	1	67	MFH4985130.1 hypothetical protein [Gnathostoma spinigerum]	diamond	201	149	1	Eukaryota	Opisthokonta	Metazoa	Nematoda	Chromadorea	Rhabditida	Gnathostomatidae	Gnathostoma	Gnathostoma spinigerum
31276903	31276903	PRJNA488043_S_NODE_1335_length_167_cov_3.355072_g1324_i0	PRJNA488043	1335	167	3.355072	5.60297024	Idotea baltica	82763	Arthropoda	Arthropoda	70.5	3.65e-13	NR	MCL4113740.1	82763	g1324	i0	64.2	0.952095808383233	53	19	95.2	0	163	5	31	83	MCL4113740.1 hypothetical protein [Idotea baltica]	diamond	159	70.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Idoteidae	Idotea	Idotea baltica
31340287	31340287	PRJNA488043_P_NODE_15756_length_217_cov_2.127660_g13514_i0	PRJNA488043	15756	217	2.12766	4.6170222	Lonomia obliqua	304329	Arthropoda	Arthropoda	46.2	2.25e-4	NR	AAV91398.1	304329	g13514	i0	85.2	0.746543778801843	27	4	37.3	0	1	81	60	86	AAV91398.1 ribosomal protein 26 [Lonomia obliqua]	diamond	162	46.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Saturniidae	Lonomia	Lonomia obliqua

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