metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA930380" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA930380" and tax_phylum = "Chlorophyta"

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
3460311	3460311	PRJNA930380_P_NODE_3463_length_346_cov_1.128205_g3410_i0	PRJNA930380	3463	346	1.128205	3.9035893	Haematococcus lacustris	44745	Plants	Plants	185	3.089999999999999e-42	NTclustered	gi\|308208138\|gb\|HQ317401.1\|	44745	g3410	i0	100	30.6098265895954	100	0	29	0	247	346	528	429	Haematococcus pluvialis 16S ribosomal RNA gene, complete sequence; chloroplast	blastn	10591	185	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
4737797	4737797	PRJNA930380_P_NODE_3764_length_334_cov_1.160920_g3711_i0	PRJNA930380	3764	334	1.16092	3.8774728	Coccomyxa subellipsoidea	248742	Plants	Plants	183	1.0699999999999998e-41	NTclustered	gi\|545370524\|ref\|XM_005649837.1\|	574566	g3711	i0	82.629	25.8233532934132	213	32	63	3	57	268	2194	1986	Coccomyxa subellipsoidea C-169 polyadenylate binding protein partial mRNA	blastn	8625	183	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
4737850	4737850	PRJNA930380_P_NODE_7464_length_285_cov_1.207547_g7411_i0	PRJNA930380	7464	285	1.207547	3.44150895	Volvox carteri	3067	Plants	Plants	200	8.879999999999999e-47	NTclustered	gi\|302829087\|ref\|XM_002946065.1\|	3068	g7411	i0	79.783	17.7473684210526	277	54	97	2	1	276	87	362	Volvox carteri f. nagariensis component of cytosolic 80S ribosome and 60S large subunit (rpl21), mRNA	blastn	5058	200	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
6012510	6012510	PRJNA930380_P_NODE_10425_length_267_cov_1.190722_g10372_i0	PRJNA930380	10425	267	1.190722	3.17922774	Pyrobotrys stellatus	3064	Plants	Plants	267	8.01e-67	NTclustered	gi\|18253\|emb\|X69434.1\|	3064	g10372	i0	84.672	16.2921348314607	274	34	100	5	1	267	190	462	C.stellata cab1 mRNA for chlorophyll a/b binding protein	blastn	4350	267	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Spondylomoraceae	Pyrobotrys	Pyrobotrys stellatus
7287357	7287357	PRJNA930380_P_NODE_10526_length_265_cov_1.604167_g10473_i0	PRJNA930380	10526	265	1.604167	4.25104255	Volvox carteri	3067	Plants	Plants	180	1.06e-40	NTclustered	gi\|302846721\|ref\|XM_002954851.1\|	3068	g10473	i0	79.457	2.16603773584906	258	49	97	4	10	265	416	161	Volvox carteri f. nagariensis component of cytosolic 80S ribosome and 40S small subunit (rps4), mRNA	blastn	574	180	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
7287518	7287518	PRJNA930380_P_NODE_3886_length_329_cov_1.804688_g3833_i0	PRJNA930380	3886	329	1.804688	5.93742352	Chlamydomonas reinhardtii	3055	Plants	Plants	209	1.74e-49	NTclustered	gi\|2082255536\|ref\|XM_001696647.2\|	3055	g3833	i0	80.866	3.65045592705167	277	43	83	6	58	329	119	390	Chlamydomonas reinhardtii ribosomal protein S10 (CHLRE_09g411100v5), mRNA	blastn	1201	209	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
9837263	9837263	PRJNA930380_P_NODE_11168_length_254_cov_1.270718_g11115_i0	PRJNA930380	11168	254	1.270718	3.22762372	Dunaliella tertiolecta	3047	Plants	Plants	370	5.61e-98	NTclustered	gi\|371532910\|gb\|JQ039089.1\|	3047	g11115	i0	92.913	142.145669291339	254	18	100	0	1	254	2791	2538	Dunaliella tertiolecta large subunit ribosomal RNA (rrnL), complete sequence; plastid	blastn	36105	370	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Dunaliellaceae	Dunaliella	Dunaliella tertiolecta
13663080	13663080	PRJNA930380_P_NODE_4631_length_305_cov_0.995690_g4578_i0	PRJNA930380	4631	305	0.99569	3.0368545	Chlamydomonas reinhardtii	3055	Plants	Plants	243	1.5700000000000004e-59	NTclustered	gi\|2082253141\|ref\|XM_043065278.1\|	3055	g4578	i0	81.633	2.76393442622951	294	52	96	2	13	305	2176	1884	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_08g381702v5), mRNA	blastn	843	243	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
14937359	14937359	PRJNA930380_P_NODE_3872_length_330_cov_1.046693_g3819_i0	PRJNA930380	3872	330	1.046693	3.4540869	Volvox carteri	3067	Plants	Plants	357	5.879999999999998e-94	NTclustered	gi\|302830857\|ref\|XM_002946949.1\|	3068	g3819	i0	88.927	79.2212121212121	289	32	88	0	8	296	322	34	Volvox carteri f. nagariensis component of cytosolic 80S ribosome and 60S large subunit (rpl36A), mRNA	blastn	26143	357	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
15282835	15282835	PRJNA930380_P_NODE_5912_length_292_cov_1.054795_g5859_i0	PRJNA930380	5912	292	1.054795	3.0800014	Haematococcus	44744	Plants	Plants	540	4.74e-149	NTclustered	gi\|1245897626\|gb\|MF992171.1\|	44745	g5859	i0	100	92.5308219178082	292	0	100	0	1	292	316	607	Haematococcus lacustris isolate KNUA041 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	27019	540	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
16212218	16212218	PRJNA930380_P_NODE_10873_length_260_cov_1.101604_g10820_i0	PRJNA930380	10873	260	1.101604	2.8641704	Haematococcus lacustris	44745	Plants	Plants	407	4.39e-109	NTclustered	gi\|55668303\|gb\|AY786530.1\|	44745	g10820	i0	97.872	31.85	235	5	90	0	1	235	235	1	Haematococcus pluvialis chloroplast major light-harvesting complex II protein m9 mRNA, partial cds; nuclear gene for chloroplast product	blastn	8281	407	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
17487588	17487588	PRJNA930380_P_NODE_13474_length_244_cov_0.900585_g13421_i0	PRJNA930380	13474	244	0.900585	2.1974274	Volvox carteri	3067	Plants	Plants	196	9.61e-46	NTclustered	gi\|302829626\|ref\|XM_002946334.1\|	3068	g13421	i0	86.517	41.3032786885246	178	24	73	0	1	178	463	640	Volvox carteri f. nagariensis component of cytosolic 80S ribosome and 60S large subunit (rpl15), mRNA	blastn	10078	196	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
18760879	18760879	PRJNA930380_P_NODE_10655_length_263_cov_1.621053_g10602_i0	PRJNA930380	10655	263	1.621053	4.26336939	Haematococcus lacustris	44745	Plants	Plants	486	5.5499999999999986e-133	NTclustered	gi\|1169296930\|gb\|KY364700.1\|	44745	g10602	i0	100	67.4448669201521	263	0	100	0	1	263	5753	5491	Haematococcus lacustris 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	17738	486	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
18760996	18760996	PRJNA930380_P_NODE_2135_length_427_cov_1.087571_g2082_i0	PRJNA930380	2135	427	1.087571	4.64392817	Volvox carteri	3067	Plants	Plants	141	8.54e-29	NTclustered	gi\|302851937\|ref\|XM_002957445.1\|	3068	g2082	i0	86.719	5.68618266978923	128	15	30	2	1	127	664	790	Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_84135), mRNA	blastn	2428	141	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
20036013	20036013	PRJNA930380_P_NODE_1916_length_447_cov_1.962567_g1863_i0	PRJNA930380	1916	447	1.962567	8.77267449	Volvox carteri	3067	Plants	Plants	425	2.21e-114	NTclustered	gi\|302828447\|ref\|XM_002945745.1\|	3068	g1863	i0	85.266	26.7136465324385	414	59	92	2	30	442	109	521	Volvox carteri f. nagariensis eukaryotic translation initiation factor 1 alpha 1 (eif1A1), mRNA	blastn	11941	425	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
20036065	20036065	PRJNA930380_P_NODE_4256_length_316_cov_0.950617_g4203_i0	PRJNA930380	4256	316	0.950617	3.00394972	Haematococcus lacustris	44745	Plants	Plants	460	4.15e-125	NTclustered	gi\|78058383\|gb\|DQ178607.1\|	44745	g4203	i0	93.016	4.84493670886076	315	22	99	0	1	315	449	135	Haematococcus pluvialis ribulose-1,5-bisphosphate carboxylase/oxygenase small subunit mRNA, complete cds; plastid	blastn	1531	460	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
20036108	20036108	PRJNA930380_P_NODE_876_length_637_cov_1.588652_g824_i0	PRJNA930380	876	637	1.588652	10.11971324	Chlorella variabilis	554065	Plants	Plants	486	1.4599999999999997e-132	NTclustered	gi\|552810876\|ref\|XM_005843255.1\|	554065	g824	i0	82.936	32.8979591836735	545	87	85	6	29	570	21	562	Chlorella variabilis ribosomal protein L19 (CHLNCDRAFT_33146) mRNA, complete cds	blastn	20956	486	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Chlorella	Chlorella variabilis
20036115	20036115	PRJNA930380_P_NODE_9456_length_274_cov_1.905473_g9403_i0	PRJNA930380	9456	274	1.905473	5.22099602	Haematococcus lacustris	44745	Plants	Plants	292	1.3599999999999999e-74	NTclustered	gi\|55668303\|gb\|AY786530.1\|	44745	g9403	i0	89.03	18.9489051094891	237	24	86	2	37	272	453	218	Haematococcus pluvialis chloroplast major light-harvesting complex II protein m9 mRNA, partial cds; nuclear gene for chloroplast product	blastn	5192	292	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
21311378	21311378	PRJNA930380_P_NODE_11697_length_250_cov_0.870056_g11644_i0	PRJNA930380	11697	250	0.870056	2.17514	Haematococcus lacustris	44745	Plants	Plants	424	4.16e-114	NTclustered	gi\|764697410\|gb\|KM047391.1\|	44745	g11644	i0	97.571	0.988	247	6	99	0	2	248	422	176	Haematococcus pluvialis 1-hydroxy-2-methyl-2-(E)-butenyl 4-diphosphate synthase (hds) mRNA, complete cds	blastn	247	424	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
21311494	21311494	PRJNA930380_P_NODE_3097_length_363_cov_1.055172_g3044_i0	PRJNA930380	3097	363	1.055172	3.83027436	Haematococcus lacustris	44745	Plants	Plants	638	2.08e-178	NTclustered	gi\|117582063\|gb\|EF043383.1\|	44745	g3044	i0	98.347	14.435261707989	363	6	100	0	1	363	905	1267	Haematococcus pluvialis catalase mRNA, complete cds	blastn	5240	638	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
21311554	21311554	PRJNA930380_P_NODE_8537_length_280_cov_1.048309_g8484_i0	PRJNA930380	8537	280	1.048309	2.9352652	Chlamydomonas incerta	51695	Plants	Plants	291	5.02e-74	NTclustered	gi\|74272606\|gb\|DQ122868.1\|	51695	g8484	i0	88.936	25.3892857142857	235	26	84	0	38	272	28	262	Chlamydomonas incerta 40S ribosomal protein S3 mRNA, complete cds	blastn	7109	291	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas incerta
22586321	22586321	PRJNA930380_P_NODE_13938_length_242_cov_1.260355_g13885_i0	PRJNA930380	13938	242	1.260355	3.0500591	Pyrobotrys stellatus	3064	Plants	Plants	193	1.23e-44	NTclustered	gi\|18266\|emb\|X68202.1\|	3064	g13885	i0	81.25	10.6363636363636	240	43	99	2	3	241	421	183	C.stellata mRNA for ribosomal protein L27	blastn	2574	193	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Spondylomoraceae	Pyrobotrys	Pyrobotrys stellatus
23861722	23861722	PRJNA930380_P_NODE_3539_length_343_cov_1.940741_g3486_i0	PRJNA930380	3539	343	1.940741	6.65674163	Monoraphidium neglectum	145388	Plants	Plants	204	8.459999999999998e-48	NTclustered	gi\|926774393\|ref\|XM_014040217.1\|	145388	g3486	i0	80.934	0.749271137026239	257	49	75	0	87	343	258	2	Monoraphidium neglectum 40S ribosomal protein S25-3 mRNA	blastn	257	204	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
25135553	25135553	PRJNA930380_P_NODE_2880_length_374_cov_1.279070_g2827_i0	PRJNA930380	2880	374	1.27907	4.7837218	Haematococcus lacustris	44745	Plants	Plants	226	1.98e-54	NTclustered	gi\|55668303\|gb\|AY786530.1\|	44745	g2827	i0	93.96	20.2219251336898	149	9	40	0	226	374	454	306	Haematococcus pluvialis chloroplast major light-harvesting complex II protein m9 mRNA, partial cds; nuclear gene for chloroplast product	blastn	7563	226	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris

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