metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA849646" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA849646" 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
17416312	17416312	PRJNA849646_P_NODE_14674_length_278_cov_3.658537_g14556_i0	PRJNA849646	14674	278	3.658537	10.17073286	Tyrophagus putrescentiae	59818	Arthropoda	Arthropoda	175	4.5e-51	NR	KAH9392264.1	59818	g14556	i0	94.6	1.00359712230216	93	4	99.3	1	278	3	255	347	KAH9392264.1 hypothetical protein TYRP_005337, partial [Tyrophagus putrescentiae]	diamond	279	175	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Acaridae	Tyrophagus	Tyrophagus putrescentiae
26611535	26611535	PRJNA849646_P_NODE_12321_length_283_cov_1.880952_g12203_i0	PRJNA849646	12321	283	1.880952	5.32309416	Bradysia coprophila	38358	Arthropoda	Arthropoda	79.7	6.04e-15	NR	XP_037047073.1	38358	g12203	i0	50.8	0.667844522968198	63	31	66.8	0	191	3	535	597	XP_037047073.1 uncharacterized protein LOC119081902 [Bradysia coprophila]	diamond	189	79.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Sciaridae	Bradysia	Bradysia coprophila
27181126	27181126	PRJNA849646_P_NODE_31662_length_248_cov_2.537143_g31544_i0	PRJNA849646	31662	248	2.537143	6.29211464	Artemia franciscana	6661	Arthropoda	Arthropoda	68.9	1.87e-11	NR	KAK2726085.1	6661	g31544	i0	44.6	1.92338709677419	83	43	96.8	2	248	9	42	124	KAK2726085.1 hypothetical protein QYM36_000516 [Artemia franciscana]	diamond	477	68.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
27307933	27307933	PRJNA849646_P_NODE_15123_length_278_cov_1.243902_g15005_i0	PRJNA849646	15123	278	1.243902	3.45804756	Artemia franciscana	6661	Arthropoda	Arthropoda	50.8	1.35e-5	NR	KAK2726327.1	6661	g15005	i0	90.9	0.474820143884892	22	2	23.7	0	2	67	96	117	KAK2726327.1 hypothetical protein QYM36_000688, partial [Artemia franciscana]	diamond	132	50.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
27844412	27844412	PRJNA849646_P_NODE_5844_length_310_cov_2.801688_g5726_i0	PRJNA849646	5844	310	2.801688	8.6852328	Pediculus humanus corporis	121224	Arthropoda	Arthropoda	87.4	1.68e-17	NR	XP_002431439.1	121224	g5726	i0	52.4	0.812903225806452	84	23	65.8	2	1	204	119	201	XP_002431439.1 ngd5/osm-6/ift52, putative [Pediculus humanus corporis]	diamond	252	87.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Psocodea	Pediculidae	Pediculus	Pediculus humanus
28002660	28002660	PRJNA849646_P_NODE_37585_length_242_cov_0.911243_g37467_i0	PRJNA849646	37585	242	0.911243	2.20520806	Stegodyphus mimosarum	407821	Arthropoda	Arthropoda	67	3.36e-11	NR	KFM77225.1	407821	g37467	i0	66.7	0.59504132231405	48	16	59.5	0	73	216	179	226	KFM77225.1 hypothetical protein X975_20207, partial [Stegodyphus mimosarum]	diamond	144	67	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Eresidae	Stegodyphus	Stegodyphus mimosarum
29928698	29928698	PRJNA849646_P_NODE_10671_length_286_cov_2.615023_g10553_i0	PRJNA849646	10671	286	2.615023	7.47896578	Tyrophagus putrescentiae	59818	Arthropoda	Arthropoda	166	3.82e-45	NR	KAH9389687.1	59818	g10553	i0	93.5	0.975524475524476	93	5	96.5	1	1	276	1114	1206	KAH9389687.1 hypothetical protein TYRP_007234 [Tyrophagus putrescentiae]	diamond	279	166	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Acaridae	Tyrophagus	Tyrophagus putrescentiae
30117956	30117956	PRJNA849646_P_NODE_12612_length_282_cov_3.516746_g12494_i0	PRJNA849646	12612	282	3.516746	9.91722372	Trichonephila clavipes	2585209	Arthropoda	Arthropoda	53.5	8.2e-7	NR	GFV10763.1	2585209	g12494	i0	55.8	1.19148936170213	52	22	55.3	1	38	193	5	55	GFV10763.1 hypothetical protein TNCV_1756011 [Trichonephila clavipes]	diamond	336	53.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Nephilidae	Trichonephila	Trichonephila clavipes
30308138	30308138	PRJNA849646_P_NODE_29432_length_251_cov_0.865169_g29314_i0	PRJNA849646	29432	251	0.865169	2.17157419	Oedothorax gibbosus	931172	Arthropoda	Arthropoda	67.4	8.76e-11	NR	KAG8186591.1	931172	g29314	i0	41.5	4.9003984063745	82	47	98	1	1	246	533	613	KAG8186591.1 hypothetical protein JTE90_019913 [Oedothorax gibbosus]	diamond	1230	67.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Linyphiidae	Oedothorax	Oedothorax gibbosus
31160337	31160337	PRJNA849646_P_NODE_12535_length_283_cov_1.176190_g12417_i0	PRJNA849646	12535	283	1.17619	3.3286177	Hetaerina americana	62018	Arthropoda	Arthropoda	51.2	6.17e-5	NR	XP_071449256.1	62018	g12417	i0	36.5	0.784452296819788	74	40	78.4	1	258	37	74	140	XP_071449256.1 membrane-bound transcription factor site-2 protease [Hetaerina americana]	diamond	222	51.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Odonata	Calopterygidae	Hetaerina	Hetaerina americana
32173169	32173169	PRJNA849646_P_NODE_8198_length_292_cov_1.995434_g8080_i0	PRJNA849646	8198	292	1.995434	5.82666728	Limulus polyphemus	6850	Arthropoda	Arthropoda	79.3	4.16e-15	NR	XP_013785434.1	6850	g8080	i0	51.4	0.73972602739726	72	26	64.7	1	191	3	60	131	XP_013785434.1 failed axon connections homolog [Limulus polyphemus]	diamond	216	79.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Merostomata	Xiphosura	Limulidae	Limulus	Limulus polyphemus
32331532	32331532	PRJNA849646_P_NODE_32179_length_248_cov_0.880000_g32061_i0	PRJNA849646	32179	248	0.88	2.1824	Artemia franciscana	6661	Arthropoda	Arthropoda	60.5	1.84e-8	NR	XP_065564121.1	6661	g32061	i0	61.5	1.88709677419355	52	15	56.9	1	108	248	35	86	XP_065564121.1 uncharacterized protein LOC136029563 [Artemia franciscana]	diamond	468	60.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
32434677	32434677	PRJNA849646_P_NODE_3099_length_328_cov_2.325490_g2981_i0	PRJNA849646	3099	328	2.32549	7.6276072	Diptera	7147	Arthropoda	Arthropoda	47.4	0.00153	NR	XP_021695600.1	7159	g2981	i0	71.4	1.76524390243902	35	10	32	0	204	308	123	157	XP_021695600.1 protein phosphatase inhibitor 2 isoform X1 [Aedes aegypti]	diamond	579	47.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Aedes	Aedes aegypti
32741782	32741782	PRJNA849646_P_NODE_31900_length_248_cov_1.760000_g31782_i0	PRJNA849646	31900	248	1.76	4.3648	Orchesella dallaii	48710	Arthropoda	Arthropoda	92.4	1.32e-19	NR	CAL8088945.1	48710	g31782	i0	62.6	2.20161290322581	91	20	96.8	3	241	2	173	260	CAL8088945.1 unnamed protein product [Orchesella dallaii]	diamond	546	92.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Collembola	Entomobryomorpha	Orchesellidae	Orchesella	Orchesella dallaii
32781220	32781220	PRJNA849646_P_NODE_20420_length_267_cov_3.500000_g20302_i0	PRJNA849646	20420	267	3.5	9.345	Insecta	50557	Arthropoda	Arthropoda	107	9.03e-25	NR	KAJ4448512.1	6978	g20302	i0	96.2	30.3820224719101	52	2	58.4	0	110	265	886	937	KAJ4448512.1 hypothetical protein ANN_10528 [Periplaneta americana]	diamond	8112	108	0.990740740740741	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Blattodea	Blattidae	Periplaneta	Periplaneta americana
32804531	32804531	PRJNA849646_P_NODE_19740_length_269_cov_1.571429_g19622_i0	PRJNA849646	19740	269	1.571429	4.22714401	Artemia franciscana	6661	Arthropoda	Arthropoda	83.6	2.2e-16	NR	XP_065583298.1	6661	g19622	i0	58.2	0.747211895910781	67	28	74.7	0	2	202	317	383	XP_065583298.1 uncharacterized protein LOC136042250 [Artemia franciscana]	diamond	201	83.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana

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