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

6 rows where analysis = "diamond", bioproject = "PRJNA627467" 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
27270186	27270186	PRJNA627467_P_NODE_14803_length_171_cov_3.631148_g14734_i0	PRJNA627467	14803	171	3.631148	6.20926308	Melanaphis sacchari	742174	Arthropoda	Arthropoda	91.7	8.15e-20	NR	XP_025196837.1	742174	g14734	i0	80	0.964912280701754	55	9	96.5	1	166	2	2252	2304	XP_025196837.1 uncharacterized protein LOC112595752 [Melanaphis sacchari]	diamond	165	91.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Melanaphis	Melanaphis sacchari
27491467	27491467	PRJNA627467_P_NODE_18023_length_163_cov_3.456140_g17954_i0	PRJNA627467	18023	163	3.45614	5.6335082	Polypedilum vanderplanki	319348	Arthropoda	Arthropoda	60.5	7.08e-9	NR	KAG5685032.1	319348	g17954	i0	58	1.84049079754601	50	21	92	0	154	5	636	685	KAG5685032.1 hypothetical protein PVAND_014235 [Polypedilum vanderplanki]	diamond	300	60.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Polypedilum	Polypedilum vanderplanki
29796115	29796115	PRJNA627467_P_NODE_14571_length_172_cov_2.243902_g14502_i0	PRJNA627467	14571	172	2.243902	3.85951144	Oppia nitens	1686743	Arthropoda	Arthropoda	119	2.15e-29	NR	XP_054153896.1	1686743	g14502	i0	98.2	1.95348837209302	56	1	97.7	0	168	1	573	628	XP_054153896.1 dynamin-like isoform X2 [Oppia nitens]	diamond	336	119	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Oppiidae	Oppia	Oppia nitens
30775829	30775829	PRJNA627467_P_NODE_2394_length_316_cov_2.670412_g2326_i0	PRJNA627467	2394	316	2.670412	8.43850192	Tyrophagus putrescentiae	59818	Arthropoda	Arthropoda	63.2	4.16e-9	NR	KAH9406201.1	59818	g2326	i0	84.8	0.313291139240506	33	5	31.3	0	2	100	87	119	KAH9406201.1 hypothetical protein TYRP_013806, partial [Tyrophagus putrescentiae]	diamond	99	63.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Acaridae	Tyrophagus	Tyrophagus putrescentiae
31294029	31294029	PRJNA627467_P_NODE_15175_length_170_cov_2.479339_g15106_i0	PRJNA627467	15175	170	2.479339	4.2148763	Aphididae	27482	Arthropoda	Arthropoda	55.5	4.55e-7	NR	XP_029340929.1	7029	g15106	i0	89.3	1.97647058823529	28	3	49.4	0	32	115	1997	2024	XP_029340929.1 protein unc-80 homolog [Acyrthosiphon pisum]	diamond	336	55.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Aphididae	Acyrthosiphon	Acyrthosiphon pisum
31977155	31977155	PRJNA627467_P_NODE_3698_length_316_cov_1.962547_g3630_i0	PRJNA627467	3698	316	1.962547	6.20164852	Tyrophagus putrescentiae	59818	Arthropoda	Arthropoda	60.5	4.92e-8	NR	KAH9405104.1	59818	g3630	i0	96.9	0.30379746835443	32	1	30.4	0	3	98	115	146	KAH9405104.1 hypothetical protein TYRP_000941 [Tyrophagus putrescentiae]	diamond	96	60.5	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Sarcoptiformes	Acaridae	Tyrophagus	Tyrophagus putrescentiae

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