metadata: contig_metadata: 5 rows where bioproject = "PRJNA898105" and tax

5 rows where bioproject = "PRJNA898105" 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	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
1244206	1244206	PRJNA898105_P_NODE_4161_length_286_cov_1.671362_g3961_i0	PRJNA898105	4161	286	1.671362	4.78009532	Trebouxia	13786	Plants	Plants	510	3.63e-140	NTclustered	gi\|21631\|emb\|Z21553.1\|	13787	g3961	i0	98.947	99.6503496503497	285	3	99	1	285	705	989	T.asymmetrica gene encoding 18S ribosomal RNA	blastn	28500	510	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia asymmetrica
17452039	17452039	PRJNA898105_P_NODE_4594_length_279_cov_1.975728_g4394_i0	PRJNA898105	4594	279	1.975728	5.51228112	Stichococcus bacillaris	37433	Plants	Plants	318	2.2899999999999995e-82	NTclustered	gi\|371782093\|emb\|HE610125.1\|	37433	g4394	i0	96.842	14.9498207885305	190	6	68	1	190	6993	7182	Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2	blastn	4171	318	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Prasiolales	Stichococcaceae	Stichococcus	Stichococcus bacillaris
20000467	20000467	PRJNA898105_P_NODE_7076_length_247_cov_0.885057_g6876_i0	PRJNA898105	7076	247	0.885057	2.18609079	Myrmecia israelensis	3171	Plants	Plants	429	8.83e-116	NTclustered	gi\|2724824566\|gb\|PP746563.1\|	3171	g6876	i0	98.755	58.5910931174089	241	3	98	1	241	5778	6018	Myrmecia israelensis culture UTEX:1181 mitochondrion, complete genome	blastn	14472	429	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	Myrmecia israelensis
28705726	28705726	PRJNA898105_P_NODE_3947_length_290_cov_1.188940_g3747_i0	PRJNA898105	3947	290	1.18894	3.447926	Chlorophyta	3041	Plants	Plants	149	2.54e-40	NR	GBF95994.1	307507	g3747	i0	77.8	19.6655172413793	90	20	93.1	21	290	218	307	GBF95994.1 glycylpeptide N-tetradecanoyltransferase-like [Raphidocelis subcapitata]	diamond	5703	149	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Raphidocelis	Raphidocelis subcapitata
29613233	29613233	PRJNA898105_P_NODE_6950_length_247_cov_1.385057_g6750_i0	PRJNA898105	6950	247	1.385057	3.42109079	Chlorella ohadii	2649997	Plants	Plants	49.3	1.96e-4	NR	KAI7846321.1	2649997	g6750	i0	51.6	0.753036437246964	31	15	37.7	1	93	671	701	KAI7846321.1 hypothetical protein COHA_000158 [Chlorella ohadii]	diamond	186	49.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella ohadii

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