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

7 rows where analysis = "diamond", bioproject = "PRJEB48872" 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
27949581	27949581	PRJEB48872_P_NODE_638005_length_161_cov_0.991803_g622193_i0	PRJEB48872	638005	161	0.991803	1.59680283	Amblyomma americanum	6943	Arthropoda	Arthropoda	57.4	8.45e-9	NR	KAK8770790.1	6943	g622193	i0	47.8	0.857142857142857	46	24	85.7	0	13	150	67	112	KAK8770790.1 hypothetical protein V5799_012744 [Amblyomma americanum]	diamond	138	57.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Amblyomma	Amblyomma americanum
28416586	28416586	PRJEB48872_P_NODE_272546_length_309_cov_1.514815_g256734_i0	PRJEB48872	272546	309	1.514815	4.68077835	Gryllus	6998	Arthropoda	Arthropoda	107	5.12e-27	NR	GLH03222.1	6999	g256734	i0	80.3	2.54368932038835	66	13	64.1	0	35	232	18	83	GLH03222.1 Cuticle structural protein PCP16.7, post-ecdysial [Gryllus bimaculatus]	diamond	786	107	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Orthoptera	Gryllidae	Gryllus	Gryllus bimaculatus
28675848	28675848	PRJEB48872_P_NODE_346107_length_258_cov_0.931507_g330295_i0	PRJEB48872	346107	258	0.931507	2.40328806	Bemisia tabaci	7038	Arthropoda	Arthropoda	42.7	0.0434	NR	XP_018895949.1	7038	g330295	i0	33.9	0.720930232558139	62	37	67.4	1	17	190	132	193	XP_018895949.1 PREDICTED: uncharacterized protein LOC109029778 [Bemisia tabaci]	diamond	186	42.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Bemisia	Bemisia tabaci
30033626	30033626	PRJEB48872_P_NODE_468551_length_203_cov_23.884146_g452739_i0	PRJEB48872	468551	203	23.884146	48.48481638	Tenebrio molitor	7067	Arthropoda	Arthropoda	51.2	2.28e-5	NR	KAH0808894.1	7067	g452739	i0	55.6	0.798029556650246	54	21	79.8	1	201	40	238	288	KAH0808894.1 hypothetical protein GEV33_013898 [Tenebrio molitor]	diamond	162	51.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Tenebrionidae	Tenebrio	Tenebrio molitor
30696891	30696891	PRJEB48872_P_NODE_534414_length_184_cov_1.420690_g518602_i0	PRJEB48872	534414	184	1.42069	2.6140696	Diploptera punctata	6984	Arthropoda	Arthropoda	45.4	0.00154	NR	KAJ9574163.1	6984	g518602	i0	54.1	4.33695652173913	37	17	60.3	0	120	10	150	186	KAJ9574163.1 hypothetical protein L9F63_008419, partial [Diploptera punctata]	diamond	798	45.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Blattodea	Blaberidae	Diploptera	Diploptera punctata
31708598	31708598	PRJEB48872_P_NODE_262537_length_317_cov_8.320144_g246725_i0	PRJEB48872	262537	317	8.320144	26.37485648	Tribolium castaneum	7070	Arthropoda	Arthropoda	45.1	0.0135	NR	XP_008199173.3	7070	g246725	i0	35.8	0.766561514195584	81	49	74.8	3	35	271	470	549	XP_008199173.3 protein bride of sevenless [Tribolium castaneum]	diamond	243	45.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Tenebrionidae	Tribolium	Tribolium castaneum
32808048	32808048	PRJEB48872_P_NODE_546900_length_181_cov_1.154930_g531088_i0	PRJEB48872	546900	181	1.15493	2.0904233	Insecta	50557	Arthropoda	Arthropoda	44.3	0.00169	NR	XP_031353476.1	7054	g531088	i0	58.8	2.25414364640884	34	14	56.4	0	102	1	4	37	XP_031353476.1 uncharacterized protein LOC116178192 [Photinus pyralis]	diamond	408	44.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Lampyridae	Photinus	Photinus pyralis

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