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

16 rows where analysis = "diamond", bioproject = "PRJNA1073712" 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
5290462	5290462	PRJNA1073712_P_NODE_8645_length_275_cov_1.524752_g8562_i0	PRJNA1073712	8645	275	1.524752	4.193068	Vespa	7443	Arthropoda	Arthropoda	85.1	6.74e-17	NR	XP_046813531.1	7445	g8562	i0	43.3	7.86545454545455	104	44	99.3	3	275	3	8	109	XP_046813531.1 cholinesterase 2-like [Vespa crabro]	diamond	2163	85.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Vespidae	Vespa	Vespa crabro
12941348	12941348	PRJNA1073712_P_NODE_15291_length_244_cov_0.900585_g15208_i0	PRJNA1073712	15291	244	0.900585	2.1974274	Cotesia	32390	Arthropoda	Arthropoda	120	1.65e-29	NR	XP_044593322.1	32391	g15208	i0	69.6	5.8155737704918	79	24	97.1	0	6	242	367	445	XP_044593322.1 cytoplasmic aconitate hydratase-like [Cotesia glomerata]	diamond	1419	120	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Braconidae	Cotesia	Cotesia glomerata
26814332	26814332	PRJNA1073712_P_NODE_14861_length_244_cov_1.801170_g14778_i0	PRJNA1073712	14861	244	1.80117	4.3948548	Polyplax serrata	468196	Arthropoda	Arthropoda	47.4	8.77e-4	NR	KAK6624327.1	468196	g14778	i0	44	0.614754098360656	50	28	61.5	0	234	85	444	493	KAK6624327.1 hypothetical protein RUM44_011186 [Polyplax serrata]	diamond	150	47.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Psocodea	Polyplacidae	Polyplax	Polyplax serrata
27438420	27438420	PRJNA1073712_P_NODE_8643_length_275_cov_1.524752_g8560_i0	PRJNA1073712	8643	275	1.524752	4.193068	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	75.1	1.35e-14	NR	KAK8786575.1	6943	g8560	i0	66	5.79272727272727	53	18	57.8	0	274	116	112	164	KAK8786575.1 hypothetical protein V5799_023650 [Amblyomma americanum]	diamond	1593	75.5	0.994701986754967	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Amblyomma	Amblyomma americanum
28488656	28488656	PRJNA1073712_P_NODE_7007_length_295_cov_1.734234_g6924_i0	PRJNA1073712	7007	295	1.734234	5.1159903	Spodoptera exigua	7107	Arthropoda	Arthropoda	60.1	6.68e-9	NR	CAH0691675.1	7107	g6924	i0	47.5	3.68135593220339	61	26	62	1	295	113	74	128	CAH0691675.1 unnamed protein product [Spodoptera exigua]	diamond	1086	60.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Noctuidae	Spodoptera	Spodoptera exigua
28772655	28772655	PRJNA1073712_P_NODE_17267_length_230_cov_3.254777_g17184_i0	PRJNA1073712	17267	230	3.254777	7.4859871	Monomorium pharaonis	307658	Arthropoda	Arthropoda	88.6	4.6e-21	NR	XP_028051070.1	307658	g17184	i0	82.6	0.6	46	8	60	0	138	1	5	50	XP_028051070.1 uncharacterized protein LOC114255739 [Monomorium pharaonis]	diamond	138	88.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Formicidae	Monomorium	Monomorium pharaonis
29143426	29143426	PRJNA1073712_P_NODE_3849_length_363_cov_1.062069_g3766_i0	PRJNA1073712	3849	363	1.062069	3.85531047	Arachnida	6854	Arthropoda	Arthropoda	110	1.25e-28	NR	AAY66958.1	6945	g3766	i0	59.1	1.90082644628099	115	45	93.4	1	21	359	1	115	AAY66958.1 ribosomal protein L35 [Ixodes scapularis]	diamond	690	110	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Ixodes	Ixodes scapularis
29372670	29372670	PRJNA1073712_P_NODE_15469_length_243_cov_1.405882_g15386_i0	PRJNA1073712	15469	243	1.405882	3.41629326	Artemia franciscana	6661	Arthropoda	Arthropoda	134	8.459999999999998e-35	NR	XP_065574307.1	6661	g15386	i0	92.4	3.90123456790123	79	6	97.5	0	6	242	355	433	XP_065574307.1 adenylyl cyclase-associated protein 1-like isoform X1 [Artemia franciscana]	diamond	948	134	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
29869378	29869378	PRJNA1073712_P_NODE_1591_length_495_cov_1.094787_g1508_i0	PRJNA1073712	1591	495	1.094787	5.41919565	Lepidoptera	7088	Arthropoda	Arthropoda	270	3.3299999999999993e-81	NR	XP_037867168.2	7091	g1508	i0	73.1	3.06060606060606	167	41	98.8	1	7	495	571	737	XP_037867168.2 RNA-directed DNA polymerase from mobile element jockey [Bombyx mori]	diamond	1515	270	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Bombycidae	Bombyx	Bombyx mori
30130241	30130241	PRJNA1073712_P_NODE_4472_length_344_cov_2.583026_g4389_i0	PRJNA1073712	4472	344	2.583026	8.88560944	Pollicipes pollicipes	41117	Arthropoda	Arthropoda	67	2.6200000000000003e-10	NR	XP_037083196.1	41117	g4389	i0	38.3	2.43313953488372	107	63	91.6	2	327	13	1	106	XP_037083196.1 procathepsin L-like [Pollicipes pollicipes]	diamond	837	67	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Thecostraca	Pollicipedomorpha	Pollicipedidae	Pollicipes	Pollicipes pollicipes
30509728	30509728	PRJNA1073712_P_NODE_14513_length_245_cov_0.895349_g14430_i0	PRJNA1073712	14513	245	0.895349	2.19360505	Bradysia odoriphaga	1564500	Arthropoda	Arthropoda	47.8	6.21e-4	NR	KAG4074334.1	1564500	g14430	i0	34.7	1.57959183673469	72	43	88.2	2	244	29	112	179	KAG4074334.1 hypothetical protein HA402_008743 [Bradysia odoriphaga]	diamond	387	47.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Sciaridae	Bradysia	Bradysia odoriphaga
30532809	30532809	PRJNA1073712_P_NODE_5893_length_314_cov_1.278008_g5810_i0	PRJNA1073712	5893	314	1.278008	4.01294512	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	83.2	5.48e-16	NR	OAD59060.1	516756	g5810	i0	46.9	6.70700636942675	96	48	88.9	2	295	17	15	110	OAD59060.1 hypothetical protein WN48_09369 [Eufriesea mexicana]	diamond	2106	83.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Eufriesea	Eufriesea mexicana
30541303	30541303	PRJNA1073712_P_NODE_15173_length_244_cov_0.900585_g15090_i0	PRJNA1073712	15173	244	0.900585	2.1974274	Atta colombica	520822	Arthropoda	Arthropoda	43.9	0.0149	NR	KYM86072.1	520822	g15090	i0	80	0.614754098360656	25	4	30.7	1	229	155	613	636	KYM86072.1 Mitochondrial Rho GTPase [Atta colombica]	diamond	150	43.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Formicidae	Atta	Atta colombica
31268118	31268118	PRJNA1073712_P_NODE_12815_length_248_cov_0.880000_g12732_i0	PRJNA1073712	12815	248	0.88	2.1824	Anthonomus grandis grandis	2921223	Arthropoda	Arthropoda	59.3	4.73e-8	NR	XP_050308813.1	2921223	g12732	i0	38.1	2.02016129032258	84	50	99.2	2	2	247	153	236	XP_050308813.1 venom protease isoform X2 [Anthonomus grandis grandis]	diamond	501	59.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Curculionidae	Anthonomus	Anthonomus grandis
31805758	31805758	PRJNA1073712_P_NODE_2797_length_403_cov_1.293939_g2714_i0	PRJNA1073712	2797	403	1.293939	5.21457417	Bombyx mori	7091	Arthropoda	Arthropoda	177	1.6399999999999998e-48	NR	XP_037872913.1	7091	g2714	i0	68.3	2.78411910669975	123	38	91.6	1	401	33	221	342	XP_037872913.1 LINE-1 reverse transcriptase homolog [Bombyx mori]	diamond	1122	177	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Bombycidae	Bombyx	Bombyx mori
32090567	32090567	PRJNA1073712_P_NODE_14958_length_244_cov_0.900585_g14875_i0	PRJNA1073712	14958	244	0.900585	2.1974274	Macrosteles quadrilineatus	74068	Arthropoda	Arthropoda	80.9	1.72e-16	NR	XP_054290264.1	74068	g14875	i0	70.8	2.45901639344262	48	14	59	0	242	99	173	220	XP_054290264.1 ubiquitin carboxyl-terminal hydrolase isozyme L3-like isoform X2 [Macrosteles quadrilineatus]	diamond	600	80.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Cicadellidae	Macrosteles	Macrosteles quadrilineatus

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