metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA928559" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA928559" 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
903916	903916	PRJNA928559_P_NODE_32501_length_577_cov_2.101190_g30970_i0	PRJNA928559	32501	577	2.10119	12.1238663	Chlamydomonas incerta	51695	Plants	Plants	481	6.13e-131	NTclustered	gi\|74272614\|gb\|DQ122872.1\|	51695	g30970	i0	81.897	89.2547660311958	580	95	99	9	3	577	121	695	Chlamydomonas incerta mitochondrial ADP/ATP translocator (ANT) mRNA, complete cds; nuclear gene for mitochondrial product	blastn	51500	481	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas incerta
904664	904664	PRJNA928559_P_NODE_92901_length_369_cov_4.442568_g91332_i0	PRJNA928559	92901	369	4.442568	16.39307592	Desmodesmus pannonicus	119580	Plants	Plants	213	1.52e-50	NTclustered	gi\|693012474\|dbj\|AB917139.1\|	119580	g91332	i0	86.979	53.0054200542005	192	22	51	3	54	242	1191	1382	Desmodesmus pannonicus genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence, strain: GM4n	blastn	19559	213	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Desmodesmus	Desmodesmus pannonicus
4731901	4731901	PRJNA928559_P_NODE_209524_length_244_cov_0.912281_g207955_i0	PRJNA928559	209524	244	0.912281	2.22596564	Chlamydomonas reinhardtii	3055	Plants	Plants	69.4	2.19e-7	NTclustered	gi\|2082242289\|ref\|XM_043060843.1\|	3055	g207955	i0	87.097	3.25	62	7	25	1	39	99	443	504	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g168800v5), mRNA	blastn	793	69.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
6356690	6356690	PRJNA928559_P_NODE_125945_length_317_cov_1.204918_g124376_i0	PRJNA928559	125945	317	1.204918	3.81959006	root	1	Root_unresolved	Root_unresolved	52.8	0.03	NTclustered	gi\|302840177\|ref\|XM_002951599.1\|	3068	g124376	i0	100	0.176656151419558	28	0	9	0	123	150	2378	2351	Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_117875), partial mRNA	blastn	56	52.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
8556434	8556434	PRJNA928559_P_NODE_219807_length_234_cov_2.434783_g218238_i0	PRJNA928559	219807	234	2.434783	5.69739222	Chlorella variabilis	554065	Plants	Plants	52.8	0.021	NTclustered	gi\|552831788\|ref\|XM_005848137.1\|	554065	g218238	i0	100	0.11965811965812	28	0	12	0	120	147	1016	989	Chlorella variabilis hypothetical protein (CHLNCDRAFT_144674) mRNA, complete cds	blastn	28	52.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
8557382	8557382	PRJNA928559_P_NODE_80927_length_394_cov_2.392523_g79358_i0	PRJNA928559	80927	394	2.392523	9.42654062	Auxenochlorella protothecoides	3075	Plants	Plants	231	4.509999999999999e-56	NTclustered	gi\|760439798\|ref\|XM_011398666.1\|	3075	g79358	i0	77.949	17.5761421319797	390	73	97	11	1	382	805	421	Auxenochlorella protothecoides Succinate dehydrogenase [ubiquinone] flavoprotein subunit 1, mitochondrial partial mRNA	blastn	6925	231	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
8905439	8905439	PRJNA928559_P_NODE_123907_length_319_cov_4.471545_g122338_i0	PRJNA928559	123907	319	4.471545	14.26422855	root	1	Root_unresolved	Root_unresolved	117	1.05e-21	NTclustered	gi\|1597964250\|gb\|MK030604.2\|	1818016	g122338	i0	91.667	23.8495297805643	84	7	26	0	1	84	4829	4746	Uncultured Pedinophyceae 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	7608	117	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Pedinophyceae				uncultured Pedinophyceae
10181596	10181596	PRJNA928559_P_NODE_201408_length_247_cov_1.758621_g199839_i0	PRJNA928559	201408	247	1.758621	4.34379387	Tetradesmus	91192	Plants	Plants	424	4.1099999999999996e-114	NTclustered	gi\|108773031\|ref\|NC_008101.1\|	3088	g199839	i0	97.581	143.967611336032	248	5	100	1	1	247	81209	80962	Acutodesmus obliquus strain UTEX 393 chloroplast, complete genome	blastn	35560	424	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Tetradesmus	Tetradesmus obliquus
12381278	12381278	PRJNA928559_P_NODE_116650_length_330_cov_1.587549_g115081_i0	PRJNA928559	116650	330	1.587549	5.2389117	Haematococcus lacustris	44745	Plants	Plants	355	2.11e-93	NTclustered	gi\|1279575454\|gb\|MF683078.1\|	44745	g115081	i0	86.145	255.224242424242	332	43	99	3	2	330	3201	3532	Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast	blastn	84224	355	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
12381884	12381884	PRJNA928559_P_NODE_158410_length_279_cov_1.626214_g156841_i0	PRJNA928559	158410	279	1.626214	4.53713706	Auxenochlorella protothecoides	3075	Plants	Plants	318	2.2899999999999995e-82	NTclustered	gi\|760440306\|ref\|XM_011398920.1\|	3075	g156841	i0	90.204	98.1756272401434	245	23	87	1	36	279	852	608	Auxenochlorella protothecoides S-adenosylmethionine synthase 2 partial mRNA	blastn	27391	318	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides
12732437	12732437	PRJNA928559_P_NODE_223830_length_227_cov_2.564935_g222261_i0	PRJNA928559	223830	227	2.564935	5.82240245	Chlorophyta	3041	Plants	Plants	313	8.400000000000001e-81	NTclustered	gi\|535783\|dbj\|D17810.1\|CHLLSURRNA	63676	g222261	i0	91.63	99.9559471365639	227	18	100	1	1	227	2052	2277	Chlorella ellipsoidea gene for large subunit rRNA, with group-I self-splicing intron	blastn	22690	315	0.993650793650794	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Watanabeales	Watanabeaceae	Chloroidium	Chloroidium ellipsoideum
13656925	13656925	PRJNA928559_P_NODE_193351_length_251_cov_0.876404_g191782_i0	PRJNA928559	193351	251	0.876404	2.19977404	Chlamydomonas reinhardtii	3055	Plants	Plants	158	4.69e-34	NTclustered	gi\|571469\|gb\|U16724.1\|CRU16724	3055	g191782	i0	91.964	47.4541832669323	112	9	45	0	1	112	1169	1280	Chlamydomonas reinhardtii histone H3 (ch3-II), histone H4 (ch4-II), histone H2B (ch2b-II) and histone H2A (ch2a-II) genes, complete cds	blastn	11911	158	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
13657506	13657506	PRJNA928559_P_NODE_27971_length_614_cov_3.171904_g26453_i0	PRJNA928559	27971	614	3.171904	19.47549056	Chlamydomonas reinhardtii	3055	Plants	Plants	327	9.03e-85	NTclustered	gi\|2082235778\|ref\|XM_001700261.2\|	3055	g26453	i0	84.071	62.5814332247557	339	54	55	0	261	599	740	402	Chlamydomonas reinhardtii ribosomal protein L40 (CHLRE_01g007051v5), mRNA	blastn	38425	327	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
14007257	14007257	PRJNA928559_P_NODE_9931_length_972_cov_27.291435_g8745_i0	PRJNA928559	9931	972	27.291435	265.2727482	Eukaryota	2759	Plants	Plants	1688	0	NTclustered	gi\|1201359271\|gb\|MF040793.1\|	3078	g8745	i0	97.639	93.9074074074074	974	21	100	1	1	972	1027	54	Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence	blastn	91278	1688	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella pyrenoidosa
16205501	16205501	PRJNA928559_P_NODE_144853_length_293_cov_2.250000_g143284_i0	PRJNA928559	144853	293	2.25	6.5925	Tetradesmus bajacalifornicus	269609	Plants	Plants	514	2.88e-141	NTclustered	gi\|2692951786\|ref\|NC_086755.1\|	269609	g143284	i0	98.294	135.675767918089	293	5	100	0	1	293	81151	80859	Tetradesmus bajacalifornicus strain SAG 3.99 chloroplast, complete genome	blastn	39753	514	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Tetradesmus	Tetradesmus bajacalifornicus
18754248	18754248	PRJNA928559_P_NODE_156975_length_280_cov_2.951691_g155406_i0	PRJNA928559	156975	280	2.951691	8.2647348	Micractinium conductrix	554055	Plants	Plants	102	2.53e-17	NTclustered	gi\|1229242476\|gb\|KY629619.1\|	554055	g155406	i0	91.781	2.99642857142857	73	6	26	0	142	214	74244	74172	Micractinium conductrix mitochondrion, complete genome	blastn	839	102	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Micractinium	Micractinium conductrix
18754988	18754988	PRJNA928559_P_NODE_208455_length_244_cov_1.824561_g206886_i0	PRJNA928559	208455	244	1.824561	4.45192884	Monoraphidium neglectum	145388	Plants	Plants	141	4.57e-29	NTclustered	gi\|926798264\|ref\|XM_014051102.1\|	145388	g206886	i0	78.166	6.55327868852459	229	45	92	3	1	225	528	301	Monoraphidium neglectum 60S ribosomal protein L18-3 mRNA	blastn	1599	141	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
19104282	19104282	PRJNA928559_P_NODE_180535_length_258_cov_4.124324_g178966_i0	PRJNA928559	180535	258	4.124324	10.64075592	Marvania	97104	Plants	Plants	93.5	1.38e-14	NTclustered	gi\|2724824493\|gb\|PP746561.1\|	97105	g178966	i0	85.106	29.8488372093023	94	10	36	4	140	231	44482	44573	Marvania geminata culture SAG:12.88 mitochondrion, complete genome	blastn	7701	93.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Marvania	Marvania geminata
20029477	20029477	PRJNA928559_P_NODE_170636_length_267_cov_2.484536_g169067_i0	PRJNA928559	170636	267	2.484536	6.63371112	Chlamydomonas reinhardtii	3055	Plants	Plants	150	8.419999999999998e-32	NTclustered	gi\|2082260551\|ref\|XM_001702928.2\|	3055	g169067	i0	78.448	2.34456928838951	232	48	87	2	33	263	159	389	Chlamydomonas reinhardtii ribosomal protein S11 (CHLRE_12g514500v5), mRNA	blastn	626	150	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
21305091	21305091	PRJNA928559_P_NODE_180717_length_258_cov_2.664865_g179148_i0	PRJNA928559	180717	258	2.664865	6.8753517	Chlamydomonas reinhardtii	3055	Plants	Plants	344	3.46e-90	NTclustered	gi\|2082262574\|ref\|XM_001694020.2\|	3055	g179148	i0	90.734	103.294573643411	259	22	100	2	1	258	1152	1409	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g542250v5), mRNA	blastn	26650	344	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
22579857	22579857	PRJNA928559_P_NODE_157418_length_280_cov_1.661836_g155849_i0	PRJNA928559	157418	280	1.661836	4.6531408	Pedobesia claviformis	2364088	Plants	Plants	73.1	1.98e-8	NTclustered	gi\|1511246289\|ref\|NC_039766.1\|	2364088	g155849	i0	93.878	0.867857142857143	49	2	17	1	1	48	4464	4512	Pedobesia claviformis voucher HV04005 chloroplast, complete genome	blastn	243	73.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Derbesiaceae	Pedobesia	Pedobesia claviformis

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