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

5 rows where analysis = "diamond", bioproject = "PRJNA1008049" 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
26907925	26907925	PRJNA1008049_S_NODE_3902_length_159_cov_8.676923_g3884_i0	PRJNA1008049	3902	159	8.676923	13.79630757	Thrips palmi	161013	Arthropoda	Arthropoda	102	8.159999999999999e-24	NR	XP_034243901.1	161013	g3884	i0	90.4	0.981132075471698	52	5	98.1	0	158	3	66	117	XP_034243901.1 THO complex subunit 2 isoform X1 [Thrips palmi]	diamond	156	102	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Thysanoptera	Thripidae	Thrips	Thrips palmi
27918867	27918867	PRJNA1008049_S_NODE_605_length_235_cov_4.606796_g587_i0	PRJNA1008049	605	235	4.606796	10.8259706	Thrips palmi	161013	Arthropoda	Arthropoda	93.2	1.19e-22	NR	XP_034234331.1	161013	g587	i0	60	0.957446808510638	75	30	95.7	0	235	11	7	81	XP_034234331.1 uncharacterized protein LOC117641269 [Thrips palmi]	diamond	225	93.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Thysanoptera	Thripidae	Thrips	Thrips palmi
29434175	29434175	PRJNA1008049_S_NODE_430_length_255_cov_14.287611_g412_i0	PRJNA1008049	430	255	14.287611	36.43340805	Thrips palmi	161013	Arthropoda	Arthropoda	53.1	7.95e-6	NR	XP_034232277.1	161013	g412	i0	60	0.647058823529412	55	17	63.5	2	3	164	240	290	XP_034232277.1 circadian clock-controlled protein-like [Thrips palmi]	diamond	165	53.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Thysanoptera	Thripidae	Thrips	Thrips palmi
30982528	30982528	PRJNA1008049_S_NODE_2734_length_172_cov_4.167832_g2716_i0	PRJNA1008049	2734	172	4.167832	7.16867104	Macrobrachium rosenbergii	79674	Arthropoda	Arthropoda	69.7	4.45e-12	NR	XP_066964347.1	79674	g2716	i0	61.1	0.941860465116279	54	21	94.2	0	2	163	553	606	XP_066964347.1 LOW QUALITY PROTEIN: piggyBac transposable element-derived protein 4-like [Macrobrachium rosenbergii]	diamond	162	69.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Palaemonidae	Macrobrachium	Macrobrachium rosenbergii
32469155	32469155	PRJNA1008049_S_NODE_5099_length_151_cov_2.508197_g5081_i0	PRJNA1008049	5099	151	2.508197	3.78737747	Thrips palmi	161013	Arthropoda	Arthropoda	95.9	4.76e-24	NR	XP_034253031.1	161013	g5081	i0	93.9	0.973509933774834	49	3	97.4	0	149	3	19	67	XP_034253031.1 60S ribosomal protein L36 [Thrips palmi]	diamond	147	95.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Thysanoptera	Thripidae	Thrips	Thrips palmi

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