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

10 rows where analysis = "diamond", bioproject = "PRJNA1088503" 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
2745203	2745203	PRJNA1088503_P_NODE_10783_length_171_cov_1.492958_g10411_i0	PRJNA1088503	10783	171	1.492958	2.55295818	Metazoa	33208	Arthropoda	Arthropoda	95.1	7.720000000000001e-22	NR	XP_014218664.1	29053	g10411	i0	85.7	12.7719298245614	56	8	98.2	0	3	170	151	206	XP_014218664.1 prohibitin-2 [Copidosoma floridanum]	diamond	2184	95.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Encyrtidae	Copidosoma	Copidosoma floridanum
24420384	24420384	PRJNA1088503_P_NODE_6320_length_306_cov_778.458484_g5948_i0	PRJNA1088503	6320	306	778.458484	2382.08296104	Cyprideis torosa	163714	Arthropoda	Arthropoda	97.4	4.429999999999999e-23	NR	CAD7233753.1	163714	g5948	i0	86.3	2.03921568627451	51	7	50	0	49	201	1	51	CAD7233753.1 unnamed protein product, partial [Cyprideis torosa]	diamond	624	97.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Ostracoda	Podocopida	Cytherideidae	Cyprideis	Cyprideis torosa
28172871	28172871	PRJNA1088503_P_NODE_2846_length_538_cov_4.047151_g2557_i0	PRJNA1088503	2846	538	4.047151	21.77367238	Tigriopus californicus	6832	Arthropoda	Arthropoda	57.8	4.27e-7	NR	TRY71880.1	6832	g2557	i0	60	0.223048327137546	40	15	21.7	1	1	117	5	44	TRY71880.1 hypothetical protein TCAL_14878 [Tigriopus californicus]	diamond	120	57.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Harpacticoida	Harpacticidae	Tigriopus	Tigriopus californicus
28669687	28669687	PRJNA1088503_P_NODE_7087_length_276_cov_1.987854_g6715_i0	PRJNA1088503	7087	276	1.987854	5.48647704	Arthropoda	6656	Arthropoda	Arthropoda	46.2	0.00324	NR	KAF7273786.1	354439	g6715	i0	31.8	1.73913043478261	85	38	90.2	4	271	23	14	80	KAF7273786.1 hypothetical protein GWI33_013514 [Rhynchophorus ferrugineus]	diamond	480	46.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Curculionidae	Rhynchophorus	Rhynchophorus ferrugineus
29616467	29616467	PRJNA1088503_P_NODE_9770_length_197_cov_1.809524_g9398_i0	PRJNA1088503	9770	197	1.809524	3.56476228	Insecta	50557	Arthropoda	Arthropoda	136	4.58e-39	NR	KAJ9580195.1	6984	g9398	i0	96.9	9.89847715736041	65	2	99	0	1	195	58	122	KAJ9580195.1 hypothetical protein L9F63_004138 [Diploptera punctata]	diamond	1950	136	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Blattodea	Blaberidae	Diploptera	Diploptera punctata
31394877	31394877	PRJNA1088503_P_NODE_10436_length_180_cov_1.602649_g10064_i0	PRJNA1088503	10436	180	1.602649	2.8847682	Eurycercus lamellatus	202080	Arthropoda	Arthropoda	70.5	1.8e-12	NR	CAG4642075.1	202080	g10064	i0	50.8	1.96666666666667	59	29	98.3	0	2	178	210	268	CAG4642075.1 EOG090X0EEI [Eurycercus lamellatus]	diamond	354	70.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Diplostraca	Eurycercidae	Eurycercus	Eurycercus lamellatus
31797115	31797115	PRJNA1088503_P_NODE_11397_length_157_cov_2.453125_g11025_i0	PRJNA1088503	11397	157	2.453125	3.85140625	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	103	1.06e-26	NR	XP_037290460.1	6941	g11025	i0	94.2	21.859872611465	52	3	99.4	0	1	156	73	124	XP_037290460.1 DNA-directed RNA polymerases I, II, and III subunit RPABC2-like [Rhipicephalus microplus]	diamond	3432	104	0.990384615384615	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Ixodida	Ixodidae	Rhipicephalus	Rhipicephalus microplus
32018794	32018794	PRJNA1088503_P_NODE_10698_length_173_cov_1.875000_g10326_i0	PRJNA1088503	10698	173	1.875	3.24375	Arthropoda	6656	Arthropoda	Arthropoda	47.4	1.68e-4	NR	XP_013771930.2	6850	g10326	i0	58.5	2.11560693641619	41	16	69.4	1	125	6	1	41	XP_013771930.2 ragulator complex protein LAMTOR1-like isoform X1 [Limulus polyphemus]	diamond	366	47.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Merostomata	Xiphosura	Limulidae	Limulus	Limulus polyphemus
32240521	32240521	PRJNA1088503_P_NODE_9978_length_192_cov_1.576687_g9606_i0	PRJNA1088503	9978	192	1.576687	3.02723904	Cicadellidae	30102	Arthropoda	Arthropoda	92	3.7e-21	NR	XP_054277555.1	74068	g9606	i0	76.2	22.640625	63	12	98.4	1	191	3	60	119	XP_054277555.1 polyadenylate-binding protein 2-B isoform X2 [Macrosteles quadrilineatus]	diamond	4347	92	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Cicadellidae	Macrosteles	Macrosteles quadrilineatus
32502238	32502238	PRJNA1088503_P_NODE_10439_length_180_cov_1.390728_g10067_i0	PRJNA1088503	10439	180	1.390728	2.5033104	Eriocheir sinensis	95602	Arthropoda	Arthropoda	74.3	1.09e-13	NR	XP_050737295.1	95602	g10067	i0	58.6	0.966666666666667	58	24	96.7	0	2	175	53	110	XP_050737295.1 cytochrome b-c1 complex subunit 2, mitochondrial-like [Eriocheir sinensis]	diamond	174	74.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Varunidae	Eriocheir	Eriocheir sinensis

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