metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA864829" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA864829" 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
7225449	7225449	PRJNA864829_S_NODE_10266_length_197_cov_1.959459_g10180_i0	PRJNA864829	10266	197	1.959459	3.86013423	Panulirus ornatus	150431	Arthropoda	Arthropoda	94.7	8.749999999999999e-23	NR	XP_071537109.1	150431	g10180	i0	67.2	2.9238578680203	64	21	97.5	0	1	192	85	148	XP_071537109.1 eukaryotic translation initiation factor 5A-1 [Panulirus ornatus]	diamond	576	94.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Palinuridae	Panulirus	Panulirus ornatus
22523967	22523967	PRJNA864829_S_NODE_11238_length_190_cov_1.148936_g11152_i0	PRJNA864829	11238	190	1.148936	2.1829784	Ceratitis capitata	7213	Arthropoda	Arthropoda	127	1.0699999999999999e-32	NR	CAD7015493.1	7213	g11152	i0	92.1	2.98421052631579	63	5	99.5	0	1	189	211	273	CAD7015493.1 unnamed protein product [Ceratitis capitata]	diamond	567	127	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Tephritidae	Ceratitis	Ceratitis capitata
27371478	27371478	PRJNA864829_S_NODE_14063_length_172_cov_0.869919_g13977_i0	PRJNA864829	14063	172	0.869919	1.49626068	Dendroctonus ponderosae	77166	Arthropoda	Arthropoda	59.7	9.17e-9	NR	XP_019759485.1	77166	g13977	i0	48.2	1.95348837209302	56	24	97.7	1	4	171	188	238	XP_019759485.1 pathogenesis-related protein 5 [Dendroctonus ponderosae]	diamond	336	59.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Curculionidae	Dendroctonus	Dendroctonus ponderosae
28097353	28097353	PRJNA864829_S_NODE_185_length_927_cov_30.627563_g143_i0	PRJNA864829	185	927	30.627563	283.91750901	Nephila pilipes	299642	Arthropoda	Arthropoda	47.4	0.025	NR	GFT36626.1	299642	g143	i0	48.4	0.207119741100324	64	29	20.7	2	512	321	66	125	GFT36626.1 hypothetical protein NPIL_642691 [Nephila pilipes]	diamond	192	47.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Nephilidae	Nephila	Nephila pilipes
31580379	31580379	PRJNA864829_S_NODE_7816_length_221_cov_1.813953_g7730_i0	PRJNA864829	7816	221	1.813953	4.00883613	Arthropoda	6656	Arthropoda	Arthropoda	71.2	1.77e-12	NR	KMQ82595.1	67767	g7730	i0	55.4	4.41176470588235	65	21	77.4	3	194	24	125	189	KMQ82595.1 transposable element tcb1 transposase [Lasius niger]	diamond	975	71.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Formicidae	Lasius	Lasius niger
31856692	31856692	PRJNA864829_S_NODE_5597_length_253_cov_1.313725_g5511_i0	PRJNA864829	5597	253	1.313725	3.32372425	Trialeurodes vaporariorum	88556	Arthropoda	Arthropoda	42.7	0.0092	NR	YP_086823.1	88556	g5511	i0	44.1	0.806324110671937	68	38	80.6	0	206	3	11	78	YP_086823.1 NADH dehydrogenase subunit 4L [Trialeurodes vaporariorum]	diamond	204	42.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Trialeurodes	Trialeurodes vaporariorum
32718524	32718524	PRJNA864829_S_NODE_15660_length_165_cov_2.284483_g15574_i0	PRJNA864829	15660	165	2.284483	3.76939695	Opisthokonta	33154	Arthropoda	Arthropoda	48.1	1.66e-4	NR	XP_014278502.1	286706	g15574	i0	47.9	5.29090909090909	48	25	87.3	0	165	22	664	711	XP_014278502.1 putative ankyrin repeat protein RF_0381 [Halyomorpha halys]	diamond	873	48.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Pentatomidae	Halyomorpha	Halyomorpha halys

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