metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA719595" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA719595" 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
24936015	24936015	PRJNA719595_P_NODE_6820_length_252_cov_0.871508_g6785_i0	PRJNA719595	6820	252	0.871508	2.19620016	Diptera	7147	Arthropoda	Arthropoda	126	3.99e-32	NR	XP_004518446.1	7213	g6785	i0	74.4	47.3571428571429	78	20	92.9	0	238	5	159	236	XP_004518446.1 vacuolar protein sorting-associated protein 26B-like [Ceratitis capitata]	diamond	11934	126	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Tephritidae	Ceratitis	Ceratitis capitata
26650760	26650760	PRJNA719595_P_NODE_9101_length_243_cov_0.917647_g9066_i0	PRJNA719595	9101	243	0.917647	2.22988221	Trombidiformes	83136	Arthropoda	Arthropoda	107	6.77e-26	NR	RWS23265.1	299467	g9066	i0	58.8	6.91358024691358	80	33	98.8	0	3	242	67	146	RWS23265.1 peptide chain release factor 1-like: mitochondrial isoform X2 [Leptotrombidium deliense]	diamond	1680	107	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Trombiculidae	Leptotrombidium	Leptotrombidium deliense
28473323	28473323	PRJNA719595_P_NODE_6186_length_257_cov_1.597826_g6151_i0	PRJNA719595	6186	257	1.597826	4.10641282	Spodoptera frugiperda	7108	Arthropoda	Arthropoda	43.1	0.0124	NR	KAF9791410.1	7108	g6151	i0	62.2	1.93774319066148	37	11	39.7	1	115	14	52	88	KAF9791410.1 hypothetical protein SFRURICE_015995 [Spodoptera frugiperda]	diamond	498	43.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera frugiperda
28957533	28957533	PRJNA719595_P_NODE_8708_length_245_cov_0.906977_g8673_i0	PRJNA719595	8708	245	0.906977	2.22209365	Metazoa	33208	Arthropoda	Arthropoda	102	4.789999999999999e-23	NR	KAL3217357.1	6941	g8673	i0	67.6	6.12244897959184	71	23	86.9	0	225	13	128	198	KAL3217357.1 hypothetical protein MRX96_032478 [Rhipicephalus microplus]	diamond	1500	102	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Rhipicephalus	Rhipicephalus microplus
29367856	29367856	PRJNA719595_P_NODE_6029_length_260_cov_1.657754_g5994_i0	PRJNA719595	6029	260	1.657754	4.3101604	Insecta	50557	Arthropoda	Arthropoda	113	2.26e-29	NR	CAK9830547.1	597843	g5994	i0	72.3	1.92692307692308	83	22	95.8	1	8	256	1	82	CAK9830547.1 60S ribosomal protein L17 [Anthophora retusa]	diamond	501	113	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Anthophora	Anthophora retusa
29462175	29462175	PRJNA719595_P_NODE_7910_length_248_cov_0.891429_g7875_i0	PRJNA719595	7910	248	0.891429	2.21074392	Calliphoridae	7371	Arthropoda	Arthropoda	58.9	7.84e-8	NR	XP_065369578.1	7373	g7875	i0	48	2.41935483870968	50	26	60.5	0	150	1	159	208	XP_065369578.1 protein 5NUC isoform X1 [Calliphora vicina]	diamond	600	58.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Calliphoridae	Calliphora	Calliphora vicina
30620667	30620667	PRJNA719595_P_NODE_7273_length_250_cov_0.881356_g7238_i0	PRJNA719595	7273	250	0.881356	2.20339	Fragariocoptes setiger	1670756	Arthropoda	Arthropoda	64.7	1.03e-10	NR	KAG9510839.1	1670756	g7238	i0	76.5	0.408	34	8	40.8	0	242	141	129	162	KAG9510839.1 Coiled-coil-helix-coiled-coil-helix domain-containing protein 2, partial [Fragariocoptes setiger]	diamond	102	64.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Phytoptidae	Fragariocoptes	Fragariocoptes setiger
30999980	30999980	PRJNA719595_P_NODE_8454_length_246_cov_0.901734_g8419_i0	PRJNA719595	8454	246	0.901734	2.21826564	Bombyx mori	7091	Arthropoda	Arthropoda	45.1	0.00566	NR	XP_004926831.3	7091	g8419	i0	75	0.292682926829268	24	6	29.3	0	148	77	105	128	XP_004926831.3 putative uncharacterized transposon-derived protein F52C9.6 [Bombyx mori]	diamond	72	45.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Bombycidae	Bombyx	Bombyx mori

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