metadata: contig_metadata: 19 rows where bioproject = "PRJNA1196384" and tax

19 rows where bioproject = "PRJNA1196384" 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
4149668	4149668	PRJNA1196384_S_NODE_724_length_447_cov_4.019512_g660_i0	PRJNA1196384	724	447	4.019512	17.96721864	Chlorellaceae	35461	Plants	Plants	181	4.05e-51	NR	KAL4853221.1	3077	g660	i0	82.2	8.75838926174497	107	19	71.8	0	446	126	108	214	KAL4853221.1 Phytoene synthase [Chlorella vulgaris]	diamond	3915	181	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
7976010	7976010	PRJNA1196384_S_NODE_2367_length_252_cov_0.902326_g2303_i0	PRJNA1196384	2367	252	0.902326	2.27386152	Auxenochlorella protothecoides	3075	Plants	Plants	193	1.29e-44	NTclustered	gi\|760443472\|ref\|XM_011400503.1\|	3075	g2303	i0	81.048	35.0912698412698	248	41	97	6	8	252	4280	4036	Auxenochlorella protothecoides Pyrophosphate-energized vacuolar membrane proton pump 1 partial mRNA	blastn	8843	193	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
11801229	11801229	PRJNA1196384_S_NODE_4470_length_189_cov_4.559211_g4406_i0	PRJNA1196384	4470	189	4.559211	8.61690879	Eukaryota	2759	Plants	Plants	91.7	1.04e-19	NR	RMZ53466.1	3075	g4406	i0	72.1	4.82539682539683	61	17	96.8	0	2	184	473	533	RMZ53466.1 hypothetical protein APUTEX25_003288, partial [Auxenochlorella protothecoides]	diamond	912	91.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
15625459	15625459	PRJNA1196384_S_NODE_3173_length_218_cov_2.900552_g3109_i0	PRJNA1196384	3173	218	2.900552	6.32320336	Chlamydomonas reinhardtii	3055	Plants	Plants	117	6.740000000000001e-22	NTclustered	gi\|2082256028\|ref\|XM_001702556.2\|	3055	g3109	i0	80.124	1.87614678899083	161	28	72	3	56	213	412	253	Chlamydomonas reinhardtii ribosomal protein L30 (CHLRE_10g420750v5), mRNA	blastn	409	117	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
15625509	15625509	PRJNA1196384_S_NODE_6193_length_167_cov_2.676923_g6129_i0	PRJNA1196384	6193	167	2.676923	4.47046141	Bryopsis sp. KO-2	3115439	Plants	Plants	79.3	5.94e-16	NR	GMH32800.1	3041901	g6129	i0	64.8	1.94011976047904	54	19	97	0	165	4	162	215	GMH32800.1 hypothetical protein BSKO_00634 [Bryopsis sp. KO-2023]	diamond	324	79.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Bryopsidaceae	Bryopsis	Bryopsis sp. KO-2023
15625517	15625517	PRJNA1196384_S_NODE_6593_length_164_cov_0.897638_g6529_i0	PRJNA1196384	6593	164	0.897638	1.47212632	Chlamydomonas reinhardtii	3055	Plants	Plants	185	1.2899999999999997e-42	NTclustered	gi\|2082243702\|ref\|XM_043061450.1\|	3055	g6529	i0	89.189	81.280487804878	148	16	90	0	16	163	1160	1307	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g204250v5), mRNA	blastn	13330	185	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
18174332	18174332	PRJNA1196384_S_NODE_5735_length_172_cov_4.555556_g5671_i0	PRJNA1196384	5735	172	4.555556	7.83555632	Chlamydomonas reinhardtii	3055	Plants	Plants	100	5.08e-17	NTclustered	gi\|2082239523\|ref\|XM_001699755.2\|	3055	g5671	i0	98.246	24.6976744186047	57	1	33	0	9	65	221	277	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g101350v5), mRNA	blastn	4248	100	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
20724057	20724057	PRJNA1196384_S_NODE_4557_length_188_cov_2.251656_g4493_i0	PRJNA1196384	4557	188	2.251656	4.23311328	Chlorophyta	3041	Plants	Plants	98.2	2.72e-24	NR	KAF5829003.1	3046	g4493	i0	75.8	14.6489361702128	62	15	98.9	0	186	1	69	130	KAF5829003.1 flagellar associated protein [Dunaliella salina]	diamond	2754	98.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Dunaliellaceae	Dunaliella	Dunaliella salina
24548768	24548768	PRJNA1196384_S_NODE_2320_length_254_cov_3.244240_g2256_i0	PRJNA1196384	2320	254	3.24424	8.2403696	Auxenochlorella protothecoides	3075	Plants	Plants	135	2.2300000000000003e-27	NTclustered	gi\|760444762\|ref\|XM_011401148.1\|	3075	g2256	i0	77.119	3.41338582677165	236	52	93	2	5	239	256	22	Auxenochlorella protothecoides 40S ribosomal protein S16 partial mRNA	blastn	867	135	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
24548776	24548776	PRJNA1196384_S_NODE_320_length_636_cov_6.138564_g265_i0	PRJNA1196384	320	636	6.138564	39.04126704	Scenedesmus sp. NREL 46B-D3	2650976	Plants	Plants	255	3.06e-83	NR	KAF6266377.1	2650976	g265	i0	72.1	12.0188679245283	190	53	89.6	0	10	579	1	190	KAF6266377.1 component of cytosolic 80S ribosome and 60S large subunit [Scenedesmus sp. NREL 46B-D3]	diamond	7644	255	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. NREL 46B-D3
26660649	26660649	PRJNA1196384_S_NODE_1821_length_290_cov_3.229249_g1757_i0	PRJNA1196384	1821	290	3.229249	9.3648221	Bryopsis sp. KO-2	3115439	Plants	Plants	129	2.6799999999999996e-32	NR	GMH40629.1	3041901	g1757	i0	66.7	1.98620689655172	96	32	99.3	0	290	3	522	617	GMH40629.1 hypothetical protein BSKO_08533 [Bryopsis sp. KO-2023]	diamond	576	129	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Bryopsidaceae	Bryopsis	Bryopsis sp. KO-2023
27483274	27483274	PRJNA1196384_S_NODE_2623_length_239_cov_3.435644_g2559_i0	PRJNA1196384	2623	239	3.435644	8.21118916	Scenedesmus sp. PABB	2909984	Plants	Plants	111	2.06e-26	NR	KAF8063060.1	2742167	g2559	i0	60.8	8.92468619246862	79	31	99.2	0	1	237	1621	1699	KAF8063060.1 RPS18 [Scenedesmus sp. PABB004]	diamond	2133	111	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Scenedesmus	Scenedesmus sp. PABB004
28430574	28430574	PRJNA1196384_S_NODE_2246_length_259_cov_1.563063_g2182_i0	PRJNA1196384	2246	259	1.563063	4.04833317	Monoraphidium neglectum	145388	Plants	Plants	61.2	3.65e-9	NR	XP_013895871.1	145388	g2182	i0	61	0.926640926640927	41	16	47.5	0	259	137	142	182	XP_013895871.1 hypothetical protein MNEG_11110 [Monoraphidium neglectum]	diamond	240	61.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
28702133	28702133	PRJNA1196384_S_NODE_7687_length_155_cov_1.644068_g7623_i0	PRJNA1196384	7687	155	1.644068	2.5483054	Eukaryota	2759	Plants	Plants	77	1.24e-16	NR	KAI3434773.1	3077	g7623	i0	70.2	9.52258064516129	47	14	91	0	15	155	29	75	KAI3434773.1 hypothetical protein D9Q98_002833 [Chlorella vulgaris]	diamond	1476	77.4	0.994832041343669	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
28954855	28954855	PRJNA1196384_S_NODE_5328_length_177_cov_3.557143_g5264_i0	PRJNA1196384	5328	177	3.557143	6.29614311	Eukaryota	2759	Plants	Plants	45.1	0.0018600000000000001	NR	KAI8475033.1	39955	g5264	i0	49	1.86440677966102	51	25	84.7	1	13	162	57	107	KAI8475033.1 MAG: ribosomal protein S27a-domain-containing protein [Monoraphidium minutum]	diamond	330	45.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium minutum
29377688	29377688	PRJNA1196384_S_NODE_3249_length_216_cov_2.229050_g3185_i0	PRJNA1196384	3249	216	2.22905	4.814748	Chlorella variabilis	554065	Plants	Plants	61.2	8.14e-9	NR	XP_005848218.1	554065	g3185	i0	54.7	0.736111111111111	53	24	73.6	0	55	213	873	925	XP_005848218.1 hypothetical protein CHLNCDRAFT_51740 [Chlorella variabilis]	diamond	159	61.2	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
30344770	30344770	PRJNA1196384_S_NODE_5632_length_174_cov_1.102190_g5568_i0	PRJNA1196384	5632	174	1.10219	1.9178106	Eukaryota	2759	Plants	Plants	86.3	6.31e-18	NR	PRW51183.1	3076	g5568	i0	75.4	5.87931034482759	57	14	98.3	0	173	3	381	437	PRW51183.1 putative NAD(P)H dehydrogenase (quinone) FQR1-like 1 [Chlorella sorokiniana]	diamond	1023	86.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
31797970	31797970	PRJNA1196384_S_NODE_237_length_712_cov_3.737778_g189_i0	PRJNA1196384	237	712	3.737778	26.61297936	Scenedesmaceae	3086	Plants	Plants	241	2.77e-77	NR	WIA10393.1	3088	g189	i0	68.2	3.23174157303371	192	50	78.4	3	664	107	1	187	WIA10393.1 hypothetical protein OEZ85_010585 [Tetradesmus obliquus]	diamond	2301	241	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Tetradesmus	Tetradesmus obliquus
32570493	32570493	PRJNA1196384_S_NODE_6559_length_164_cov_1.220472_g6495_i0	PRJNA1196384	6559	164	1.220472	2.00157408	Chlamydomonas reinhardtii	3055	Plants	Plants	82	1.8e-16	NR	XP_001691870.1	3055	g6495	i0	67.9	1.9390243902439	53	17	97	0	1	159	529	581	XP_001691870.1 uncharacterized protein CHLRE_03g190100v5 [Chlamydomonas reinhardtii]	diamond	318	82	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii

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