metadata: contig_metadata: 13 rows where bioproject = "PRJNA1249535" and tax

13 rows where bioproject = "PRJNA1249535" 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
356545	356545	PRJNA1249535_S_NODE_223701_length_294_cov_1.411765_g220318_i0	PRJNA1249535	223701	294	1.411765	4.1505891	Chloroidium sp. KL-2023a	3031248	Plants	Plants	403	6.5399999999999995e-108	NTclustered	gi\|2450595352\|gb\|ON986219.1\|	3031248	g220318	i0	95.968	96.1598639455782	248	10	97	0	3	250	248	1	Chloroidium sp. KL-2023a clone 2023 chloroplast, complete genome	blastn	28271	403	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Watanabeales	Watanabeaceae	Chloroidium	Chloroidium sp. KL-2023a
2907387	2907387	PRJNA1249535_S_NODE_219583_length_296_cov_2.008969_g216200_i0	PRJNA1249535	219583	296	2.008969	5.94654824	Pectinodesmus pectinatus	91197	Plants	Plants	52.8	0.027	NTclustered	gi\|1331211341\|ref\|NC_036668.1\|	91197	g216200	i0	100	0.0945945945945946	28	0	9	0	4	31	35920	35893	Pectinodesmus pectinatus chloroplast, complete genome	blastn	28	52.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Pectinodesmus	Pectinodesmus pectinatus
2907829	2907829	PRJNA1249535_S_NODE_256683_length_276_cov_3.566502_g253300_i0	PRJNA1249535	256683	276	3.566502	9.84354552	Cephaleuros karstenii	1985640	Plants	Plants	54.7	0.007	NTclustered	gi\|2192923902\|ref\|NC_060534.1\|	1985640	g253300	i0	100	0.206521739130435	29	0	11	0	1	29	2090	2062	Cephaleuros karstenii strain GD1942 chloroplast, complete genome	blastn	57	54.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Trentepohliales	Trentepohliaceae	Cephaleuros	Cephaleuros karstenii
8011541	8011541	PRJNA1249535_S_NODE_34547_length_547_cov_4.635021_g31269_i0	PRJNA1249535	34547	547	4.635021	25.35356487	Cephaleuros diffusus	1519597	Plants	Plants	56.5	0.004	NTclustered	gi\|2692956661\|ref\|NC_086864.1\|	1519597	g31269	i0	96.97	0.0603290676416819	33	1	6	0	334	366	147036	147068	Cephaleuros diffusus chloroplast, complete genome	blastn	33	56.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Trentepohliales	Trentepohliaceae	Cephaleuros	Cephaleuros diffusus
14384529	14384529	PRJNA1249535_S_NODE_131672_length_347_cov_6.489051_g128289_i0	PRJNA1249535	131672	347	6.489051	22.51700697	Cephaleuros karstenii	1985640	Plants	Plants	52.8	0.033	NTclustered	gi\|2192923902\|ref\|NC_060534.1\|	1985640	g128289	i0	100	0.0806916426512968	28	0	8	0	121	148	143934	143961	Cephaleuros karstenii strain GD1942 chloroplast, complete genome	blastn	28	52.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Trentepohliales	Trentepohliaceae	Cephaleuros	Cephaleuros karstenii
15661155	15661155	PRJNA1249535_S_NODE_43433_length_503_cov_27.672093_g40105_i0	PRJNA1249535	43433	503	27.672093	139.19062779	Hydrodictyon reticulatum	3107	Plants	Plants	54.7	0.014	NTclustered	gi\|1197510262\|ref\|NC_034655.1\|	3107	g40105	i0	90.476	0.0834990059642147	42	2	8	1	80	119	11454	11495	Hydrodictyon reticulatum voucher HAM0289 chloroplast, complete genome	blastn	42	54.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Hydrodictyaceae	Hydrodictyon	Hydrodictyon reticulatum
21454316	21454316	PRJNA1249535_S_NODE_297357_length_254_cov_2.337017_g293974_i0	PRJNA1249535	297357	254	2.337017	5.93602318	Stichococcaceae	2910630	Plants	Plants	453	5.41e-123	NTclustered	gi\|728042166\|gb\|KM438447.1\|	358140	g293974	i0	98.819	99.8779527559055	254	3	100	0	1	254	517	264	Stichococcus jenerensis isolate CAUP J 1302 ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit (rbcL) gene, partial cds; chloroplast	blastn	25369	453	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Prasiolales	Stichococcaceae	Tetratostichococcus	Tetratostichococcus jenerensis
24582730	24582730	PRJNA1249535_S_NODE_200560_length_306_cov_2.334764_g197177_i0	PRJNA1249535	200560	306	2.334764	7.14437784	Sykidion marinum	44573	Plants	Plants	52.8	0.029	NTclustered	gi\|1197510977\|ref\|NC_034710.1\|	44573	g197177	i0	100	0.0915032679738562	28	0	9	0	224	251	6491	6464	Pseudoneochloris marina culture UTEX:1445 chloroplast, complete genome	blastn	28	52.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Sykidiales	Sykidiacaeae	Sykidion	Sykidion marinum
28337048	28337048	PRJNA1249535_S_NODE_228066_length_291_cov_4.885321_g224683_i0	PRJNA1249535	228066	291	4.885321	14.21628411	Chlorella desiccata (nom. nud.)	1650286	Plants	Plants	48.9	4.33e-4	NR	KAL4519572.1	1650286	g224683	i0	45.2	0.639175257731959	62	33	63.9	1	275	90	225	285	KAL4519572.1 hypothetical protein Ndes2437A_g07762 [Chlorella desiccata (nom. nud.)]	diamond	186	48.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Nannochloris	Nannochloris sp. 'desiccata'
28512831	28512831	PRJNA1249535_S_NODE_147667_length_337_cov_1.181818_g144284_i0	PRJNA1249535	147667	337	1.181818	3.98272666	root	1	Root_unresolved	Root_unresolved	45.8	0.00917	NR	KAK9815815.1	41462	g144284	i0	56	1.68249258160237	25	11	22.3	0	126	200	1074	1098	KAK9815815.1 hypothetical protein WJX72_010117 [[Myrmecia] bisecta]	diamond	567	46.2	0.991341991341991	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
28778902	28778902	PRJNA1249535_S_NODE_188007_length_313_cov_1.812500_g184624_i0	PRJNA1249535	188007	313	1.8125	5.673125	Pleodorina starrii	330485	Plants	Plants	47.8	0.00155	NR	GLC76333.1	330485	g184624	i0	50	1.35143769968051	48	23	45	1	198	58	590	637	GLC76333.1 hypothetical protein PLESTF_001768400 [Pleodorina starrii]	diamond	423	47.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Pleodorina	Pleodorina starrii
30895341	30895341	PRJNA1249535_S_NODE_129794_length_349_cov_2.514493_g126411_i0	PRJNA1249535	129794	349	2.514493	8.77558057	Scenedesmus sp. PABB	2909984	Plants	Plants	44.7	0.0275	NR	KAF8072686.1	2742167	g126411	i0	44.4	0.541547277936963	63	31	51.6	3	180	1	1008	1069	KAF8072686.1 DEGP8 [Scenedesmus sp. PABB004]	diamond	189	44.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. PABB004
32508472	32508472	PRJNA1249535_S_NODE_280519_length_263_cov_4.026316_g277136_i0	PRJNA1249535	280519	263	4.026316	10.58921108	Coccomyxa sp. Obi	2315456	Plants	Plants	45.4	0.00534	NR	BDA44396.1	2315456	g277136	i0	61.3	2.79467680608365	31	12	35.4	0	93	1	138	168	BDA44396.1 probable LINE-1 retrotransposable element ORF2 protein at N-terminal half [Coccomyxa sp. Obi]	diamond	735	45.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa sp. Obi

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