metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA1063685" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA1063685" 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
179832	179832	PRJNA1063685_S_NODE_63681_length_268_cov_2.138462_g63138_i0	PRJNA1063685	63681	268	2.138462	5.73107816	Koliella corcontica	155904	Plants	Plants	296	1.03e-75	NTclustered	gi\|723456950\|ref\|NC_025536.1\|	155904	g63138	i0	88.048	105.425373134328	251	28	93	2	19	268	83323	83572	Koliella corcontica culture-collection SAG:24.84 chloroplast, complete genome	blastn	28254	296	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Prasiolales	Koliellaceae	Koliella	Koliella corcontica
1454375	1454375	PRJNA1063685_S_NODE_52942_length_306_cov_3.081545_g52399_i0	PRJNA1063685	52942	306	3.081545	9.4295277	uncultured Trebouxia photobiont	285713	Plants	Plants	566	8.239999999999998e-157	NTclustered	gi\|1273623725\|gb\|KY033354.1\|	285713	g52399	i0	100	100.578431372549	306	0	100	0	1	306	6224	6529	Uncultured Trebouxia photobiont voucher Lendemer 46119 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	30777	566	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	uncultured Trebouxia photobiont
2730180	2730180	PRJNA1063685_S_NODE_47663_length_329_cov_8.632812_g47120_i0	PRJNA1063685	47663	329	8.632812	28.40195148	Trebouxia aggregata	160068	Plants	Plants	399	9.6e-107	NTclustered	gi\|162134340\|gb\|EU123979.1\|	160068	g47120	i0	92.388	92.7537993920973	289	9	84	8	1	276	1392	1104	Trebouxia aggregata strain SAG 219-1d large subunit ribosomal RNA (rrl) gene, complete sequence; and putative site-specific DNA endonuclease (orf210) and hypothetical protein (orf277) genes, complete cds; chloroplast	blastn	30516	399	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia aggregata
6557795	6557795	PRJNA1063685_S_NODE_71486_length_247_cov_1.327586_g70943_i0	PRJNA1063685	71486	247	1.327586	3.27913742	Trebouxia sp. SL0000003	3350044	Plants	Plants	209	1.25e-49	NTclustered	gi\|2917929624\|emb\|OZ234912.1\|	3350044	g70943	i0	85.167	1.38866396761134	209	26	83	5	16	221	1174871	1175077	Trebouxia sp. SL0000003 genome assembly, chromosome: 7	blastn	343	209	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. SL0000003
7832397	7832397	PRJNA1063685_S_NODE_61147_length_276_cov_2.049261_g60604_i0	PRJNA1063685	61147	276	2.049261	5.65596036	Coccomyxa subellipsoidea	248742	Plants	Plants	132	3.17e-26	NTclustered	gi\|545365727\|ref\|XM_005647756.1\|	574566	g60604	i0	81.875	15.4673913043478	160	25	57	4	46	203	428	271	Coccomyxa subellipsoidea C-169 D-3-phosphoglycerate dehydrogenase partial mRNA	blastn	4269	132	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
8665279	8665279	PRJNA1063685_S_NODE_59027_length_283_cov_4.328571_g58484_i0	PRJNA1063685	59027	283	4.328571	12.24985593	Prototheca	3110	Plants	Plants	473	4.699999999999999e-129	NTclustered	gi\|49533001\|dbj\|AB097097.2\|	3112	g58484	i0	99.237	79.4310954063604	262	2	93	0	21	282	27	288	Prototheca zopfii gene for 28S rRNA, partial sequence	blastn	22479	473	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Prototheca	Prototheca zopfii
9107398	9107398	PRJNA1063685_S_NODE_62408_length_272_cov_1.909548_g61865_i0	PRJNA1063685	62408	272	1.909548	5.19397056	Trebouxia asymmetrica	13787	Plants	Plants	457	4.53e-124	NTclustered	gi\|189909382\|gb\|EU725860.1\|	13787	g61865	i0	99.6	99.9705882352941	250	1	92	0	1	250	1734	1485	Trebouxia asymmetrica strain SAG 48.88 23S large subunit ribosomal RNA (rrnL) gene, partial sequence; chloroplast	blastn	27192	457	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia asymmetrica
9940198	9940198	PRJNA1063685_S_NODE_50108_length_318_cov_37.893878_g49565_i0	PRJNA1063685	50108	318	37.893878	120.50253204	Eukaryota	2759	Plants	Plants	571	1.8499999999999996e-158	NTclustered	gi\|2031975395\|emb\|OD962788.1\|	3077	g49565	i0	99.057	100.867924528302	318	3	100	0	1	318	1346	1029	Chlorella vulgaris partial 18S rRNA gene, strain JKVK1	blastn	32076	571	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella vulgaris
11658184	11658184	PRJNA1063685_S_NODE_40470_length_366_cov_1.549488_g39927_i0	PRJNA1063685	40470	366	1.549488	5.67112608	Auxenochlorella protothecoides	3075	Plants	Plants	193	1.96e-44	NTclustered	gi\|760444702\|ref\|XM_011401118.1\|	3075	g39927	i0	83.099	35.5601092896175	213	34	58	2	14	225	274	485	Auxenochlorella protothecoides 40S ribosomal protein S23-2 partial mRNA	blastn	13015	193	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
11658404	11658404	PRJNA1063685_S_NODE_67450_length_257_cov_1.565217_g66907_i0	PRJNA1063685	67450	257	1.565217	4.02260769	Trebouxia aggregata	160068	Plants	Plants	281	2.74e-71	NTclustered	gi\|162134340\|gb\|EU123979.1\|	160068	g66907	i0	97.561	67.5992217898833	164	4	78	0	72	235	2008	1845	Trebouxia aggregata strain SAG 219-1d large subunit ribosomal RNA (rrl) gene, complete sequence; and putative site-specific DNA endonuclease (orf210) and hypothetical protein (orf277) genes, complete cds; chloroplast	blastn	17373	281	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia aggregata
11658458	11658458	PRJNA1063685_S_NODE_75390_length_237_cov_3.725610_g74847_i0	PRJNA1063685	75390	237	3.72561	8.8296957	uncultured Trebouxia photobiont	285713	Plants	Plants	405	1.42e-108	NTclustered	gi\|1273623725\|gb\|KY033354.1\|	285713	g74847	i0	97.468	100.700421940928	237	6	100	0	1	237	6574	6810	Uncultured Trebouxia photobiont voucher Lendemer 46119 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	23866	405	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	uncultured Trebouxia photobiont
12933029	12933029	PRJNA1063685_S_NODE_10851_length_616_cov_6.163904_g10336_i0	PRJNA1063685	10851	616	6.163904	37.96964864	Chlamydomonas chlamydogama	225041	Plants	Plants	898	0	NTclustered	gi\|2386956196\|ref\|NC_068623.1\|	225041	g10336	i0	94.128	140.170454545455	596	26	96	7	4	593	5621	6213	Chlamydomonas chlamydogama strain 11-48b chloroplast, complete genome	blastn	86345	898	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas chlamydogama
12933103	12933103	PRJNA1063685_S_NODE_16051_length_550_cov_3.352201_g15521_i0	PRJNA1063685	16051	550	3.352201	18.4371055	Trebouxia aggregata	160068	Plants	Plants	390	1.01e-103	NTclustered	gi\|162134245\|gb\|EU123948.1\|	160068	g15521	i0	95.868	27.3690909090909	242	9	82	1	12	252	5140	5381	Trebouxia aggregata strain SAG 219-1d ribosomal protein S2 (rps2) gene, complete cds; tRNA-Met (trnMe(cau)) and large subunit ribosomal RNA (rnl) genes, complete sequence; putative site-specific DNA endonuclease (orf365) gene, complete cds; small subunit ribosomal RNA (rns) and tRNA-Met (trnMf(cau)) genes, complete sequence; cytochrome c oxidase subunit 1 (cox1), putative site-specific DNA endonuclease (orf335), and putative site-specific DNA endonuclease (orf256) genes, complete cds; tRNA-Phe (trnF(gaa)) and tRNA-Lys (trnK(uuu)) genes, complete sequence; and apocytochrome b (cob) and putative site-specific DNA endonuclease (orf334) genes, complete cds; mitochondrial	blastn	15053	390	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia aggregata
15039793	15039793	PRJNA1063685_S_NODE_64032_length_267_cov_1.634021_g63489_i0	PRJNA1063685	64032	267	1.634021	4.36283607	Trebouxia	13786	Plants	Plants	455	1.5900000000000002e-123	NTclustered	gi\|21631\|emb\|Z21553.1\|	13787	g63489	i0	100	92.1460674157303	246	0	92	0	22	267	696	941	T.asymmetrica gene encoding 18S ribosomal RNA	blastn	24603	455	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia asymmetrica
15482570	15482570	PRJNA1063685_S_NODE_62373_length_272_cov_2.296482_g61830_i0	PRJNA1063685	62373	272	2.296482	6.24643104	Rhexinema sarcinoideum	43261	Plants	Plants	401	2.1499999999999993e-107	NTclustered	gi\|1052423749\|gb\|KX306822.1\|	43261	g61830	i0	96.327	2.68014705882353	245	8	90	1	29	272	6989	7233	Rhexinema sarcinoideum mitochondrion, complete genome	blastn	729	401	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulotrichales	Helicodictyaceae	Rhexinema	Rhexinema sarcinoideum
18031027	18031027	PRJNA1063685_S_NODE_12355_length_595_cov_3.095785_g11838_i0	PRJNA1063685	12355	595	3.095785	18.41992075	Chlorella variabilis	554065	Plants	Plants	436	1.3900000000000002e-117	NTclustered	gi\|552829117\|ref\|XM_005847563.1\|	554065	g11838	i0	82.661	13.3042016806723	496	82	83	4	85	578	1283	790	Chlorella variabilis 26S proteasome AAA-ATPase subunit RPT2a (CHLNCDRAFT_56157) mRNA, complete cds	blastn	7916	436	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
20580893	20580893	PRJNA1063685_S_NODE_63637_length_268_cov_2.764103_g63094_i0	PRJNA1063685	63637	268	2.764103	7.40779604	Chloroidium sp. KL-2023a	3031248	Plants	Plants	407	4.549999999999999e-109	NTclustered	gi\|2450595352\|gb\|ON986219.1\|	3031248	g63094	i0	95.331	52.6529850746269	257	11	96	1	12	268	221568	221823	Chloroidium sp. KL-2023a clone 2023 chloroplast, complete genome	blastn	14111	407	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Watanabeales	Watanabeaceae	Chloroidium	Chloroidium sp. KL-2023a
23131856	23131856	PRJNA1063685_S_NODE_35039_length_396_cov_4.232198_g34496_i0	PRJNA1063685	35039	396	4.232198	16.75950408	Volvox carteri	3067	Plants	Plants	56.5	0.003	NTclustered	gi\|302854337\|ref\|XM_002958632.1\|	3068	g34496	i0	97.059	0.47979797979798	34	0	8	1	64	96	173	206	Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_99967), partial mRNA	blastn	190	56.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri

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