metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA547066" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA547066" 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
27014576	27014576	PRJNA547066_P_NODE_4502_length_186_cov_1.059603_g4408_i0	PRJNA547066	4502	186	1.059603	1.97086158	Dinothrombium tinctorium	1965070	Arthropoda	Arthropoda	61.6	3.75e-9	NR	RWS13046.1	1965070	g4408	i0	65.1	0.693548387096774	43	15	69.4	0	54	182	47	89	RWS13046.1 zinc finger protein 1-like protein [Dinothrombium tinctorium]	diamond	129	61.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Trombidiidae	Dinothrombium	Dinothrombium tinctorium
27867462	27867462	PRJNA547066_P_NODE_5225_length_168_cov_0.879699_g5131_i0	PRJNA547066	5225	168	0.879699	1.47789432	Tetranychus urticae	32264	Arthropoda	Arthropoda	58.5	1.92e-8	NR	XP_025016543.1	32264	g5131	i0	58.9	2	56	22	100	1	1	168	15	69	XP_025016543.1 glucose-induced degradation protein 8 homolog [Tetranychus urticae]	diamond	336	58.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Tetranychus	Tetranychus urticae
29193910	29193910	PRJNA547066_P_NODE_4829_length_177_cov_1.105634_g4735_i0	PRJNA547066	4829	177	1.105634	1.95697218	Dinothrombium tinctorium	1965070	Arthropoda	Arthropoda	43.1	0.0113	NR	RWS10004.1	1965070	g4735	i0	50	0.813559322033898	48	20	74.6	1	140	9	500	547	RWS10004.1 hypothetical protein B4U79_08603 [Dinothrombium tinctorium]	diamond	144	43.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Trombidiidae	Dinothrombium	Dinothrombium tinctorium
30440458	30440458	PRJNA547066_P_NODE_3453_length_231_cov_2.239796_g3359_i0	PRJNA547066	3453	231	2.239796	5.17392876	Arachnida	6854	Arthropoda	Arthropoda	112	1.27e-26	NR	KAJ6222096.1	40697	g3359	i0	64.5	4.64935064935065	76	26	98.7	1	2	229	103	177	KAJ6222096.1 hypothetical protein RDWZM_000641 [Blomia tropicalis]	diamond	1074	112	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Echimyopodidae	Blomia	Blomia tropicalis
32084253	32084253	PRJNA547066_P_NODE_4778_length_178_cov_1.552448_g4684_i0	PRJNA547066	4778	178	1.552448	2.76335744	Metazoa	33208	Arthropoda	Arthropoda	41.6	0.0276	NR	XP_064486094.1	34597	g4684	i0	48	5.20786516853933	50	23	84.3	1	164	15	115	161	XP_064486094.1 alpha-crystallin A chain-like [Ornithodoros turicata]	diamond	927	42	0.990476190476191	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Argasidae	Ornithodoros	Ornithodoros turicata
32858984	32858984	PRJNA547066_P_NODE_3940_length_208_cov_1.086705_g3846_i0	PRJNA547066	3940	208	1.086705	2.2603464	Tetranychus urticae	32264	Arthropoda	Arthropoda	120	7.449999999999998e-30	NR	XP_015787051.1	32264	g3846	i0	79.4	0.980769230769231	68	14	98.1	0	4	207	68	135	XP_015787051.1 alpha-protein kinase 1 [Tetranychus urticae]	diamond	204	120	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Tetranychus	Tetranychus urticae

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