metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA986481" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA986481" 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
2248745	2248745	PRJNA986481_P_NODE_32962_length_285_cov_1.114407_g32437_i0	PRJNA986481	32962	285	1.114407	3.17605995	Chlorella variabilis	554065	Plants	Plants	202	2.4699999999999997e-47	NTclustered	gi\|552839119\|ref\|XM_005849662.1\|	554065	g32437	i0	83.41	19.3929824561404	217	36	76	0	1	217	227	443	Chlorella variabilis hypothetical protein (CHLNCDRAFT_21383) mRNA, complete cds	blastn	5527	202	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
2547685	2547685	PRJNA986481_P_NODE_14362_length_433_cov_1.236979_g13837_i0	PRJNA986481	14362	433	1.236979	5.35611907	Eukaryota	2759	Plants	Plants	315	4.83e-81	NTclustered	gi\|926791444\|ref\|XM_014048742.1\|	145388	g13837	i0	80.182	32.9815242494226	439	72	100	11	1	433	2841	2412	Monoraphidium neglectum adenosylhomocysteinase mRNA	blastn	14281	318	0.990566037735849	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
3523761	3523761	PRJNA986481_P_NODE_10623_length_502_cov_10.896247_g10102_i0	PRJNA986481	10623	502	10.896247	54.69915994	Monoraphidium neglectum	145388	Plants	Plants	272	3.46e-68	NTclustered	gi\|926795717\|ref\|XM_014050538.1\|	145388	g10102	i0	86.585	43.4083665338645	246	33	49	0	32	277	115	360	Monoraphidium neglectum 40S ribosomal protein S20-1 mRNA	blastn	21791	272	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
4801641	4801641	PRJNA986481_P_NODE_47144_length_255_cov_1.941748_g46619_i0	PRJNA986481	47144	255	1.941748	4.9514574	Chlamydomonas reinhardtii	3055	Plants	Plants	135	2.24e-27	NTclustered	gi\|2082239523\|ref\|XM_001699755.2\|	3055	g46619	i0	88.496	16.6941176470588	113	11	44	2	137	248	756	645	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g101350v5), mRNA	blastn	4257	135	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
4801718	4801718	PRJNA986481_P_NODE_5224_length_694_cov_1.719380_g4789_i0	PRJNA986481	5224	694	1.71938	11.9324972	Chlorotetraedron incus	162317	Plants	Plants	141	1.44e-28	NTclustered	gi\|674840704\|ref\|NC_024757.1\|	162317	g4789	i0	80.412	3.81988472622478	194	30	28	7	371	561	18927	19115	Chlorotetraedron incus strain SAG 43.81 mitochondrion, complete genome	blastn	2651	141	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Neochloridaceae	Chlorotetraedron	Chlorotetraedron incus
6076793	6076793	PRJNA986481_P_NODE_3465_length_816_cov_3.767927_g3092_i0	PRJNA986481	3465	816	3.767927	30.74628432	Chlamydomonas reinhardtii	3055	Plants	Plants	385	7.12e-102	NTclustered	gi\|2082239556\|ref\|XM_001699745.2\|	3055	g3092	i0	84.343	61.7904411764706	396	58	48	4	9	402	136	529	Chlamydomonas reinhardtii ribosomal protein S3 (CHLRE_02g102250v5), mRNA	blastn	50421	385	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
6076877	6076877	PRJNA986481_P_NODE_40265_length_263_cov_1.785047_g39740_i0	PRJNA986481	40265	263	1.785047	4.69467361	Chlamydomonas reinhardtii	3055	Plants	Plants	106	1.82e-18	NTclustered	gi\|2082260798\|ref\|XM_001697008.2\|	3055	g39740	i0	92	2.11026615969582	75	6	29	0	63	137	1031	957	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g520500v5), mRNA	blastn	555	106	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
8626484	8626484	PRJNA986481_P_NODE_30587_length_295_cov_5.390244_g30062_i0	PRJNA986481	30587	295	5.390244	15.9012198	Ulothrix zonata	43941	Plants	Plants	508	1.35e-139	NTclustered	gi\|530445654\|emb\|HE860533.1\|	43941	g30062	i0	100	93.2779661016949	275	0	93	0	1	275	313	39	Ulothrix zonata partial 28S rRNA gene, isolate Q19	blastn	27517	508	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulotrichales	Ulotrichaceae	Ulothrix	Ulothrix zonata
10200634	10200634	PRJNA986481_P_NODE_19328_length_372_cov_2.863777_g18803_i0	PRJNA986481	19328	372	2.863777	10.65325044	Chlorophyta	3041	Plants	Plants	159	2.0299999999999993e-34	NTclustered	gi\|2909905167\|gb\|PV102504.1\|	51693	g18803	i0	92.793	29.8387096774194	111	7	30	1	262	372	1480	1589	Lobochlamys culleus strain Ter-4-1 small subunit ribosomal RNA gene, partial sequence	blastn	11100	159	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Lobochlamys	Lobochlamys culleus
12452947	12452947	PRJNA986481_P_NODE_4530_length_736_cov_10.401747_g4111_i0	PRJNA986481	4530	736	10.401747	76.55685792	Chlamydomonas reinhardtii	3055	Plants	Plants	346	3.02e-90	NTclustered	gi\|2082248650\|ref\|XM_043063418.1\|	3055	g4111	i0	80.294	63.7540760869565	477	79	64	14	242	710	856	387	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA	blastn	46923	346	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
12452993	12452993	PRJNA986481_P_NODE_48010_length_254_cov_1.707317_g47485_i0	PRJNA986481	48010	254	1.707317	4.33658518	Polytomella sp. Pringsheim 198.80	37502	Plants	Plants	182	2.82e-41	NTclustered	gi\|635557420\|emb\|FN984965.1\|	37502	g47485	i0	81.034	24.5629921259843	232	40	91	4	25	254	1454	1225	Polytomella sp. Pringsheim 198.80 mRNA for S-Adenosyl homocysteine hydrolase (sah1 gene)	blastn	6239	182	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Polytomella	Polytomella sp. Pringsheim 198.80
13727607	13727607	PRJNA986481_P_NODE_6631_length_626_cov_5.176776_g6153_i0	PRJNA986481	6631	626	5.176776	32.40661776	Chlamydomonas incerta	51695	Plants	Plants	198	7.539999999999999e-46	NTclustered	gi\|74272610\|gb\|DQ122870.1\|	51695	g6153	i0	81.061	21.7923322683706	264	36	41	12	368	624	395	139	Chlamydomonas incerta 60S ribosomal protein L11 mRNA, complete cds	blastn	13642	198	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas incerta
15001108	15001108	PRJNA986481_P_NODE_1132_length_1242_cov_29.820620_g924_i0	PRJNA986481	1132	1242	29.82062	370.3721004	Trentepohlia sp. BN17	3063876	Plants	Plants	76.8	7.53e-9	NTclustered	gi\|2192923729\|ref\|NC_060532.1\|	3063876	g924	i0	92.453	0.28743961352657	53	4	4	0	657	709	223433	223485	Trentepohlia sp. BN17 chloroplast, complete genome	blastn	357	76.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Trentepohliales	Trentepohliaceae	Trentepohlia	Trentepohlia sp. BN17
15001562	15001562	PRJNA986481_P_NODE_3992_length_773_cov_2.027624_g3596_i0	PRJNA986481	3992	773	2.027624	15.67353352	Tetraselmis marina	41888	Plants	Plants	139	5.78e-28	NTclustered	gi\|2301280732\|ref\|NC_066039.1\|	41888	g3596	i0	81.034	15.5278137128072	174	33	23	0	500	673	5516	5689	Tetraselmis marina mitochondrion, complete genome	blastn	12003	139	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorodendrophyceae	Chlorodendrales	Chlorodendraceae	Tetraselmis	Tetraselmis marina
16276078	16276078	PRJNA986481_P_NODE_11753_length_478_cov_1.883450_g11230_i0	PRJNA986481	11753	478	1.88345	9.002891	Monoraphidium neglectum	145388	Plants	Plants	231	5.57e-56	NTclustered	gi\|926795717\|ref\|XM_014050538.1\|	145388	g11230	i0	80.192	33.092050209205	313	58	65	4	97	407	365	55	Monoraphidium neglectum 40S ribosomal protein S20-1 mRNA	blastn	15818	231	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
18825408	18825408	PRJNA986481_P_NODE_39475_length_264_cov_1.934884_g38950_i0	PRJNA986481	39475	264	1.934884	5.10809376	Chlamydomonas reinhardtii	3055	Plants	Plants	126	1.3999999999999999e-24	NTclustered	gi\|2082237163\|ref\|XM_043058766.1\|	3055	g38950	i0	78.049	1.5530303030303	205	41	77	4	62	264	854	652	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g039250v5), mRNA	blastn	410	126	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
21375373	21375373	PRJNA986481_P_NODE_13877_length_440_cov_1.823529_g13353_i0	PRJNA986481	13877	440	1.823529	8.0235276	Chlamydomonas reinhardtii	3055	Plants	Plants	562	1.59e-155	NTclustered	gi\|167449\|gb\|M11448.1\|CRETBA2A	3055	g13353	i0	89.773	99.8977272727273	440	43	99	2	1	439	1378	940	Chlamydomonas reinhardtii alpha-2 tubulin gene, complete cds	blastn	43955	562	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
21376006	21376006	PRJNA986481_P_NODE_54277_length_247_cov_2.191919_g53752_i0	PRJNA986481	54277	247	2.191919	5.41403993	Spongiochrysis hawaiiensis	333302	Plants	Plants	135	2.15e-27	NTclustered	gi\|527482308\|emb\|HE664128.1\|	333302	g53752	i0	89.72	41.502024291498	107	9	43	2	1	107	249	353	Spongiochrysis hawaiiensis partial 28S rRNA gene, specimen voucher WELT:A031452, strain G89	blastn	10251	135	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Cladophorales	Cladophoraceae	Spongiochrysis	Spongiochrysis hawaiiensis
21674364	21674364	PRJNA986481_P_NODE_12797_length_458_cov_2.709046_g12273_i0	PRJNA986481	12797	458	2.709046	12.40743068	Eukaryota	2759	Plants	Plants	207	8.96e-49	NTclustered	gi\|552840730\|ref\|XM_005850063.1\|	554065	g12273	i0	79.139	16.9890829694323	302	61	66	2	155	455	468	168	Chlorella variabilis 40S ribosomal protein S18 (CHLNCDRAFT_34417) mRNA, complete cds	blastn	7781	209	0.990430622009569	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
22650527	22650527	PRJNA986481_P_NODE_28538_length_307_cov_1.565891_g28013_i0	PRJNA986481	28538	307	1.565891	4.80728537	Coccomyxa subellipsoidea	248742	Plants	Plants	187	7.529999999999999e-43	NTclustered	gi\|545364605\|ref\|XM_005647292.1\|	574566	g28013	i0	78.596	71.7850162866449	285	59	93	2	1	284	790	1073	Coccomyxa subellipsoidea C-169 heat shock 70 protein mRNA	blastn	22038	187	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea

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