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

5 rows where analysis = "diamond", bioproject = "PRJNA1020854" 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
1003144	1003144	PRJNA1020854_S_NODE_15001_length_302_cov_1257.087912_g12237_i0	PRJNA1020854	15001	302	1257.087912	3796.40549424	Oppia nitens	1686743	Arthropoda	Arthropoda	91.7	1.06e-19	NR	XP_054156398.1	1686743	g12237	i0	64.9	0.735099337748344	74	23	71.5	2	241	26	195	267	XP_054156398.1 non-structural maintenance of chromosomes element 4 homolog A-like [Oppia nitens]	diamond	222	91.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppia	Oppia nitens
28014267	28014267	PRJNA1020854_S_NODE_37765_length_163_cov_3.111940_g35001_i0	PRJNA1020854	37765	163	3.11194	5.0724622	Oppia nitens	1686743	Arthropoda	Arthropoda	68.6	9.96e-12	NR	XP_054154467.1	1686743	g35001	i0	81.1	1.36196319018405	37	7	68.1	0	163	53	659	695	XP_054154467.1 protein HBS1-like isoform X2 [Oppia nitens]	diamond	222	68.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppia	Oppia nitens
28866531	28866531	PRJNA1020854_S_NODE_34668_length_172_cov_2.706294_g31904_i0	PRJNA1020854	34668	172	2.706294	4.65482568	Stegodyphus dumicola	202533	Arthropoda	Arthropoda	112	2.24e-30	NR	XP_035224062.1	202533	g31904	i0	96.4	1.91860465116279	55	2	95.9	0	167	3	57	111	XP_035224062.1 40S ribosomal protein S26-like [Stegodyphus dumicola]	diamond	330	112	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Eresidae	Stegodyphus	Stegodyphus dumicola
30603500	30603500	PRJNA1020854_S_NODE_11473_length_371_cov_5.888889_g8715_i0	PRJNA1020854	11473	371	5.888889	21.84777819	Phyllotreta striolata	444603	Arthropoda	Arthropoda	46.2	0.00808	NR	CAG9865115.1	444603	g8715	i0	40.8	0.39622641509434	49	29	39.6	0	10	156	120	168	CAG9865115.1 unnamed protein product [Phyllotreta striolata]	diamond	147	46.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Chrysomelidae	Phyllotreta	Phyllotreta striolata
32816110	32816110	PRJNA1020854_S_NODE_35020_length_171_cov_2.633803_g32256_i0	PRJNA1020854	35020	171	2.633803	4.50380313	Tetranychus urticae	32264	Arthropoda	Arthropoda	82.4	5.99e-17	NR	XP_015784952.1	32264	g32256	i0	78.7	0.824561403508772	47	10	82.5	0	30	170	12	58	XP_015784952.1 vacuolar protein sorting-associated protein VTA1 homolog [Tetranychus urticae]	diamond	141	82.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Tetranychus	Tetranychus urticae

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