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

6 rows where analysis = "diamond", bioproject = "PRJNA512103" and tax_kingdom = "Viridiplantae"

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
6864256	6864256	PRJNA512103_P_NODE_7186_length_496_cov_2.210291_g6779_i0	PRJNA512103	7186	496	2.210291	10.96304336	root	1	Root_unresolved	Root_unresolved	233	1.01e-70	NR	KAI8467676.1	39955	g6779	i0	74.5	52.9899193548387	153	39	92.5	0	9	467	354	506	KAI8467676.1 MAG: ATP synthase subunit beta, mitochondrial [Monoraphidium minutum]	diamond	26283	234	0.995726495726496	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium minutum
28213909	28213909	PRJNA512103_P_NODE_19566_length_218_cov_0.875740_g19154_i0	PRJNA512103	19566	218	0.87574	1.9091132	Actinidia rufa	165716	Plants	Plants	43.9	0.0106	NR	GFZ12955.1	165716	g19154	i0	37.2	0.591743119266055	43	27	59.2	0	17	145	99	141	GFZ12955.1 formin homology5 [Actinidia rufa]	diamond	129	43.9	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Actinidiaceae	Actinidia	Actinidia rufa
28498487	28498487	PRJNA512103_P_NODE_30767_length_169_cov_0.866667_g30355_i0	PRJNA512103	30767	169	0.866667	1.46466723	Triticum aestivum	4565	Plants	Plants	42	0.0254	NR	SPT19547.1	4565	g30355	i0	40.5	0.656804733727811	37	22	65.7	0	18	128	837	873	SPT19547.1 unnamed protein product [Triticum aestivum]	diamond	111	42	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Triticum	Triticum aestivum
30803837	30803837	PRJNA512103_P_NODE_11194_length_342_cov_1.191126_g10782_i0	PRJNA512103	11194	342	1.191126	4.07365092	Humulus lupulus	3486	Plants	Plants	74.3	8.29e-13	NR	XP_062118465.1	3486	g10782	i0	35.5	0.815789473684211	93	51	81.6	1	62	340	4	87	XP_062118465.1 uncharacterized mitochondrial protein AtMg00810-like [Humulus lupulus]	diamond	279	74.3	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Cannabaceae	Humulus	Humulus lupulus
30850808	30850808	PRJNA512103_P_NODE_27354_length_179_cov_1.446154_g26942_i0	PRJNA512103	27354	179	1.446154	2.58861566	Eukaryota	2759	Plants	Plants	54.3	1.52e-7	NR	KAK9812718.1	41462	g26942	i0	54.3	8.11173184357542	46	21	77.1	0	11	148	62	107	KAK9812718.1 hypothetical protein WJX72_002574 [[Myrmecia] bisecta]	diamond	1452	54.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
32005454	32005454	PRJNA512103_P_NODE_23378_length_195_cov_1.815068_g22966_i0	PRJNA512103	23378	195	1.815068	3.5393826	Prunus armeniaca	36596	Plants	Plants	42	0.038	NR	CAL2237091.1	36596	g22966	i0	41.9	0.953846153846154	62	36	95.4	0	192	7	361	422	CAL2237091.1 unnamed protein product [Prunus armeniaca]	diamond	186	42	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Rosales	Rosaceae	Prunus	Prunus armeniaca

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