metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJEB11523" and tax

5 rows where analysis = "diamond", bioproject = "PRJEB11523" 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
26994730	26994730	PRJEB11523_P_NODE_3082_length_286_cov_2.000000_g3004_i0	PRJEB11523	3082	286	2	5.72	root	1	Root_unresolved	Root_unresolved	57	5.17e-7	NR	XP_050460981.1	1086592	g3004	i0	68.6	3.88111888111888	35	11	36.7	0	180	284	41	75	XP_050460981.1 dehydrogenase/reductase SDR family member 7 isoform X2 [Cataglyphis hispanica]	diamond	1110	57.4	0.993031358885017	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Formicidae	Cataglyphis	Cataglyphis hispanica
27728132	27728132	PRJEB11523_P_NODE_2944_length_295_cov_1.796748_g2866_i0	PRJEB11523	2944	295	1.796748	5.3004066	Idotea baltica	82763	Arthropoda	Arthropoda	98.2	3.64e-24	NR	MCL4162242.1	82763	g2866	i0	86.8	0.538983050847458	53	7	53.9	0	16	174	24	76	MCL4162242.1 hypothetical protein [Idotea baltica]	diamond	159	98.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Isopoda	Idoteidae	Idotea	Idotea baltica
28769643	28769643	PRJEB11523_P_NODE_3067_length_287_cov_1.789916_g2989_i0	PRJEB11523	3067	287	1.789916	5.13705892	Penaeus vannamei	6689	Arthropoda	Arthropoda	44.7	0.0125	NR	ROT79663.1	6689	g2989	i0	55.6	0.752613240418119	72	24	75.3	3	61	276	81	144	ROT79663.1 hypothetical protein C7M84_001611 [Penaeus vannamei]	diamond	216	44.7	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Decapoda	Penaeidae	Penaeus	Penaeus vannamei
29205838	29205838	PRJEB11523_P_NODE_389_length_968_cov_32.267682_g333_i0	PRJEB11523	389	968	32.267682	312.35116176	Arachnida	6854	Arthropoda	Arthropoda	54.7	2.69e-4	NR	XP_053206642.1	50023	g333	i0	51.4	0.963842975206612	35	17	10.8	0	265	369	110	144	XP_053206642.1 LOW QUALITY PROTEIN: uncharacterized protein LOC128390894 [Panonychus citri]	diamond	933	55.1	0.992740471869329	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Panonychus	Panonychus citri
31543675	31543675	PRJEB11523_P_NODE_5016_length_209_cov_6.037500_g4938_i0	PRJEB11523	5016	209	6.0375	12.618375	Metazoa	33208	Arthropoda	Arthropoda	96.3	3.13e-21	NR	XP_053214876.1	50023	g4938	i0	85.5	15.1291866028708	62	9	89	0	208	23	408	469	XP_053214876.1 excitatory amino acid transporter-like isoform X2 [Panonychus citri]	diamond	3162	97.1	0.991761071060762	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Arachnida	Trombidiformes	Tetranychidae	Panonychus	Panonychus citri

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