metadata: contig_metadata: 14 rows where bioproject = "PRJNA753112" and tax

14 rows where bioproject = "PRJNA753112" 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
4557179	4557179	PRJNA753112_P_NODE_11184_length_406_cov_0.936937_g10842_i0	PRJNA753112	11184	406	0.936937	3.80396422	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	103	1.62e-25	NR	KAH9399477.1	59818	g10842	i0	43.8	13.5	121	64	86.5	2	29	379	12	132	KAH9399477.1 60S ribosomal protein L22 [Tyrophagus putrescentiae]	diamond	5481	103	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Acaridae	Tyrophagus	Tyrophagus putrescentiae
5832458	5832458	PRJNA753112_P_NODE_18165_length_318_cov_3.163265_g17823_i0	PRJNA753112	18165	318	3.163265	10.0591827	Chelidurella thaleri	2546182	Arthropoda	Arthropoda	54.7	0.008	NTclustered	gi\|2919609222\|emb\|OZ238411.1\|	2546182	g17823	i0	100	0.0911949685534591	29	0	9	0	260	288	4184148	4184120	Chelidura thaleri genome assembly, chromosome: 12	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Dermaptera	Forficulidae	Chelidurella	Chelidurella thaleri
7107972	7107972	PRJNA753112_P_NODE_7806_length_489_cov_1.959135_g7464_i0	PRJNA753112	7806	489	1.959135	9.58017015	Daphnia sinensis	1820382	Arthropoda	Arthropoda	132	9.92e-36	NR	KAI9549990.1	1820382	g7464	i0	48.2	3.34969325153374	137	70	83.4	1	473	66	45	181	KAI9549990.1 hypothetical protein GHT06_007518 [Daphnia sinensis]	diamond	1638	132	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Daphniidae	Daphnia	Daphnia sinensis
9657601	9657601	PRJNA753112_P_NODE_30388_length_249_cov_0.886364_g30046_i0	PRJNA753112	30388	249	0.886364	2.20704636	Darwinula stevensoni	69355	Arthropoda	Arthropoda	195	3.5399999999999996e-45	NTclustered	gi\|1936654543\|emb\|LR947198.1\|	69355	g30046	i0	90.604	0.598393574297189	149	11	59	3	104	249	101	249	Darwinula stevensoni	blastn	149	195	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Darwinulidae	Darwinula	Darwinula stevensoni
10932826	10932826	PRJNA753112_P_NODE_16089_length_338_cov_2.109434_g15747_i0	PRJNA753112	16089	338	2.109434	7.12988692	Darwinula stevensoni	69355	Arthropoda	Arthropoda	272	2.25e-68	NTclustered	gi\|1936726837\|emb\|LR952475.1\|	69355	g15747	i0	83.278	3.32544378698225	299	47	88	3	40	338	458	163	Darwinula stevensoni	blastn	1124	272	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Darwinulidae	Darwinula	Darwinula stevensoni
12208551	12208551	PRJNA753112_P_NODE_29810_length_250_cov_2.604520_g29468_i0	PRJNA753112	29810	250	2.60452	6.5113	Entomobrya sp. 1 FZ-2013	1304845	Arthropoda	Arthropoda	451	1.91e-122	NTclustered	gi\|472455965\|gb\|KC236319.1\|	1304845	g29468	i0	99.2	100.848	250	2	100	0	1	250	98	347	Entomobrya sp. 1 FZ-2013 28S ribosomal RNA gene, partial sequence	blastn	25212	451	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Collembola	Entomobryomorpha	Entomobryidae	Entomobrya	Entomobrya sp. 1 FZ-2013
13955411	13955411	PRJNA753112_P_NODE_11891_length_394_cov_1.152648_g11549_i0	PRJNA753112	11891	394	1.152648	4.54143312	Tyrophagus	41443	Arthropoda	Arthropoda	701	0	NTclustered	gi\|1912461452\|gb\|MN857506.1\|	59818	g11549	i0	98.731	37.0253807106599	394	5	100	0	1	394	4632	4239	Tyrophagus putrescentiae voucher UMMZ BMOC 17-0108-002 PMR 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	14588	701	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Acaridae	Tyrophagus	Tyrophagus putrescentiae
14757969	14757969	PRJNA753112_P_NODE_28472_length_254_cov_1.723757_g28130_i0	PRJNA753112	28472	254	1.723757	4.37834278	Charissa obscurata	204503	Arthropoda	Arthropoda	52.8	0.023	NTclustered	gi\|2919559730\|emb\|OZ238369.1\|	204503	g28130	i0	96.774	0.122047244094488	31	1	12	0	161	191	13587230	13587260	Charissa obscurata genome assembly, chromosome: 3	blastn	31	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Geometridae	Charissa	Charissa obscurata
14758192	14758192	PRJNA753112_P_NODE_8872_length_457_cov_1.617188_g8530_i0	PRJNA753112	8872	457	1.617188	7.39054916	Linepithema humile	83485	Arthropoda	Arthropoda	52.8	0.044	NTclustered	gi\|2788948857\|ref\|XR_010888252.1\|	83485	g8530	i0	100	0.0612691466083151	28	0	6	0	52	79	327	300	PREDICTED: Linepithema humile uncharacterized lncRNA (LOC136997530), ncRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Formicidae	Linepithema	Linepithema humile
21603676	21603676	PRJNA753112_P_NODE_16517_length_334_cov_1.632184_g16175_i0	PRJNA753112	16517	334	1.632184	5.45149456	root	1	Root_unresolved	Root_unresolved	58.4	6.77e-4	NTclustered	gi\|805796039\|ref\|XM_012287789.1\|	143995	g16175	i0	100	4.08982035928144	31	0	9	0	302	332	2504	2534	PREDICTED: Megachile rotundata putative thiamine transporter SLC35F3 (LOC100879637), transcript variant X4, mRNA	blastn	1366	58.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Megachilidae	Megachile	Megachile rotundata
24153100	24153100	PRJNA753112_P_NODE_11339_length_403_cov_2.360606_g10997_i0	PRJNA753112	11339	403	2.360606	9.51324218	Dermatophagoides farinae	6954	Arthropoda	Arthropoda	159	1.18e-45	NR	XP_046909420.1	6954	g10997	i0	60.2	23.7617866004963	133	42	99	2	5	403	65	186	XP_046909420.1 40S ribosomal protein S2-like [Dermatophagoides farinae]	diamond	9576	159	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Dermatophagoides	Dermatophagoides farinae
28379307	28379307	PRJNA753112_P_NODE_23146_length_283_cov_1.719048_g22804_i0	PRJNA753112	23146	283	1.719048	4.86490584	Uloborus diversus	327109	Arthropoda	Arthropoda	119	1.51e-30	NR	XP_054713810.1	327109	g22804	i0	54.7	1.99293286219081	95	42	99.6	1	2	283	80	174	XP_054713810.1 ribosome biogenesis protein BRX1 homolog [Uloborus diversus]	diamond	564	119	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Uloboridae	Uloborus	Uloborus diversus
28726676	28726676	PRJNA753112_P_NODE_9827_length_433_cov_1.733333_g9485_i0	PRJNA753112	9827	433	1.733333	7.50533189	Lepeophtheirus salmonis	72036	Arthropoda	Arthropoda	98.6	1.35e-22	NR	ADD38186.1	72036	g9485	i0	35.3	0.963048498845266	139	85	96.3	1	429	13	3	136	ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis]	diamond	417	98.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Siphonostomatoida	Caligidae	Lepeophtheirus	Lepeophtheirus salmonis
30567990	30567990	PRJNA753112_P_NODE_12733_length_379_cov_4.751634_g12391_i0	PRJNA753112	12733	379	4.751634	18.00869286	root	1	Root_unresolved	Root_unresolved	46.2	0.00665	NR	BAM20583.1	76194	g12391	i0	37.9	1.58311345646438	66	35	47.5	1	241	62	57	122	BAM20583.1 unknown secreted protein, partial [Papilio polytes]	diamond	600	46.6	0.991416309012876	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Papilionidae	Papilio	Papilio polytes

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