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

8 rows where analysis = "diamond", bioproject = "PRJNA306153" 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
6754006	6754006	PRJNA306153_S_NODE_206_length_459_cov_5.425581_g194_i0	PRJNA306153	206	459	5.425581	24.90341679	Metazoa	33208	Arthropoda	Arthropoda	247	1.08e-72	NR	KAH0812308.1	7067	g194	i0	73.7	68.5490196078431	152	40	99.3	0	2	457	39	190	KAH0812308.1 hypothetical protein GEV33_010484 [Tenebrio molitor]	diamond	31464	249	0.991967871485944	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Tenebrionidae	Tenebrio	Tenebrio molitor
10580299	10580299	PRJNA306153_S_NODE_389_length_360_cov_3.389728_g376_i0	PRJNA306153	389	360	3.389728	12.203020799999999	Opisthokonta	33154	Arthropoda	Arthropoda	155	5.88e-46	NR	NP_001037209.1	7091	g376	i0	64.1	46.9666666666667	117	40	95.8	1	359	15	20	136	NP_001037209.1 ribosomal protein S15 [Bombyx mori]	diamond	16908	156	0.993589743589744	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Bombycidae	Bombyx	Bombyx mori
29744107	29744107	PRJNA306153_S_NODE_1390_length_205_cov_2.125000_g1377_i0	PRJNA306153	1390	205	2.125	4.35625	Ixodes	6944	Arthropoda	Arthropoda	61.2	6.72e-9	NR	CAL6250827.1	29930	g1377	i0	41.5	5.70731707317073	65	36	93.7	2	10	201	320	383	CAL6250827.1 unnamed protein product, partial [Ixodes pacificus]	diamond	1170	61.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Ixodes	Ixodes pacificus
30881637	30881637	PRJNA306153_S_NODE_1434_length_202_cov_5.028902_g1421_i0	PRJNA306153	1434	202	5.028902	10.15838204	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	90.1	5.74e-22	NR	XHB13796.1	34648	g1421	i0	74.1	4.63366336633663	58	15	86.1	0	3	176	6	63	XHB13796.1 putative venom peptide 511 [Mesobuthus eupeus]	diamond	936	90.9	0.991199119911991	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Scorpiones	Buthidae	Mesobuthus	Mesobuthus eupeus
31640395	31640395	PRJNA306153_S_NODE_556_length_310_cov_4.914591_g543_i0	PRJNA306153	556	310	4.914591	15.2352321	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	129	1.87e-34	NR	CAH0775212.1	7038	g543	i0	68.1	11.0612903225806	94	30	91	0	1	282	167	260	CAH0775212.1 unnamed protein product [Bemisia tabaci]	diamond	3429	129	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Bemisia	Bemisia tabaci
31925076	31925076	PRJNA306153_S_NODE_677_length_288_cov_5.277992_g664_i0	PRJNA306153	677	288	5.277992	15.20061696	Arachnida	6854	Arthropoda	Arthropoda	141	5.17e-40	NR	RWS30488.1	299467	g664	i0	67.7	6	96	31	100	0	288	1	103	198	RWS30488.1 ribosomal protein rpl23a-like protein [Leptotrombidium deliense]	diamond	1728	142	0.992957746478873	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Trombiculidae	Leptotrombidium	Leptotrombidium deliense
32115106	32115106	PRJNA306153_S_NODE_1738_length_187_cov_4.544304_g1725_i0	PRJNA306153	1738	187	4.544304	8.49784848	Arthropoda	6656	Arthropoda	Arthropoda	103	6.5e-26	NR	CAD7224002.1	163714	g1725	i0	77	5.8716577540107	61	14	97.9	0	3	185	15	75	CAD7224002.1 unnamed protein product [Cyprideis torosa]	diamond	1098	103	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Cytherideidae	Cyprideis	Cyprideis torosa
32666381	32666381	PRJNA306153_S_NODE_2700_length_153_cov_3.072581_g2687_i0	PRJNA306153	2700	153	3.072581	4.70104893	Hermetia illucens	343691	Arthropoda	Arthropoda	79	4.13e-17	NR	XP_037917729.1	343691	g2687	i0	77.6	5.7843137254902	49	11	96.1	0	5	151	8	56	XP_037917729.1 60S ribosomal protein L27 [Hermetia illucens]	diamond	885	79	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Stratiomyidae	Hermetia	Hermetia illucens

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