metadata: contig_metadata: 5 rows where bioproject = "PRJNA773247", tax_clade = "core chlorophytes" and tax

5 rows where bioproject = "PRJNA773247", tax_clade = "core chlorophytes" and tax_phylum = "Chlorophyta"

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
7127465	7127465	PRJNA773247_P_NODE_15186_length_381_cov_3.288961_g15102_i0	PRJNA773247	15186	381	3.288961	12.53094141	Eukaryota	2759	Plants	Plants	167	1.08e-46	NR	PNG99282.1	47790	g15102	i0	68.7	13.6062992125984	115	36	90.6	0	8	352	57	171	PNG99282.1 Midasin, partial [Tetrabaena socialis]	diamond	5184	167	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Tetrabaenaceae	Tetrabaena	Tetrabaena socialis
21151612	21151612	PRJNA773247_P_NODE_36997_length_213_cov_4.685714_g36913_i0	PRJNA773247	36997	213	4.685714	9.98057082	Ulothrix zonata	43941	Plants	Plants	385	1.63e-102	NTclustered	gi\|530445638\|emb\|HE860517.1\|	43941	g36913	i0	100	95.3990610328639	208	0	98	0	5	212	131	338	Ulothrix zonata genomic DNA containing ITS2, isolate N94, specimen voucher WELT:A032275	blastn	20320	385	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulotrichales	Ulotrichaceae	Ulothrix	Ulothrix zonata
30568109	30568109	PRJNA773247_P_NODE_7753_length_590_cov_2.765957_g7670_i0	PRJNA773247	7753	590	2.7659570000000002	16.3191463	Trebouxia	13786	Plants	Plants	70.5	2.61e-10	NR	KAA6428502.1	2608996	g7670	i0	62.1	2.03389830508475	58	14	25.4	1	581	432	480	537	KAA6428502.1 MAG: CMGC SRPK kinase [Trebouxia sp. A1-2]	diamond	1200	70.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. A1-2
30621934	30621934	PRJNA773247_P_NODE_36793_length_221_cov_4.243243_g36709_i0	PRJNA773247	36793	221	4.243243	9.37756703	Monoraphidium minutum	39955	Plants	Plants	82.8	2.17e-16	NR	KAI8472156.1	39955	g36709	i0	92	0.678733031674208	50	4	67.9	0	72	221	406	455	KAI8472156.1 MAG: Sodium/hydrogen exchanger family-domain-containing protein [Monoraphidium minutum]	diamond	150	82.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium minutum
31485154	31485154	PRJNA773247_P_NODE_14676_length_389_cov_4.136076_g14592_i0	PRJNA773247	14676	389	4.136076	16.08933564	Eukaryota	2759	Plants	Plants	170	5.08e-46	NR	KAL4853875.1	3077	g14592	i0	66.4	22.7043701799486	128	43	98.7	0	388	5	681	808	KAL4853875.1 Prolycopene isomerase [Chlorella vulgaris]	diamond	8832	171	0.994152046783626	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris

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