metadata: contig_metadata: 8 rows where bioproject = "PRJNA600413" and tax

8 rows where bioproject = "PRJNA600413" 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
1848906	1848906	PRJNA600413_P_NODE_129662_length_163_cov_2.052632_g128961_i0	PRJNA600413	129662	163	2.052632	3.34579016	Coccomyxa subellipsoidea	248742	Plants	Plants	302	1.22e-77	NTclustered	gi\|1360638125\|gb\|AC277041.1\|	574566	g128961	i0	100	97.8282208588957	163	0	100	0	1	163	39519	39681	Coccomyxa subellipsoidea C-169 clone FAHX05-A01, complete sequence	blastn	15946	302	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
3126115	3126115	PRJNA600413_P_NODE_82103_length_178_cov_2.093023_g81402_i0	PRJNA600413	82103	178	2.093023	3.72558094	Prototheca wickerhamii	3111	Plants	Plants	107	2.6600000000000003e-27	NR	KAK2077382.1	3111	g81402	i0	100	0.960674157303371	57	0	96.1	0	2	172	169	225	KAK2077382.1 hypothetical protein QBZ16_004227 [Prototheca wickerhamii]	diamond	171	107	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Prototheca	Prototheca wickerhamii
8226376	8226376	PRJNA600413_P_NODE_131027_length_163_cov_1.070175_g130326_i0	PRJNA600413	131027	163	1.070175	1.74438525	Chlamydomonas reinhardtii	3055	Plants	Plants	52.8	0.014	NTclustered	gi\|2082239373\|ref\|XM_001699987.2\|	3055	g130326	i0	100	0.171779141104294	28	0	17	0	111	138	138	111	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g097900v5), mRNA	blastn	28	52.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
12621648	12621648	PRJNA600413_P_NODE_81470_length_179_cov_1.176923_g80769_i0	PRJNA600413	81470	179	1.176923	2.10669217	Chlamydomonadaceae	3051	Plants	Plants	76.8	9e-10	NTclustered	gi\|17028256\|gb\|L42859.1\|CRECPRGOL	47905	g80769	i0	87.879	1.10614525139665	66	7	37	1	26	91	491	555	Chlamydomonas mutabilis chloroplast large-subunit ribosomal RNA (rrnL), site-specific DNA endonuclease I-CmuI gene	blastn	198	76.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas mutabilis
13896355	13896355	PRJNA600413_P_NODE_50951_length_207_cov_2.240506_g50250_i0	PRJNA600413	50951	207	2.240506	4.63784742	Coccomyxa	41891	Plants	Plants	383	5.65e-102	NTclustered	gi\|1601875646\|gb\|MK694759.1\|	2315456	g50250	i0	100	97	207	0	100	0	1	207	4095	3889	Coccomyxa sp. Obi small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	20079	383	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa sp. Obi
23526599	23526599	PRJNA600413_P_NODE_39899_length_228_cov_2.346369_g39198_i0	PRJNA600413	39899	228	2.346369	5.34972132	Coccomyxa subellipsoidea	248742	Plants	Plants	399	6.299999999999999e-107	NTclustered	gi\|1360638125\|gb\|AC277041.1\|	574566	g39198	i0	98.246	3.12719298245614	228	4	100	0	1	228	39678	39905	Coccomyxa subellipsoidea C-169 clone FAHX05-A01, complete sequence	blastn	713	399	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
29479562	29479562	PRJNA600413_P_NODE_66430_length_189_cov_1.092857_g65729_i0	PRJNA600413	66430	189	1.092857	2.06549973	Chlamydomonas eustigma	1157962	Plants	Plants	49.3	8.99e-5	NR	GAX78925.1	1157962	g65729	i0	42.3	0.825396825396825	52	24	73	2	138	1	396	447	GAX78925.1 hypothetical protein CEUSTIGMA_g6364.t1 [Chlamydomonas eustigma]	diamond	156	49.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas eustigma
30743413	30743413	PRJNA600413_P_NODE_126554_length_164_cov_0.886957_g125853_i0	PRJNA600413	126554	164	0.886957	1.45460948	Coccomyxa elongata	1965095	Plants	Plants	50.1	3.3e-5	NR	CAL8465704.1	1965095	g125853	i0	78.6	0.51219512195122	28	6	51.2	0	2	85	440	467	CAL8465704.1 g5240 [Coccomyxa elongata]	diamond	84	50.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa elongata

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