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

5 rows where analysis = "diamond", bioproject = "PRJNA484127" 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
26601155	26601155	PRJNA484127_P_NODE_10881_length_370_cov_2.572391_g10732_i0	PRJNA484127	10881	370	2.572391	9.5178467	Helicosporidium sp. ATCC 5	1907511	Plants	Plants	151	8.59e-44	NR	KDD76381.1	1291522	g10732	i0	65.4	1.71081081081081	104	36	84.3	0	2	313	74	177	KDD76381.1 hypothetical protein H632_c248p2 [Helicosporidium sp. ATCC 50920]	diamond	633	151	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Helicosporidium	Helicosporidium sp. ATCC 50920
30408646	30408646	PRJNA484127_P_NODE_40473_length_227_cov_2.025974_g40324_i0	PRJNA484127	40473	227	2.025974	4.59896098	Eukaryota	2759	Plants	Plants	70.5	4.74e-13	NR	KAK9804915.1	41462	g40324	i0	64.2	2.8942731277533	53	19	70	0	2	160	101	153	KAK9804915.1 hypothetical protein WJX72_011827 [[Myrmecia] bisecta]	diamond	657	70.9	0.994358251057828	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
30914027	30914027	PRJNA484127_P_NODE_30434_length_252_cov_0.871508_g30285_i0	PRJNA484127	30434	252	0.871508	2.19620016	root	1	Root_unresolved	Root_unresolved	50.4	7.67e-5	NR	KAF5830871.1	3046	g30285	i0	38.6	10.4761904761905	70	41	83.3	1	243	34	92	159	KAF5830871.1 hypothetical protein DUNSADRAFT_13931 [Dunaliella salina]	diamond	2640	50.8	0.992125984251969	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Dunaliellaceae	Dunaliella	Dunaliella salina
31261482	31261482	PRJNA484127_P_NODE_25795_length_267_cov_1.567010_g25646_i0	PRJNA484127	25795	267	1.56701	4.1839167	Chlorellaceae	35461	Plants	Plants	91.7	3.09e-19	NR	KAK2078008.1	3111	g25646	i0	54	4.8876404494382	87	37	97.8	1	267	7	123	206	KAK2078008.1 T-complex protein 1 subunit eta [Prototheca wickerhamii]	diamond	1305	92	0.996739130434783	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Prototheca	Prototheca wickerhamii
31276847	31276847	PRJNA484127_P_NODE_21795_length_285_cov_1.669811_g21646_i0	PRJNA484127	21795	285	1.669811	4.75896135	Auxenochlorella protothecoides	3075	Plants	Plants	45.1	0.00938	NR	XP_011400040.1	3075	g21646	i0	45.3	1.11578947368421	53	28	55.8	1	119	277	16	67	XP_011400040.1 Phospholipase B-like 1 [Auxenochlorella protothecoides]	diamond	318	45.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides

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