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

6 rows where analysis = "diamond", bioproject = "PRJNA785164" 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
28095951	28095951	PRJNA785164_P_NODE_50965_length_251_cov_1.426966_g50500_i0	PRJNA785164	50965	251	1.426966	3.58168466	Trinorchestia longiramus	1923959	Arthropoda	Arthropoda	51.6	3.08e-5	NR	KAF2353244.1	1923959	g50500	i0	37.5	4.49402390438247	64	36	76.5	1	250	59	528	587	KAF2353244.1 Transposase type 1 [Trinorchestia longiramus]	diamond	1128	51.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Malacostraca	Amphipoda	Talitridae	Trinorchestia	Trinorchestia longiramus
28926062	28926062	PRJNA785164_P_NODE_56768_length_246_cov_0.890173_g56303_i0	PRJNA785164	56768	246	0.890173	2.18982558	Miridae	30083	Arthropoda	Arthropoda	152	1.09e-40	NR	KAF6204472.1	248454	g56303	i0	76.5	1.97560975609756	81	19	98.8	0	245	3	1097	1177	KAF6204472.1 hypothetical protein GE061_002813 [Apolygus lucorum]	diamond	486	152	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Miridae	Apolygus	Apolygus lucorum
28980210	28980210	PRJNA785164_P_NODE_58248_length_244_cov_1.497076_g57783_i0	PRJNA785164	58248	244	1.497076	3.65286544	Homalodisca vitripennis	197043	Arthropoda	Arthropoda	41.6	0.044	NR	KAG8265275.1	197043	g57783	i0	39.1	0.848360655737705	69	36	77.5	2	31	219	51	119	KAG8265275.1 hypothetical protein J6590_098403 [Homalodisca vitripennis]	diamond	207	41.6	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hemiptera	Cicadellidae	Homalodisca	Homalodisca vitripennis
30653839	30653839	PRJNA785164_P_NODE_55993_length_246_cov_2.606936_g55528_i0	PRJNA785164	55993	246	2.606936	6.41306256	Eumeta japonica	151549	Arthropoda	Arthropoda	41.2	0.034	NR	GBP06203.1	151549	g55528	i0	40	0.609756097560976	50	25	54.9	2	163	29	23	72	GBP06203.1 hypothetical protein EVAR_3563_1 [Eumeta japonica]	diamond	150	41.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Lepidoptera	Psychidae	Eumeta	Eumeta japonica
31159135	31159135	PRJNA785164_P_NODE_30635_length_330_cov_1.844358_g30170_i0	PRJNA785164	30635	330	1.844358	6.0863814	Lasioglossum lativentre	88531	Arthropoda	Arthropoda	51.2	9.84e-5	NR	ALO64872.1	88531	g30170	i0	37	0.736363636363636	81	51	73.6	0	3	245	168	248	ALO64872.1 cytochrome b [Lasioglossum lativentre]	diamond	243	51.2	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Halictidae	Lasioglossum	Lasioglossum lativentre
32866267	32866267	PRJNA785164_P_NODE_40340_length_284_cov_1.094787_g39875_i0	PRJNA785164	40340	284	1.094787	3.10919508	Folsomia candida	158441	Arthropoda	Arthropoda	125	3.8699999999999997e-31	NR	OXA59506.1	158441	g39875	i0	64.5	2.94718309859155	93	33	98.2	0	281	3	352	444	OXA59506.1 Carbonyl reductase [NADPH] 1 [Folsomia candida]	diamond	837	125	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Collembola	Entomobryomorpha	Isotomidae	Folsomia	Folsomia candida

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