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

21 rows where analysis = "blastn", bioproject = "PRJNA356682" 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
398024	398024	PRJNA356682_P_NODE_46981_length_222_cov_6.281879_g46290_i0	PRJNA356682	46981	222	6.281879	13.94577138	Chlamydomonas reinhardtii	3055	Plants	Plants	407	3.65e-109	NTclustered	gi\|1212783794\|gb\|MF083691.1\|	3055	g46290	i0	100	139.108108108108	220	0	99	0	1	220	40560	40779	Chlamydomonas reinhardtii strain CC-1051 M18 (ac9) mt+ chloroplast, complete genome	blastn	30882	407	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
2347878	2347878	PRJNA356682_P_NODE_47502_length_204_cov_26.916031_g46811_i0	PRJNA356682	47502	204	26.916031	54.90870324	Chlamydomonas	3052	Plants	Plants	178	2.81e-40	NTclustered	gi\|2207975053\|gb\|OM985703.1\|	225041	g46811	i0	90.441	65.2647058823529	136	11	67	2	69	204	2126	1993	Chlamydomonas chlamydogama strain SAG 11-48b 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	13314	178	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas chlamydogama
2947927	2947927	PRJNA356682_P_NODE_16543_length_351_cov_1.334532_g15852_i0	PRJNA356682	16543	351	1.334532	4.68420732	Helicosporidium sp. ex Simulium jonesi	145475	Plants	Plants	150	1.1399999999999999e-31	NTclustered	gi\|386800430\|ref\|NC_017841.1\|	145475	g15852	i0	76.596	6.30484330484331	282	60	79	6	43	321	33820	34098	Helicosporidium sp. ex Simulium jonesi mitochondrion, complete genome	blastn	2213	150	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Helicosporidium	Helicosporidium sp. ex Simulium jonesi
3623179	3623179	PRJNA356682_P_NODE_46203_length_231_cov_2.512658_g45512_i0	PRJNA356682	46203	231	2.512658	5.80423998	Desmochloris	138596	Plants	Plants	412	8.22e-111	NTclustered	gi\|57864438\|dbj\|AB049416.2\|	138176	g45512	i0	99.127	99.991341991342	229	2	99	0	1	229	852	624	Desmochloris halophila gene for 18S rRNA	blastn	23098	412	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Chlorocystidales	Chlorocystidaceae	Desmochloris	Desmochloris halophila
4224459	4224459	PRJNA356682_P_NODE_13404_length_385_cov_1.480769_g12714_i0	PRJNA356682	13404	385	1.480769	5.70096065	Trebouxia sp. A1-2	2608996	Plants	Plants	91.6	7.79e-14	NTclustered	gi\|1825511251\|gb\|MN642622.1\|	2608996	g12714	i0	88.312	15.8857142857143	77	8	20	1	3	78	86205	86129	Trebouxia sp. A1-2 mitochondrion, complete genome	blastn	6116	91.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. A1-2
4224813	4224813	PRJNA356682_P_NODE_30684_length_268_cov_16.825641_g29993_i0	PRJNA356682	30684	268	16.825641	45.09271788	Desmodesmus abundans	77547	Plants	Plants	327	3.64e-85	NTclustered	gi\|2312613210\|ref\|NC_066651.1\|	77547	g29993	i0	89.179	90.4888059701493	268	21	100	4	1	268	76936	77195	Desmodesmus abundans strain FBCC-A1277 chloroplast, complete genome	blastn	24251	327	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Desmodesmus	Desmodesmus abundans
5500916	5500916	PRJNA356682_P_NODE_16625_length_350_cov_1.638989_g15934_i0	PRJNA356682	16625	350	1.638989	5.7364615	Hazenia capsulata	2202518	Plants	Plants	220	8.559999999999999e-53	NTclustered	gi\|1197511155\|ref\|NC_034714.1\|	2202518	g15934	i0	83.682	74.5228571428571	239	33	68	6	5	241	79786	79552	Hazenia capsulata chloroplast, complete genome	blastn	26083	220	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulotrichales	Hazeniaceae	Hazenia	Hazenia capsulata
6774815	6774815	PRJNA356682_P_NODE_12646_length_395_cov_147.040373_g11956_i0	PRJNA356682	12646	395	147.040373	580.80947335	Haematococcus lacustris	44745	Plants	Plants	407	7e-109	NTclustered	gi\|1279575454\|gb\|MF683078.1\|	44745	g11956	i0	85.354	245.412658227848	396	55	99	3	1	393	3851	3456	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	96938	407	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
8050807	8050807	PRJNA356682_P_NODE_2787_length_884_cov_33.842170_g2191_i0	PRJNA356682	2787	884	33.84217	299.1647828	Haematococcus lacustris	44745	Plants	Plants	749	0	NTclustered	gi\|1279575454\|gb\|MF683078.1\|	44745	g2191	i0	82.333	288.178733031674	900	123	99	28	1	883	3810	2930	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	254750	749	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
8724693	8724693	PRJNA356682_P_NODE_14787_length_368_cov_2.640678_g14097_i0	PRJNA356682	14787	368	2.640678	9.71769504	Scenedesmaceae	3086	Plants	Plants	619	7.64e-173	NTclustered	gi\|2386955046\|ref\|NC_068582.1\|	55409	g14097	i0	97.011	107.864130434783	368	11	100	0	1	368	91169	90802	Coelastrum microporum chloroplast, complete genome	blastn	39694	625	0.9904	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Coelastrum	Coelastrum microporum
8725148	8725148	PRJNA356682_P_NODE_46867_length_226_cov_2.013072_g46176_i0	PRJNA356682	46867	226	2.013072	4.54954272	root	1	Root_unresolved	Root_unresolved	412	8.01e-111	NTclustered	gi\|1212783794\|gb\|MF083691.1\|	3055	g46176	i0	99.558	120.411504424779	226	1	100	0	1	226	36659	36884	Chlamydomonas reinhardtii strain CC-1051 M18 (ac9) mt+ chloroplast, complete genome	blastn	27213	412	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
10000442	10000442	PRJNA356682_P_NODE_25808_length_289_cov_1.824074_g25117_i0	PRJNA356682	25808	289	1.824074	5.27157386	Trebouxia	13786	Plants	Plants	100	9.42e-17	NTclustered	gi\|162134245\|gb\|EU123948.1\|	160068	g25117	i0	84.314	2.01038062283737	102	16	35	0	50	151	5267	5368	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	581	100	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia aggregata
10601402	10601402	PRJNA356682_P_NODE_3229_length_809_cov_28.338315_g2606_i0	PRJNA356682	3229	809	28.338315	229.25696835	Desmodesmus abundans	77547	Plants	Plants	1214	0	NTclustered	gi\|2312613210\|ref\|NC_066651.1\|	77547	g2606	i0	94.059	154.373300370828	808	35	99	3	1	808	74429	75223	Desmodesmus abundans strain FBCC-A1277 chloroplast, complete genome	blastn	124888	1214	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Desmodesmus	Desmodesmus abundans
11875927	11875927	PRJNA356682_P_NODE_15770_length_358_cov_1.080702_g15080_i0	PRJNA356682	15770	358	1.080702	3.86891316	Dichotomosiphon tuberosus	118263	Plants	Plants	76.8	2.01e-9	NTclustered	gi\|1482674745\|gb\|MH591079.1\|	118263	g15080	i0	76.351	0.41340782122905	148	31	41	4	13	158	34319	34464	Dichotomosiphon tuberosus chloroplast	blastn	148	76.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Bryopsidales	Dichotomosiphonaceae	Dichotomosiphon	Dichotomosiphon tuberosus
12550802	12550802	PRJNA356682_P_NODE_26090_length_288_cov_1.376744_g25399_i0	PRJNA356682	26090	288	1.376744	3.96502272	Chlamydomonadales	3042	Plants	Plants	532	7.8e-147	NTclustered	gi\|1212783794\|gb\|MF083691.1\|	3055	g25399	i0	100	133.118055555556	288	0	100	0	1	288	37492	37205	Chlamydomonas reinhardtii strain CC-1051 M18 (ac9) mt+ chloroplast, complete genome	blastn	38338	532	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
13150946	13150946	PRJNA356682_P_NODE_1471_length_1292_cov_154.776046_g1014_i0	PRJNA356682	1471	1292	154.776046	1999.70651432	Haematococcus lacustris	44745	Plants	Plants	1118	0	NTclustered	gi\|1279575454\|gb\|MF683078.1\|	44745	g1014	i0	83.134	253.513931888545	1257	180	96	28	1	1242	3593	2354	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	327540	1118	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
16974702	16974702	PRJNA356682_P_NODE_17834_length_339_cov_1.627820_g17143_i0	PRJNA356682	17834	339	1.62782	5.5183098	Tetradesmus obliquus	3088	Plants	Plants	255	2.2700000000000002e-63	NTclustered	gi\|1240946758\|gb\|KX756228.1\|	3088	g17143	i0	81.05	4.72271386430678	343	46	98	12	7	339	16905	16572	Tetradesmus obliquus mitochondrion, complete genome	blastn	1601	255	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Tetradesmus	Tetradesmus obliquus
20798831	20798831	PRJNA356682_P_NODE_1997_length_1081_cov_207.302579_g1467_i0	PRJNA356682	1997	1081	207.302579	2240.94087899	Haematococcus lacustris	44745	Plants	Plants	1072	0	NTclustered	gi\|1279575454\|gb\|MF683078.1\|	44745	g1467	i0	84.741	317.375578168363	1101	134	100	28	1	1081	2716	3802	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	343083	1072	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Haematococcaceae	Haematococcus	Haematococcus lacustris
22074072	22074072	PRJNA356682_P_NODE_26278_length_287_cov_1.439252_g25587_i0	PRJNA356682	26278	287	1.439252	4.13065324	Blidingia sp. DT1	2022611	Plants	Plants	470	6.18e-128	NTclustered	gi\|1220117795\|gb\|KY401415.1\|	2022611	g25587	i0	96.181	99.4912891986063	288	9	100	2	1	287	1849	1563	Blidingia sp. DT1 28S ribosomal RNA gene, partial sequence	blastn	28554	470	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulvales	Ulvaceae	Blidingia	Blidingia sp. DT1
23349875	23349875	PRJNA356682_P_NODE_44939_length_241_cov_0.916667_g44248_i0	PRJNA356682	44939	241	0.916667	2.20916747	Trebouxia sp. SL0000003	3350044	Plants	Plants	104	5.9e-18	NTclustered	gi\|2917929628\|emb\|OZ234916.1\|	3350044	g44248	i0	86.957	0.809128630705394	92	12	38	0	4	95	372506	372597	Trebouxia sp. SL0000003 genome assembly, chromosome: 11	blastn	195	104	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia sp. SL0000003
23349922	23349922	PRJNA356682_P_NODE_47119_length_217_cov_7.277778_g46428_i0	PRJNA356682	47119	217	7.277778	15.79277826	Desmodesmus abundans	77547	Plants	Plants	396	7.689999999999997e-106	NTclustered	gi\|2312613210\|ref\|NC_066651.1\|	77547	g46428	i0	99.539	149.161290322581	217	1	100	0	1	217	74044	74260	Desmodesmus abundans strain FBCC-A1277 chloroplast, complete genome	blastn	32368	396	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Desmodesmus	Desmodesmus abundans

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