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

6 rows where analysis = "diamond", bioproject = "PRJNA934472" 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
27499068	27499068	PRJNA934472_P_NODE_23403_length_303_cov_1.200000_g23025_i0	PRJNA934472	23403	303	1.2	3.636	Polyplax serrata	468196	Arthropoda	Arthropoda	152	3.44e-41	NR	KAK6638824.1	468196	g23025	i0	68	0.99009900990099	100	32	99	0	2	301	311	410	KAK6638824.1 hypothetical protein RUM43_007093 [Polyplax serrata]	diamond	300	152	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Psocodea	Polyplacidae	Polyplax	Polyplax serrata
28604086	28604086	PRJNA934472_P_NODE_34087_length_255_cov_1.362637_g33709_i0	PRJNA934472	34087	255	1.362637	3.47472435	Dalotia coriaria	877792	Arthropoda	Arthropoda	84.3	4.39e-17	NR	XP_065159349.1	877792	g33709	i0	54.8	0.988235294117647	84	32	98.8	2	253	2	194	271	XP_065159349.1 histone deacetylase 11 [Dalotia coriaria]	diamond	252	84.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Staphylinidae	Dalotia	Dalotia coriaria
28698967	28698967	PRJNA934472_P_NODE_40427_length_207_cov_6.291045_g40049_i0	PRJNA934472	40427	207	6.2910450000000004	13.02246315	Daphnia pulex	6669	Arthropoda	Arthropoda	46.2	3.51e-4	NR	EFX63165.1	6669	g40049	i0	59	0.565217391304348	39	12	50.7	1	102	206	59	97	EFX63165.1 hypothetical protein DAPPUDRAFT_67306, partial [Daphnia pulex]	diamond	117	46.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia pulex
30341474	30341474	PRJNA934472_P_NODE_37452_length_245_cov_0.895349_g37074_i0	PRJNA934472	37452	245	0.895349	2.19360505	Amphibalanus amphitrite	1232801	Arthropoda	Arthropoda	41.6	0.0314	NR	KAF0303614.1	1232801	g37074	i0	42	0.612244897959184	50	28	60	1	15	161	12	61	KAF0303614.1 Ganglioside GM2 activator [Amphibalanus amphitrite]	diamond	150	41.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Thecostraca	Balanomorpha	Balanidae	Amphibalanus	Amphibalanus amphitrite
32396216	32396216	PRJNA934472_P_NODE_26099_length_288_cov_2.293023_g25721_i0	PRJNA934472	26099	288	2.293023	6.60390624	Contarinia nasturtii	265458	Arthropoda	Arthropoda	75.5	6.09e-15	NR	XP_031616639.1	265458	g25721	i0	47.4	3.3125	78	39	81.3	2	2	235	58	133	XP_031616639.1 40S ribosomal protein S12 [Contarinia nasturtii]	diamond	954	75.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Cecidomyiidae	Contarinia	Contarinia nasturtii
32837667	32837667	PRJNA934472_P_NODE_35680_length_250_cov_0.870056_g35302_i0	PRJNA934472	35680	250	0.870056	2.17514	Cardiocondyla obscurior	286306	Arthropoda	Arthropoda	61.2	1.24e-8	NR	KAL0131813.1	286306	g35302	i0	55.1	0.828	69	18	76.8	3	193	2	539	599	KAL0131813.1 hypothetical protein PUN28_002988 [Cardiocondyla obscurior]	diamond	207	61.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Formicidae	Cardiocondyla	Cardiocondyla obscurior

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