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

9 rows where analysis = "diamond", bioproject = "PRJNA1008049" and tax_kingdom = "Metazoa"

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
30216476	30216476	PRJNA1008049_S_NODE_3012_length_168_cov_10.345324_g2994_i0	PRJNA1008049	3012	168	10.345324	17.38014432	root	1	Root_unresolved	Root_unresolved	120	7.43e-30	NR	XP_030109804.2	10090	g2994	i0	100	10.8035714285714	55	0	98.2	0	167	3	89	143	XP_030109804.2 uncharacterized protein Gm52666 [Mus musculus]	diamond	1815	120	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
30343511	30343511	PRJNA1008049_S_NODE_1252_length_199_cov_8.994118_g1234_i0	PRJNA1008049	1252	199	8.994118	17.89829482	root	1	Root_unresolved	Root_unresolved	133	9.439999999999999e-35	NR	XP_030110853.2	10090	g1234	i0	100	14.6984924623116	65	0	98	0	3	197	122	186	XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus]	diamond	2925	133	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
30406535	30406535	PRJNA1008049_S_NODE_213_length_311_cov_4.234043_g195_i0	PRJNA1008049	213	311	4.234043	13.16787373	root	1	Root_unresolved	Root_unresolved	152	2.51e-42	NR	XP_036010302.1	10090	g195	i0	97.3	9.27974276527331	74	2	71.4	0	3	224	40	113	XP_036010302.1 uncharacterized protein Gm53410 [Mus musculus]	diamond	2886	152	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
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
31195670	31195670	PRJNA1008049_S_NODE_395_length_262_cov_6.669528_g377_i0	PRJNA1008049	395	262	6.669528	17.47416336	root	1	Root_unresolved	Root_unresolved	183	6.25e-53	NR	XP_030110853.2	10090	g377	i0	100	14.8969465648855	87	0	99.6	0	1	261	236	322	XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus]	diamond	3903	183	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
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);;