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

6 rows where analysis = "diamond", bioproject = "PRJEB83711" and tax_clade = "core chlorophytes"

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
10347225	10347225	PRJEB83711_P_NODE_51429_length_264_cov_1.518325_g51163_i0	PRJEB83711	51429	264	1.518325	4.008378	Chlorella	3071	Plants	Plants	145	2.759999999999999e-38	NR	PRW45372.1	3076	g51163	i0	92	1.97727272727273	87	7	98.9	0	3	263	16	102	PRW45372.1 hypothetical protein C2E21_5977 [Chlorella sorokiniana]	diamond	522	145	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
24370522	24370522	PRJEB83711_P_NODE_73480_length_245_cov_0.906977_g73214_i0	PRJEB83711	73480	245	0.906977	2.22209365	Chlorella ohadii	2649997	Plants	Plants	157	7.75e-45	NR	KAI7837036.1	2649997	g73214	i0	90.4	2.03265306122449	83	6	99.2	1	244	2	43	125	KAI7837036.1 hypothetical protein COHA_009113 [Chlorella ohadii]	diamond	498	157	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella ohadii
28865966	28865966	PRJEB83711_P_NODE_56868_length_254_cov_1.337017_g56602_i0	PRJEB83711	56868	254	1.337017	3.39602318	Coccomyxa viridis	1274662	Plants	Plants	125	1.6899999999999998e-31	NR	CAK0785678.1	1274662	g56602	i0	71.1	1.90157480314961	83	23	98	1	1	249	236	317	CAK0785678.1 hypothetical protein CVIRNUC_008889 [Coccomyxa viridis]	diamond	483	125	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa viridis
31417427	31417427	PRJEB83711_P_NODE_64956_length_249_cov_0.886364_g64690_i0	PRJEB83711	64956	249	0.886364	2.20704636	Chlorellaceae	35461	Plants	Plants	98.2	8.48e-22	NR	PRW18306.1	3076	g64690	i0	69	5.95180722891566	71	16	84.3	3	248	39	285	350	PRW18306.1 cysteine ase RD21a-like [Chlorella sorokiniana]	diamond	1482	98.6	0.995943204868154	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
31962481	31962481	PRJEB83711_P_NODE_58138_length_253_cov_0.866667_g57872_i0	PRJEB83711	58138	253	0.866667	2.19266751	[Myrmecia] bisecta	41462	Plants	Plants	90.9	1.41e-19	NR	KAK9809982.1	41462	g57872	i0	60.5	0.960474308300395	81	30	93.7	1	2	238	216	296	KAK9809982.1 hypothetical protein WJX72_002927 [[Myrmecia] bisecta]	diamond	243	90.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
32532272	32532272	PRJEB83711_P_NODE_44639_length_278_cov_1.482927_g44373_i0	PRJEB83711	44639	278	1.482927	4.12253706	[Myrmecia] bisecta	41462	Plants	Plants	55.5	2e-6	NR	KAK9803914.1	41462	g44373	i0	46.4	0.744604316546763	69	37	74.5	0	223	17	633	701	KAK9803914.1 hypothetical protein WJX72_004698 [[Myrmecia] bisecta]	diamond	207	55.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta

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