metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA806354" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA806354" 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
28285696	28285696	PRJNA806354_P_NODE_40146_length_243_cov_0.905882_g40037_i0	PRJNA806354	40146	243	0.905882	2.20129326	Artemia franciscana	6661	Arthropoda	Arthropoda	57	1.52e-7	NR	XP_065581157.1	6661	g40037	i0	90.3	0.382716049382716	31	2	38.3	1	241	149	122	151	XP_065581157.1 shematrin-like protein 1 [Artemia franciscana]	diamond	93	57	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
30307427	30307427	PRJNA806354_P_NODE_38692_length_245_cov_0.895349_g38583_i0	PRJNA806354	38692	245	0.895349	2.19360505	Malaya genurostris	325434	Arthropoda	Arthropoda	48.5	3.59e-4	NR	XP_058449439.1	325434	g38583	i0	32.5	0.942857142857143	77	51	94.3	1	234	4	316	391	XP_058449439.1 uncharacterized protein LOC131429378 [Malaya genurostris]	diamond	231	48.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Malaya	Malaya genurostris
30654356	30654356	PRJNA806354_P_NODE_35193_length_251_cov_1.483146_g35084_i0	PRJNA806354	35193	251	1.483146	3.72269646	Artemia franciscana	6661	Arthropoda	Arthropoda	115	4.32e-31	NR	KAK2721100.1	6661	g35084	i0	73.8	0.956175298804781	80	21	95.6	0	3	242	31	110	KAK2721100.1 hypothetical protein QYM36_003394 [Artemia franciscana]	diamond	240	115	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
31254801	31254801	PRJNA806354_P_NODE_42995_length_202_cov_5.395349_g42886_i0	PRJNA806354	42995	202	5.395349	10.89860498	Artemia franciscana	6661	Arthropoda	Arthropoda	96.7	2.28e-21	NR	XP_065571297.1	6661	g42886	i0	79.1	1.99009900990099	67	14	99.5	0	201	1	740	806	XP_065571297.1 GATA zinc finger domain-containing protein 14-like [Artemia franciscana]	diamond	402	96.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
31602896	31602896	PRJNA806354_P_NODE_19656_length_327_cov_1.807087_g19547_i0	PRJNA806354	19656	327	1.807087	5.90917449	Artemia franciscana	6661	Arthropoda	Arthropoda	198	6.16e-61	NR	KAK2712081.1	6661	g19547	i0	86.9	0.981651376146789	107	14	98.2	0	326	6	139	245	KAK2712081.1 hypothetical protein QYM36_010939 [Artemia franciscana]	diamond	321	198	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
31729213	31729213	PRJNA806354_P_NODE_28237_length_278_cov_1.970732_g28128_i0	PRJNA806354	28237	278	1.970732	5.47863496	Artemia franciscana	6661	Arthropoda	Arthropoda	70.9	5.51e-12	NR	KAK2726085.1	6661	g28128	i0	40.2	0.992805755395683	92	55	99.3	0	2	277	176	267	KAK2726085.1 hypothetical protein QYM36_000516 [Artemia franciscana]	diamond	276	70.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
32552182	32552182	PRJNA806354_P_NODE_26619_length_286_cov_1.239437_g26510_i0	PRJNA806354	26619	286	1.239437	3.54478982	Artemia franciscana	6661	Arthropoda	Arthropoda	125	5.2e-31	NR	XP_065571297.1	6661	g26510	i0	76.6	1.97202797202797	94	21	98.6	1	284	3	592	684	XP_065571297.1 GATA zinc finger domain-containing protein 14-like [Artemia franciscana]	diamond	564	125	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
32803778	32803778	PRJNA806354_P_NODE_42780_length_222_cov_4.523490_g42671_i0	PRJNA806354	42780	222	4.52349	10.0421478	Palaemon carinicauda	392227	Arthropoda	Arthropoda	102	3.5399999999999995e-24	NR	XP_068225707.1	392227	g42671	i0	74.1	0.783783783783784	58	15	78.4	0	2	175	261	318	XP_068225707.1 aldo-keto reductase family 1 member B1-like isoform X1 [Palaemon carinicauda]	diamond	174	102	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Palaemonidae	Palaemon	Palaemon carinicauda

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