metadata: contig_metadata: 20 rows where bioproject = "PRJNA446034" and tax

20 rows where bioproject = "PRJNA446034" 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
2988915	2988915	PRJNA446034_S_NODE_51123_length_182_cov_11.241379_g51086_i0	PRJNA446034	51123	182	11.241379	20.45930978	Pseudochlorella signiensis	173497	Plants	Plants	274	3.03e-69	NTclustered	gi\|725650714\|ref\|NC_025529.1\|	173497	g51086	i0	93.923	113.016483516484	181	11	99	0	2	182	150023	150203	Pabia signiensis culture-collection SAG:7.90 chloroplast, complete genome	blastn	20569	274	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Pseudochlorella	Pseudochlorella signiensis
6194897	6194897	PRJNA446034_S_NODE_100365_length_155_cov_2.957627_g100328_i0	PRJNA446034	100365	155	2.957627	4.58432185	root	1	Root_unresolved	Root_unresolved	54.3	5.68e-7	NR	KAG2426943.1	51695	g100328	i0	72.4	2.74838709677419	29	8	56.1	0	3	89	188	216	KAG2426943.1 hypothetical protein HXX76_012728 [Chlamydomonas incerta]	diamond	426	54.7	0.992687385740402	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas incerta
6815763	6815763	PRJNA446034_S_NODE_12006_length_252_cov_3.455814_g11969_i0	PRJNA446034	12006	252	3.455814	8.70865128	Symbiochloris irregularis	706552	Plants	Plants	96.3	4.179999999999999e-23	NR	KAK9798558.1	706552	g11969	i0	74.5	4.82142857142857	55	14	65.5	0	250	86	98	152	KAK9798558.1 hypothetical protein WJX73_004706 [Symbiochloris irregularis]	diamond	1215	96.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Symbiochloris	Symbiochloris irregularis
11917101	11917101	PRJNA446034_S_NODE_72550_length_168_cov_2.282443_g72513_i0	PRJNA446034	72550	168	2.2824430000000002	3.83450424	Chloroidium ellipsoideum	63676	Plants	Plants	248	1.68e-61	NTclustered	gi\|535783\|dbj\|D17810.1\|CHLLSURRNA	63676	g72513	i0	93.413	97.3095238095238	167	11	99	0	2	168	110	276	Chlorella ellipsoidea gene for large subunit rRNA, with group-I self-splicing intron	blastn	16348	248	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Watanabeales	Watanabeaceae	Chloroidium	Chloroidium ellipsoideum
13191712	13191712	PRJNA446034_S_NODE_23911_length_217_cov_2.366667_g23874_i0	PRJNA446034	23911	217	2.366667	5.13566739	Trebouxia lynnae	1825957	Plants	Plants	374	3.6e-99	NTclustered	gi\|1812100161\|ref\|NC_045839.1\|	1825957	g23874	i0	97.696	84.7188940092166	217	5	100	0	1	217	195691	195475	Trebouxia sp. TR9 chloroplast, partial genome	blastn	18384	374	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia lynnae
18289665	18289665	PRJNA446034_S_NODE_10175_length_261_cov_5.754464_g10138_i0	PRJNA446034	10175	261	5.754464	15.01915104	Nannochloris normandinae	926285	Plants	Plants	483	7.12e-132	NTclustered	gi\|922575245\|gb\|JQ921007.1\|	926285	g10138	i0	100	97.7892720306513	261	0	100	0	1	261	826	566	Nannochloris normandinae strain SAG 9.82 23S large subunit ribosomal RNA gene, partial sequence; chloroplast	blastn	25523	483	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Nannochloris	Nannochloris normandinae
18289728	18289728	PRJNA446034_S_NODE_13155_length_247_cov_2.923810_g13118_i0	PRJNA446034	13155	247	2.92381	7.2218107	Coccomyxa subellipsoidea	248742	Plants	Plants	158	4.6e-34	NTclustered	gi\|545366309\|ref\|XM_005648003.1\|	574566	g13118	i0	79.654	15.1497975708502	231	38	94	7	3	233	2393	2614	Coccomyxa subellipsoidea C-169 V0/A0 complex, 116-kDa subunit of ATPase mRNA	blastn	3742	158	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
19563975	19563975	PRJNA446034_S_NODE_27596_length_210_cov_4.572254_g27559_i0	PRJNA446034	27596	210	4.572254	9.6017334	Trebouxia sp. SL0000003	3350044	Plants	Plants	132	2.3e-26	NTclustered	gi\|2917929625\|emb\|OZ234913.1\|	3350044	g27559	i0	86.614	3.97619047619048	127	8	59	4	30	153	1311504	1311384	Trebouxia sp. SL0000003 genome assembly, chromosome: 8	blastn	835	132	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. SL0000003
19564076	19564076	PRJNA446034_S_NODE_49296_length_184_cov_3.190476_g49259_i0	PRJNA446034	49296	184	3.190476	5.87047584	[Myrmecia] bisecta	41462	Plants	Plants	102	2.02e-26	NR	KAK9820180.1	41462	g49259	i0	88.5	1.98913043478261	61	7	99.5	0	1	183	27	87	KAK9820180.1 hypothetical protein WJX72_007173 [[Myrmecia] bisecta]	diamond	366	102	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
19564209	19564209	PRJNA446034_S_NODE_83816_length_162_cov_2.752000_g83779_i0	PRJNA446034	83816	162	2.752	4.45824	uncultured Planophila	1586189	Plants	Plants	289	9.44e-74	NTclustered	gi\|2515376631\|gb\|OR101488.1\|	1586189	g83779	i0	98.765	92.2901234567901	162	2	100	0	1	162	1143	982	Uncultured Planophila clone SchF170815_mgcl52 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	14951	289	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulotrichales			uncultured Planophila
20839610	20839610	PRJNA446034_S_NODE_10097_length_262_cov_1.875556_g10060_i0	PRJNA446034	10097	262	1.875556	4.91395672	Trebouxia sp. SL0000003	3350044	Plants	Plants	313	9.93e-81	NTclustered	gi\|2917929689\|emb\|OZ234917.1\|	3350044	g10060	i0	88.889	0.99618320610687	261	19	98	9	1	256	1719355	1719100	Trebouxia sp. SL0000003 genome assembly, chromosome: 12	blastn	261	313	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. SL0000003
22114751	22114751	PRJNA446034_S_NODE_4018_length_323_cov_5.122378_g3981_i0	PRJNA446034	4018	323	5.122378	16.54528094	Ulva compressa	63659	Plants	Plants	268	2.7699999999999998e-67	NTclustered	gi\|2043344467\|gb\|MW353781.1\|	63659	g3981	i0	86.345	100.743034055728	249	31	77	2	70	318	69276	69521	Ulva compressa isolate Uco3 plastid, complete genome	blastn	32540	268	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulvales	Ulvaceae	Ulva	Ulva compressa
27834059	27834059	PRJNA446034_S_NODE_66124_length_172_cov_1.422222_g66087_i0	PRJNA446034	66124	172	1.422222	2.44622184	Edaphochlorella mirabilis	3083	Plants	Plants	68.9	8.37e-12	NR	YP_009105144.1	3083	g66087	i0	55.4	2.77325581395349	56	25	97.7	0	1	168	1928	1983	YP_009105144.1 cell division protein [Edaphochlorella mirabilis]	diamond	477	68.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Prasiolales	Prasiolaceae	Edaphochlorella	Edaphochlorella mirabilis
27897184	27897184	PRJNA446034_S_NODE_97705_length_156_cov_3.193277_g97668_i0	PRJNA446034	97705	156	3.193277	4.98151212	Chlorella sorokiniana	3076	Plants	Plants	90.1	2.14e-19	NR	YP_009049997.1	3076	g97668	i0	75	3	52	13	100	0	1	156	384	435	YP_009049997.1 NADH dehydrogenase subunit 4 [Chlorella sorokiniana]	diamond	468	90.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella sorokiniana
28402488	28402488	PRJNA446034_S_NODE_67486_length_171_cov_2.149254_g67449_i0	PRJNA446034	67486	171	2.149254	3.67522434	Trebouxia sp. C	2796353	Plants	Plants	104	2.73e-24	NR	KAL3136501.1	3373144	g67449	i0	89.3	1.96491228070175	56	6	98.2	0	170	3	577	632	KAL3136501.1 hypothetical protein ABBQ38_005752 [Trebouxia sp. C0009 RCD-2024]	diamond	336	104	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0009 RCD-2024
28718287	28718287	PRJNA446034_S_NODE_18307_length_230_cov_2.222798_g18270_i0	PRJNA446034	18307	230	2.222798	5.1124354	Coccomyxa subellipsoidea C-169	574566	Plants	Plants	84	1.78e-19	NR	XP_005650138.1	574566	g18270	i0	89.4	0.61304347826087	47	5	61.3	0	230	90	14	60	XP_005650138.1 putative 40S ribosomal protein S30 [Coccomyxa subellipsoidea C-169]	diamond	141	84	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
29208284	29208284	PRJNA446034_S_NODE_74169_length_167_cov_2.538462_g74132_i0	PRJNA446034	74169	167	2.538462	4.23923154	Trebouxiaceae	2507902	Plants	Plants	59.7	5.55e-9	NR	YP_009138106.1	312850	g74132	i0	84.8	1.76047904191617	33	5	59.3	0	166	68	171	203	YP_009138106.1 NADH dehydrogenase subunit 6 [Lobosphaera incisa]	diamond	294	59.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Lobosphaera	Lobosphaera incisa
30945508	30945508	PRJNA446034_S_NODE_36694_length_197_cov_3.462500_g36657_i0	PRJNA446034	36694	197	3.4625	6.821125	Chlorellales	35460	Plants	Plants	95.9	3.88e-21	NR	XP_011396515.1	3075	g36657	i0	69.2	7.91878172588832	65	20	99	0	2	196	636	700	XP_011396515.1 Transketolase, chloroplastic [Auxenochlorella protothecoides]	diamond	1560	96.7	0.991726990692865	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
30992398	30992398	PRJNA446034_S_NODE_39554_length_194_cov_1.165605_g39517_i0	PRJNA446034	39554	194	1.165605	2.2612737	Trebouxia sp. C	2796353	Plants	Plants	114	5.36e-28	NR	KAL3149488.1	3373145	g39517	i0	95.2	0.974226804123711	63	3	97.4	0	3	191	318	380	KAL3149488.1 hypothetical protein ABBQ32_002271 [Trebouxia sp. C0010 RCD-2024]	diamond	189	114	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. C0010 RCD-2024
31213031	31213031	PRJNA446034_S_NODE_66055_length_172_cov_1.688889_g66018_i0	PRJNA446034	66055	172	1.688889	2.90488908	Symbiochloris irregularis	706552	Plants	Plants	54.3	1.04e-6	NR	KAK9810808.1	706552	g66018	i0	61.5	2.07558139534884	39	11	68	1	119	3	198	232	KAK9810808.1 hypothetical protein WJX73_009069 [Symbiochloris irregularis]	diamond	357	54.3	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Symbiochloris	Symbiochloris irregularis

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