metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1047321" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1047321" 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
28109008	28109008	PRJNA1047321_P_NODE_2585_length_412_cov_4.150442_g2416_i0	PRJNA1047321	2585	412	4.150442	17.09982104	Tribolium castaneum	7070	Arthropoda	Arthropoda	45.8	0.0186	NR	XP_008199173.3	7070	g2416	i0	34.6	1.24514563106796	81	50	57.5	3	149	385	470	549	XP_008199173.3 protein bride of sevenless [Tribolium castaneum]	diamond	513	46.2	0.991341991341991	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Tenebrionidae	Tribolium	Tribolium castaneum
30351795	30351795	PRJNA1047321_P_NODE_7832_length_245_cov_0.895349_g7661_i0	PRJNA1047321	7832	245	0.895349	2.19360505	Artemia franciscana	6661	Arthropoda	Arthropoda	54.3	2.06e-6	NR	XP_065583299.1	6661	g7661	i0	77.8	0.881632653061225	36	8	44.1	0	93	200	69	104	XP_065583299.1 eukaryotic translation initiation factor 4 gamma 3-like [Artemia franciscana]	diamond	216	54.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
30888394	30888394	PRJNA1047321_P_NODE_854_length_757_cov_6.849415_g725_i0	PRJNA1047321	854	757	6.849415	51.85007155	Artemia franciscana	6661	Arthropoda	Arthropoda	362	1.9399999999999993e-124	NR	KAK2724467.1	6661	g725	i0	99.5	0.852047556142668	215	1	85.2	0	661	17	1	215	KAK2724467.1 hypothetical protein QYM36_001091 [Artemia franciscana]	diamond	645	362	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
31078091	31078091	PRJNA1047321_P_NODE_6835_length_249_cov_1.482955_g6664_i0	PRJNA1047321	6835	249	1.482955	3.69255795	Artemia franciscana	6661	Arthropoda	Arthropoda	77.4	2.57e-14	NR	XP_065571151.1	6661	g6664	i0	42	0.975903614457831	81	47	97.6	0	1	243	84	164	XP_065571151.1 uncharacterized protein LOC136034026 [Artemia franciscana]	diamond	243	77.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
32216661	32216661	PRJNA1047321_P_NODE_3318_length_359_cov_1.220280_g3148_i0	PRJNA1047321	3318	359	1.22028	4.3808052	Artemia franciscana	6661	Arthropoda	Arthropoda	145	4.2999999999999997e-38	NR	KAK2722065.1	6661	g3148	i0	57.1	1.98885793871866	119	50	99.4	1	3	359	280	397	KAK2722065.1 hypothetical protein QYM36_002569, partial [Artemia franciscana]	diamond	714	145	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana

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