metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA380416" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA380416" 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
13155746	13155746	PRJNA380416_P_NODE_12311_length_165_cov_0.879310_g12164_i0	PRJNA380416	12311	165	0.87931	1.4508615	Panonychus citri	50023	Arthropoda	Arthropoda	93.2	2.24e-20	NR	XP_053209079.1	50023	g12164	i0	76.4	1	55	13	100	0	165	1	959	1013	XP_053209079.1 LOW QUALITY PROTEIN: DNA mismatch repair protein Msh6-like, partial [Panonychus citri]	diamond	165	93.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Panonychus	Panonychus citri
28338357	28338357	PRJNA380416_P_NODE_11026_length_169_cov_0.966667_g10879_i0	PRJNA380416	11026	169	0.966667	1.63366723	Petrolisthes manimaculis	1843537	Arthropoda	Arthropoda	40.4	0.0417	NR	KAK4304497.1	1843537	g10879	i0	56.5	0.408284023668639	23	10	40.8	0	37	105	38	60	KAK4304497.1 hypothetical protein Pmani_023549 [Petrolisthes manimaculis]	diamond	69	40.4	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Porcellanidae	Petrolisthes	Petrolisthes manimaculis
28639684	28639684	PRJNA380416_P_NODE_11287_length_167_cov_0.864407_g11140_i0	PRJNA380416	11287	167	0.864407	1.44355969	Hemiptera	7524	Arthropoda	Arthropoda	85.9	6.55e-19	NR	XP_046686827.1	197043	g11140	i0	71.4	11.1197604790419	56	15	98.8	1	3	167	151	206	XP_046686827.1 peroxiredoxin-2-like, partial [Homalodisca vitripennis]	diamond	1857	85.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Cicadellidae	Homalodisca	Homalodisca vitripennis
29822054	29822054	PRJNA380416_P_NODE_3451_length_324_cov_1.654545_g3304_i0	PRJNA380416	3451	324	1.654545	5.3607258	Bemisia tabaci	7038	Arthropoda	Arthropoda	87	7.59e-19	NR	XP_018910361.1	7038	g3304	i0	43.9	8.49074074074074	98	55	90.7	0	314	21	40	137	XP_018910361.1 PREDICTED: 60S ribosomal protein L18a [Bemisia tabaci]	diamond	2751	87	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aleyrodidae	Bemisia	Bemisia tabaci
30186697	30186697	PRJNA380416_P_NODE_7392_length_211_cov_1.067901_g7245_i0	PRJNA380416	7392	211	1.067901	2.25327111	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	99.8	2.59e-25	NR	XP_027194304.1	6956	g7245	i0	75.4	1.84834123222749	65	16	92.4	0	209	15	16	80	XP_027194304.1 60S ribosomal protein L44 [Dermatophagoides pteronyssinus]	diamond	390	100	0.998	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Pyroglyphidae	Dermatophagoides	Dermatophagoides pteronyssinus
30517362	30517362	PRJNA380416_P_NODE_13933_length_161_cov_0.910714_g13786_i0	PRJNA380416	13933	161	0.910714	1.46624954	Palaemon carinicauda	392227	Arthropoda	Arthropoda	46.6	4.57e-4	NR	XP_068223990.1	392227	g13786	i0	48.2	1.84472049689441	56	23	95	2	5	157	133	187	XP_068223990.1 ran-specific GTPase-activating protein-like isoform X2 [Palaemon carinicauda]	diamond	297	46.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Palaemonidae	Palaemon	Palaemon carinicauda
30864830	30864830	PRJNA380416_P_NODE_11814_length_166_cov_0.871795_g11667_i0	PRJNA380416	11814	166	0.871795	1.4471797	Frankliniella occidentalis	133901	Arthropoda	Arthropoda	75.5	3.62e-14	NR	KAE8739074.1	133901	g11667	i0	77.8	0.975903614457831	54	12	97.6	0	3	164	801	854	KAE8739074.1 hypothetical protein FOCC_FOCC015430 [Frankliniella occidentalis]	diamond	162	75.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Thysanoptera	Thripidae	Frankliniella	Frankliniella occidentalis
30896669	30896669	PRJNA380416_P_NODE_12994_length_163_cov_0.894737_g12847_i0	PRJNA380416	12994	163	0.894737	1.45842131	Acanthoscelides obtectus	200917	Arthropoda	Arthropoda	63.9	2.76e-10	NR	CAH2021287.1	200917	g12847	i0	59.6	3.4601226993865	47	19	86.5	0	3	143	59	105	CAH2021287.1 unnamed protein product [Acanthoscelides obtectus]	diamond	564	63.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Coleoptera	Chrysomelidae	Acanthoscelides	Acanthoscelides obtectus
31212013	31212013	PRJNA380416_P_NODE_4855_length_265_cov_0.944444_g4708_i0	PRJNA380416	4855	265	0.944444	2.5027766	Lepeophtheirus salmonis	72036	Arthropoda	Arthropoda	84	8.2e-18	NR	ADD38186.1	72036	g4708	i0	48.7	0.883018867924528	78	40	88.3	0	245	12	59	136	ADD38186.1 60S ribosomal protein L9 [Lepeophtheirus salmonis]	diamond	234	84	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Siphonostomatoida	Caligidae	Lepeophtheirus	Lepeophtheirus salmonis

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