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

5 rows where analysis = "diamond", bioproject = "PRJNA784298" 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
4593750	4593750	PRJNA784298_P_NODE_8144_length_441_cov_2.008152_g7943_i0	PRJNA784298	8144	441	2.008152	8.85595032	Darwinula stevensoni	69355	Arthropoda	Arthropoda	149	5.76e-41	NR	CAD7255224.1	69355	g7943	i0	54.8	0.993197278911565	146	40	99.3	2	439	2	84	203	CAD7255224.1 unnamed protein product, partial [Darwinula stevensoni]	diamond	438	149	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Darwinulidae	Darwinula	Darwinula stevensoni
19892125	19892125	PRJNA784298_P_NODE_1696_length_983_cov_2.086813_g1536_i0	PRJNA784298	1696	983	2.086813	20.51337179	Idotea baltica	82763	Arthropoda	Arthropoda	372	5.34e-125	NR	MCL4166761.1	82763	g1536	i0	60.6	0.991861648016277	325	124	99.2	1	1	975	23	343	MCL4166761.1 hypothetical protein [Idotea baltica]	diamond	975	372	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Idoteidae	Idotea	Idotea baltica
23718288	23718288	PRJNA784298_P_NODE_59_length_4639_cov_8.504380_g50_i0	PRJNA784298	59	4639	8.50438	394.5181882	root	1	Root_unresolved	Root_unresolved	960	0	NR	CAG4649328.1	202097	g50	i0	47.9	1.11230868721707	1223	428	78.6	13	3649	2	3	1023	CAG4649328.1 EOG090X067V, partial [Scapholeberis mucronata]	diamond	5160	960	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Scapholeberis	Scapholeberis mucronata
28578926	28578926	PRJNA784298_P_NODE_23727_length_251_cov_0.865169_g23526_i0	PRJNA784298	23727	251	0.865169	2.17157419	Arthropoda	6656	Arthropoda	Arthropoda	52	1.68e-5	NR	XP_017462234.1	28612	g23526	i0	41.3	1.91235059760956	80	47	95.6	0	8	247	94	173	XP_017462234.1 PREDICTED: E3 ubiquitin-protein ligase Bre1-like [Rhagoletis zephyria]	diamond	480	52	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Tephritidae	Rhagoletis	Rhagoletis zephyria
30505330	30505330	PRJNA784298_P_NODE_25593_length_245_cov_0.895349_g25392_i0	PRJNA784298	25593	245	0.895349	2.19360505	Amphipoda	6821	Arthropoda	Arthropoda	64.7	3.72e-10	NR	XP_018026009.1	294128	g25392	i0	75	2.71836734693878	44	11	53.9	0	245	114	217	260	XP_018026009.1 40S ribosomal protein S4 [Hyalella azteca]	diamond	666	65.1	0.993855606758833	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Amphipoda	Hyalellidae	Hyalella	Hyalella azteca

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