metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA415636" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA415636" 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
20209474	20209474	PRJNA415636_S_NODE_6136_length_210_cov_1.184049_g6089_i0	PRJNA415636	6136	210	1.184049	2.4865029	Diploptera punctata	6984	Arthropoda	Arthropoda	110	3.32e-29	NR	KAJ9590993.1	6984	g6089	i0	65.7	3	70	24	100	0	1	210	50	119	KAJ9590993.1 hypothetical protein L9F63_027798, partial [Diploptera punctata]	diamond	630	110	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Blattodea	Blaberidae	Diploptera	Diploptera punctata
27471543	27471543	PRJNA415636_S_NODE_5783_length_215_cov_0.910714_g5736_i0	PRJNA415636	5783	215	0.910714	1.9580351	Metazoa	33208	Arthropoda	Arthropoda	93.2	4.3e-20	NR	XP_059087636.1	6832	g5736	i0	60.6	18.446511627907	71	28	99.1	0	3	215	485	555	XP_059087636.1 adenylyl cyclase-associated protein 1-like isoform X4 [Tigriopus californicus]	diamond	3966	93.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Hexanauplia	Harpacticoida	Harpacticidae	Tigriopus	Tigriopus californicus
27913265	27913265	PRJNA415636_S_NODE_4845_length_231_cov_2.070652_g4798_i0	PRJNA415636	4845	231	2.070652	4.78320612	Trichogramma	7490	Arthropoda	Arthropoda	105	1.24e-24	NR	XP_023315593.1	7493	g4798	i0	67.5	5.93506493506494	77	24	98.7	1	1	228	32	108	XP_023315593.1 peptidyl-prolyl cis-trans isomerase FKBP4 isoform X2 [Trichogramma pretiosum]	diamond	1371	105	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Trichogrammatidae	Trichogramma	Trichogramma pretiosum
28465286	28465286	PRJNA415636_S_NODE_2226_length_311_cov_2.625000_g2179_i0	PRJNA415636	2226	311	2.625	8.16375	Leptotrombidium deliense	299467	Arthropoda	Arthropoda	84	8.42e-18	NR	RWS28058.1	299467	g2179	i0	60	2.44051446945338	85	30	80.1	3	1	249	83	165	RWS28058.1 60S ribosomal protein L21-like protein [Leptotrombidium deliense]	diamond	759	84	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Trombiculidae	Leptotrombidium	Leptotrombidium deliense
29839431	29839431	PRJNA415636_S_NODE_3791_length_254_cov_1.676329_g3744_i0	PRJNA415636	3791	254	1.676329	4.25787566	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	124	2.08e-34	NR	XP_055937680.1	94029	g3744	i0	73.5	13.6535433070866	83	22	98	0	3	251	31	113	XP_055937680.1 60S ribosomal protein L31 [Argiope bruennichi]	diamond	3468	125	0.992	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Araneidae	Argiope	Argiope bruennichi
30597580	30597580	PRJNA415636_S_NODE_1093_length_397_cov_34.262857_g1046_i0	PRJNA415636	1093	397	34.262857	136.02354229	root	1	Root_unresolved	Root_unresolved	53.1	4.85e-5	NR	GBN61280.1	182803	g1046	i0	50.9	3.68765743073048	53	26	40.1	0	122	280	1136	1188	GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus]	diamond	1464	53.1	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Araneae	Araneidae	Araneus	Araneus ventricosus
31672388	31672388	PRJNA415636_S_NODE_4277_length_242_cov_1.630769_g4230_i0	PRJNA415636	4277	242	1.630769	3.94646098	Metazoa	33208	Arthropoda	Arthropoda	127	2.02e-34	NR	NP_001040464.1	7091	g4230	i0	73.8	39.9421487603306	80	21	99.2	0	3	242	124	203	NP_001040464.1 thioredoxin peroxidase [Bombyx mori]	diamond	9666	128	0.9921875	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Bombycidae	Bombyx	Bombyx mori

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