metadata: contig_metadata: 5 rows where bioproject = "PRJDB4941", tax_kingdom = "Viridiplantae" and tax

5 rows where bioproject = "PRJDB4941", tax_kingdom = "Viridiplantae" 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
7662889	7662889	PRJDB4941_P_NODE_39927_length_163_cov_0.912281_g39159_i0	PRJDB4941	39927	163	0.912281	1.48701803	Chlamydomonas reinhardtii	3055	Plants	Plants	169	1.29e-37	NTclustered	gi\|735958\|emb\|X78851.1\|	3055	g39159	i0	85.276	2.98773006134969	163	24	100	0	1	163	556	394	C.reinhardtii (137 C) mRNA for ferredoxin NADP reductase	blastn	487	169	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
28264078	28264078	PRJDB4941_P_NODE_12226_length_315_cov_1.048872_g11458_i0	PRJDB4941	12226	315	1.048872	3.3039468	Coccomyxa subellipsoidea C-169	574566	Plants	Plants	54.7	5.4e-6	NR	XP_005645417.1	574566	g11458	i0	43.6	2.0952380952381	55	30	52.4	1	5	169	354	407	XP_005645417.1 hypothetical protein COCSUDRAFT_43757 [Coccomyxa subellipsoidea C-169]	diamond	660	54.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
30348980	30348980	PRJDB4941_P_NODE_11152_length_333_cov_2.302817_g10384_i0	PRJDB4941	11152	333	2.302817	7.66838061	Coccomyxa elongata	1965095	Plants	Plants	47	0.00339	NR	CAL8466684.1	1965095	g10384	i0	46	0.567567567567568	63	33	55.9	1	191	6	748	810	CAL8466684.1 g6220 [Coccomyxa elongata]	diamond	189	47	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa elongata
30349008	30349008	PRJDB4941_P_NODE_41252_length_162_cov_0.867257_g40484_i0	PRJDB4941	41252	162	0.867257	1.40495634	Ostreococcus lucimarinus CCE99	242159	Plants	Plants	64.7	7.27e-11	NR	XP_001420044.1	436017	g40484	i0	64.4	3.22222222222222	45	16	83.3	0	137	3	34	78	XP_001420044.1 predicted protein [Ostreococcus lucimarinus CCE9901]	diamond	522	64.7	1	Eukaryota		Viridiplantae	Chlorophyta	Mamiellophyceae	Mamiellales	Bathycoccaceae	Ostreococcus	Ostreococcus sp. 'lucimarinus'
32687695	32687695	PRJDB4941_P_NODE_21800_length_217_cov_2.238095_g21032_i0	PRJDB4941	21800	217	2.238095	4.85666615	[Myrmecia] bisecta	41462	Plants	Plants	66.6	5.06e-11	NR	KAK9810105.1	41462	g21032	i0	58.6	3.06912442396313	58	14	80.2	1	175	2	20	67	KAK9810105.1 hypothetical protein WJX72_004962 [[Myrmecia] bisecta]	diamond	666	66.6	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);;