metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA474426" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA474426" 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
27676753	27676753	PRJNA474426_P_NODE_9764_length_344_cov_1.745763_g9559_i0	PRJNA474426	9764	344	1.745763	6.00542472	Petrolisthes cinctipes	88211	Arthropoda	Arthropoda	48.5	3.57e-4	NR	KAK3889318.1	88211	g9559	i0	33	0.793604651162791	91	47	76.7	5	48	311	16	95	KAK3889318.1 hypothetical protein Pcinc_006668 [Petrolisthes cinctipes]	diamond	273	48.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Porcellanidae	Petrolisthes	Petrolisthes cinctipes
27929153	27929153	PRJNA474426_P_NODE_35065_length_164_cov_0.895652_g34860_i0	PRJNA474426	35065	164	0.895652	1.46886928	Armadillidium nasatum	96803	Arthropoda	Arthropoda	44.3	0.0036	NR	KAB7501538.1	96803	g34860	i0	42.6	0.98780487804878	54	28	95.1	2	158	3	86	138	KAB7501538.1 hypothetical protein Anas_13330 [Armadillidium nasatum]	diamond	162	44.3	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Armadillidiidae	Armadillidium	Armadillidium nasatum
28229121	28229121	PRJNA474426_P_NODE_9686_length_346_cov_1.680135_g9481_i0	PRJNA474426	9686	346	1.680135	5.8132671	Insecta	50557	Arthropoda	Arthropoda	85.1	1.82e-16	NR	XP_014225606.1	7493	g9481	i0	42.6	5.70520231213873	108	60	93.6	1	331	8	123	228	XP_014225606.1 protein mini spindles isoform X2 [Trichogramma pretiosum]	diamond	1974	85.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Trichogrammatidae	Trichogramma	Trichogramma pretiosum
29539255	29539255	PRJNA474426_P_NODE_33110_length_167_cov_0.838983_g32905_i0	PRJNA474426	33110	167	0.838983	1.40110161	Condylostylus longicornis	2530218	Arthropoda	Arthropoda	94.4	1.1e-22	NR	XP_055380919.1	2530218	g32905	i0	78.2	1.95808383233533	55	12	98.8	0	167	3	6	60	XP_055380919.1 J domain-containing protein [Condylostylus longicornis]	diamond	327	94.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Dolichopodidae	Condylostylus	Condylostylus longicornis
30661068	30661068	PRJNA474426_P_NODE_28333_length_181_cov_2.939394_g28128_i0	PRJNA474426	28333	181	2.939394	5.32030314	Metazoa	33208	Arthropoda	Arthropoda	41.6	0.0436	NR	XP_022254126.1	6850	g28128	i0	39.2	2.75138121546961	51	31	84.5	0	2	154	1408	1458	XP_022254126.1 uncharacterized protein LOC106469854 [Limulus polyphemus]	diamond	498	42	0.990476190476191	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Merostomata	Xiphosura	Limulidae	Limulus	Limulus polyphemus
30755953	30755953	PRJNA474426_P_NODE_22114_length_211_cov_1.123457_g21909_i0	PRJNA474426	22114	211	1.123457	2.37049427	Opisthokonta	33154	Arthropoda	Arthropoda	52.4	9.34e-6	NR	GLH16767.1	6999	g21909	i0	45.3	1.29383886255924	53	29	75.4	0	167	9	179	231	GLH16767.1 Ankyrin2 [Gryllus bimaculatus]	diamond	273	52.8	0.992424242424242	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Orthoptera	Gryllidae	Gryllus	Gryllus bimaculatus
31909592	31909592	PRJNA474426_P_NODE_17597_length_242_cov_1.740933_g17392_i0	PRJNA474426	17597	242	1.740933	4.21305786	Artemia franciscana	6661	Arthropoda	Arthropoda	46.6	0.00146	NR	XP_065584274.1	6661	g17392	i0	47.1	0.632231404958678	51	27	63.2	0	221	69	1	51	XP_065584274.1 ankyrin-1-like, partial [Artemia franciscana]	diamond	153	46.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Branchiopoda	Anostraca	Artemiidae	Artemia	Artemia franciscana
32511084	32511084	PRJNA474426_P_NODE_19599_length_226_cov_1.644068_g19394_i0	PRJNA474426	19599	226	1.644068	3.71559368	Artemia franciscana	6661	Arthropoda	Arthropoda	113	8.349999999999999e-28	NR	KAK2705440.1	6661	g19394	i0	83.6	0.969026548672566	73	12	96.9	0	226	8	170	242	KAK2705440.1 hypothetical protein QYM36_015728 [Artemia franciscana]	diamond	219	113	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);;