metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA290839" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA290839" and tax_phylum = "Arthropoda"

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
8712178	8712178	PRJNA290839_P_NODE_1067_length_252_cov_0.865922_g1046_i0	PRJNA290839	1067	252	0.865922	2.18212344	Aphidius gifuensis	684658	Arthropoda	Arthropoda	104	6.47e-24	NR	XP_044001066.1	684658	g1046	i0	50.6	2.96428571428571	83	40	98.8	1	251	3	470	551	XP_044001066.1 valine--tRNA ligase isoform X2 [Aphidius gifuensis]	diamond	747	104	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Aphidius	Aphidius gifuensis
27295444	27295444	PRJNA290839_P_NODE_623_length_325_cov_0.916667_g602_i0	PRJNA290839	623	325	0.916667	2.97916775	Dermacentor silvarum	543639	Arthropoda	Arthropoda	53.9	5.08e-6	NR	XP_049524155.1	543639	g602	i0	56.1	3.15692307692308	57	25	52.6	0	224	54	105	161	XP_049524155.1 60S ribosomal protein L10-like [Dermacentor silvarum]	diamond	1026	53.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Dermacentor	Dermacentor silvarum
28228538	28228538	PRJNA290839_P_NODE_906_length_268_cov_1.589744_g885_i0	PRJNA290839	906	268	1.589744	4.26051392	Malacostraca	6681	Arthropoda	Arthropoda	122	1.8e-32	NR	CAL4234900.1	48144	g885	i0	60.7	5.00373134328358	89	35	99.6	0	2	268	6	94	CAL4234900.1 unnamed protein product [Meganyctiphanes norvegica]	diamond	1341	123	0.991869918699187	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Euphausiacea	Euphausiidae	Meganyctiphanes	Meganyctiphanes norvegica
29221739	29221739	PRJNA290839_P_NODE_1409_length_246_cov_0.895954_g1388_i0	PRJNA290839	1409	246	0.895954	2.20404684	Polypedilum vanderplanki	319348	Arthropoda	Arthropoda	88.2	3.06e-20	NR	KAG5671785.1	319348	g1388	i0	56.8	2.04878048780488	81	35	98.8	0	243	1	12	92	KAG5671785.1 hypothetical protein PVAND_001961 [Polypedilum vanderplanki]	diamond	504	88.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Polypedilum	Polypedilum vanderplanki
30484982	30484982	PRJNA290839_P_NODE_633_length_321_cov_1.572581_g612_i0	PRJNA290839	633	321	1.572581	5.04798501	Argiope bruennichi	94029	Arthropoda	Arthropoda	135	2.61e-38	NR	XP_055944831.1	94029	g612	i0	63.2	1.98130841121495	106	39	99.1	0	319	2	1	106	XP_055944831.1 60S ribosomal protein L24-like [Argiope bruennichi]	diamond	636	135	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Araneidae	Argiope	Argiope bruennichi
32603444	32603444	PRJNA290839_P_NODE_860_length_277_cov_1.509804_g839_i0	PRJNA290839	860	277	1.509804	4.18215708	Culicoides brevitarsis	469753	Arthropoda	Arthropoda	88.6	4.4e-18	NR	XP_063698977.1	469753	g839	i0	52.5	0.866425992779783	80	38	86.6	0	2	241	181	260	XP_063698977.1 phosphatidylinositol 3,4,5-trisphosphate 3-phosphatase cnrN [Culicoides brevitarsis]	diamond	240	88.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Ceratopogonidae	Culicoides	Culicoides brevitarsis

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