metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA758087" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA758087" 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
27189040	27189040	PRJNA758087_P_NODE_43742_length_241_cov_0.916667_g42422_i0	PRJNA758087	43742	241	0.916667	2.20916747	Tetranychidae	32262	Arthropoda	Arthropoda	53.1	7.79e-6	NR	XP_015791180.1	32264	g42422	i0	100	0.970954356846473	26	0	32.4	0	239	162	272	297	XP_015791180.1 cadherin-23 [Tetranychus urticae]	diamond	234	53.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Tetranychus	Tetranychus urticae
28695360	28695360	PRJNA758087_P_NODE_42127_length_249_cov_0.875000_g40807_i0	PRJNA758087	42127	249	0.875	2.17875	Panonychus citri	50023	Arthropoda	Arthropoda	45.8	0.00328	NR	XP_053213919.1	50023	g40807	i0	51	0.590361445783133	49	17	57.8	2	87	230	385	427	XP_053213919.1 probable serine/threonine-protein kinase DDB_G0282963 isoform X2 [Panonychus citri]	diamond	147	45.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Panonychus	Panonychus citri
29642066	29642066	PRJNA758087_P_NODE_35930_length_323_cov_2.556000_g34610_i0	PRJNA758087	35930	323	2.556	8.25588	Bradysia coprophila	38358	Arthropoda	Arthropoda	69.7	3.29e-11	NR	XP_037044623.1	38358	g34610	i0	94.1	0.631578947368421	34	2	31.6	0	23	124	896	929	XP_037044623.1 prominin-like protein isoform X6 [Bradysia coprophila]	diamond	204	69.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Sciaridae	Bradysia	Bradysia coprophila
30621546	30621546	PRJNA758087_P_NODE_13133_length_842_cov_54.745124_g11947_i0	PRJNA758087	13133	842	54.745124	460.95394408	Penaeus vannamei	6689	Arthropoda	Arthropoda	48.9	0.0144	NR	ROT71108.1	6689	g11947	i0	41.7	0.580760095011877	163	58	50.2	10	61	483	94	241	ROT71108.1 hypothetical protein C7M84_010575 [Penaeus vannamei]	diamond	489	48.9	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Penaeidae	Penaeus	Penaeus vannamei
31633141	31633141	PRJNA758087_P_NODE_22816_length_549_cov_4.218487_g21501_i0	PRJNA758087	22816	549	4.218487	23.15949363	Clunio marinus	568069	Arthropoda	Arthropoda	250	1.23e-81	NR	CRL05315.1	568069	g21501	i0	77.4	0.868852459016393	159	36	86.9	0	6	482	47	205	CRL05315.1 CLUMA_CG018253, isoform A, partial [Clunio marinus]	diamond	477	250	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Clunio	Clunio marinus
31832599	31832599	PRJNA758087_P_NODE_31057_length_394_cov_4.971963_g29737_i0	PRJNA758087	31057	394	4.971963	19.58953422	Hymenoptera	7399	Arthropoda	Arthropoda	104	5.79e-23	NR	KAL3402717.1	54128	g29737	i0	55.2	13.8883248730964	87	39	66.2	0	303	43	228	314	KAL3402717.1 hypothetical protein TKK_004638 [Trichogramma kaykai]	diamond	5472	104	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Trichogrammatidae	Trichogramma	Trichogramma kaykai

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