metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1253303" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1253303" 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
359357	359357	PRJNA1253303_P_NODE_5401_length_252_cov_0.871508_g5379_i0	PRJNA1253303	5401	252	0.871508	2.19620016	Diptera	7147	Arthropoda	Arthropoda	126	3.99e-32	NR	XP_004518446.1	7213	g5379	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
11838118	11838118	PRJNA1253303_P_NODE_6290_length_249_cov_0.886364_g6268_i0	PRJNA1253303	6290	249	0.886364	2.20704636	Lepeophtheirus salmonis	72036	Arthropoda	Arthropoda	131	1.7999999999999998e-36	NR	ADD38729.1	72036	g6268	i0	78.8	2.85542168674699	80	17	96.4	0	241	2	15	94	ADD38729.1 60S ribosomal protein L11 [Lepeophtheirus salmonis]	diamond	711	131	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Siphonostomatoida	Caligidae	Lepeophtheirus	Lepeophtheirus salmonis
27547731	27547731	PRJNA1253303_P_NODE_5444_length_252_cov_0.871508_g5422_i0	PRJNA1253303	5444	252	0.871508	2.19620016	Sergentomyia squamirostris	2283857	Arthropoda	Arthropoda	134	5.0299999999999995e-37	NR	GAB0089917.1	2283857	g5422	i0	74.7	6.91666666666667	83	21	98.8	0	251	3	1	83	GAB0089917.1 60S ribosomal protein L8 [Sergentomyia squamirostris]	diamond	1743	134	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Psychodidae	Sergentomyia	Sergentomyia squamirostris
28165587	28165587	PRJNA1253303_P_NODE_2585_length_329_cov_1.218750_g2563_i0	PRJNA1253303	2585	329	1.21875	4.0096875	Opisthokonta	33154	Arthropoda	Arthropoda	186	5.37e-57	NR	XP_064471608.1	34597	g2563	i0	78.9	21.8480243161094	109	23	99.4	0	3	329	112	220	XP_064471608.1 peroxiredoxin-2-like [Ornithodoros turicata]	diamond	7188	187	0.994652406417112	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Argasidae	Ornithodoros	Ornithodoros turicata
29379066	29379066	PRJNA1253303_P_NODE_6309_length_249_cov_0.886364_g6287_i0	PRJNA1253303	6309	249	0.886364	2.20704636	Blattella germanica	6973	Arthropoda	Arthropoda	78.2	1.34e-14	NR	Q964T2.1	6973	g6287	i0	46.5	2.03614457831325	86	42	98.8	1	1	246	405	490	Q964T2.1 RecName: Full=Cytochrome P450 9e2; AltName: Full=CYPIXE2 [Blattella germanica]	diamond	507	78.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Blattodea	Blattellidae	Blattella	Blattella germanica
31084875	31084875	PRJNA1253303_P_NODE_3695_length_286_cov_1.464789_g3673_i0	PRJNA1253303	3695	286	1.464789	4.18929654	Euwallacea fornicatus	995702	Arthropoda	Arthropoda	76.6	6.05e-14	NR	XP_066145464.1	995702	g3673	i0	46.7	1.88811188811189	92	38	85	2	23	265	8	99	XP_066145464.1 lysosomal aspartic protease-like [Euwallacea fornicatus]	diamond	540	76.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Curculionidae	Euwallacea	Euwallacea fornicatus
31210750	31210750	PRJNA1253303_P_NODE_2335_length_342_cov_1.092937_g2313_i0	PRJNA1253303	2335	342	1.092937	3.73784454	Parasteatoda tepidariorum	114398	Arthropoda	Arthropoda	53.9	1.53e-5	NR	XP_071042544.1	114398	g2313	i0	42.4	0.578947368421053	66	21	43	2	1	147	281	346	XP_071042544.1 basement membrane-specific heparan sulfate proteoglycan core protein [Parasteatoda tepidariorum]	diamond	198	53.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Theridiidae	Parasteatoda	Parasteatoda tepidariorum
32336553	32336553	PRJNA1253303_P_NODE_4599_length_260_cov_1.657754_g4577_i0	PRJNA1253303	4599	260	1.657754	4.3101604	Insecta	50557	Arthropoda	Arthropoda	113	2.26e-29	NR	CAK9830547.1	597843	g4577	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
32413463	32413463	PRJNA1253303_P_NODE_7279_length_246_cov_0.901734_g7257_i0	PRJNA1253303	7279	246	0.901734	2.21826564	Bombyx mori	7091	Arthropoda	Arthropoda	45.1	0.00566	NR	XP_004926831.3	7091	g7257	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
32634239	32634239	PRJNA1253303_P_NODE_6140_length_249_cov_0.886364_g6118_i0	PRJNA1253303	6140	249	0.886364	2.20704636	Uranotaenia lowii	190385	Arthropoda	Arthropoda	74.3	2.94e-13	NR	XP_055606624.1	190385	g6118	i0	50.7	4.42168674698795	73	34	88	1	223	5	19	89	XP_055606624.1 signal recognition particle subunit SRP68 [Uranotaenia lowii]	diamond	1101	74.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Uranotaenia	Uranotaenia lowii

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