metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJDB12578" and tax

12 rows where analysis = "blastn", bioproject = "PRJDB12578" 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
1275995	1275995	PRJDB12578_S_NODE_137542_length_217_cov_0.922619_g114484_i0	PRJDB12578	137542	217	0.922619	2.00208323	Chlamydomonas agloeformis	160058	Plants	Plants	374	3.6e-99	NTclustered	gi\|17028271\|gb\|L43351.1\|CRECPRRNLB	160058	g114484	i0	97.696	144.608294930876	217	5	100	0	1	217	2124	2340	Chlamydomonas agloeformis chloroplast large subunit ribosomal RNA (rrnL) gene	blastn	31380	374	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas agloeformis
2553346	2553346	PRJDB12578_S_NODE_182683_length_176_cov_1.220472_g159625_i0	PRJDB12578	182683	176	1.220472	2.14803072	Pediastrum duplex	3105	Plants	Plants	215	1.79e-51	NTclustered	gi\|21040380\|gb\|AF183479.2\|	3105	g159625	i0	88.889	24.3238636363636	180	13	100	7	1	176	3036	3212	Pediastrum duplex strain UTEX LB 1364 28S ribosomal RNA gene, partial sequence	blastn	4281	215	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Hydrodictyaceae	Pediastrum	Pediastrum duplex
6378721	6378721	PRJDB12578_S_NODE_103986_length_279_cov_2.152174_g80928_i0	PRJDB12578	103986	279	2.152174	6.00456546	Volvox carteri	3067	Plants	Plants	56.5	0.002	NTclustered	gi\|302841848\|ref\|XM_002952423.1\|	3068	g80928	i0	94.595	0.236559139784946	37	1	13	1	243	278	412	448	Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_93102), partial mRNA	blastn	66	56.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
7358405	7358405	PRJDB12578_S_NODE_134686_length_220_cov_1.824561_g111628_i0	PRJDB12578	134686	220	1.824561	4.0140342	Neochloris	3098	Plants	Plants	368	1.6999999999999997e-97	NTclustered	gi\|9438169\|gb\|AF277653.1\|	3099	g111628	i0	96.818	98.2363636363636	220	7	100	0	1	220	2027	1808	Neochloris aquatica strain UTEX 138 28S ribosomal RNA gene, partial sequence	blastn	21612	368	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Neochloridaceae	Neochloris	Neochloris aquatica
7655899	7655899	PRJDB12578_S_NODE_187387_length_173_cov_1.080645_g164329_i0	PRJDB12578	187387	173	1.080645	1.86951585	Crucigenia quadrata	2782530	Plants	Plants	52.8	0.015	NTclustered	gi\|2875298507\|gb\|PQ301446.1\|	2782530	g164329	i0	100	0.161849710982659	28	0	16	0	53	80	152550	152523	Crucigenia quadrata strain FACHB-1904 chloroplast, complete genome	blastn	28	52.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Crucigenia	Crucigenia quadrata
11478493	11478493	PRJDB12578_S_NODE_106090_length_273_cov_3.522321_g83032_i0	PRJDB12578	106090	273	3.522321	9.61593633	Picochlorum sp.	2812594	Plants	Plants	154	6.68e-33	NTclustered	gi\|2632235332\|gb\|OR922714.1\|	2812594	g83032	i0	92.593	34.1904761904762	108	7	39	1	1	107	3716	3823	Picochlorum sp. strain AGSB0128 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	9334	154	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae			Picochlorum	Picochlorum sp.
11479125	11479125	PRJDB12578_S_NODE_121550_length_240_cov_2.408377_g98492_i0	PRJDB12578	121550	240	2.408377	5.7801048	Chlamydomonas chlamydogama	225041	Plants	Plants	54.7	0.006	NTclustered	gi\|2386956196\|ref\|NC_068623.1\|	225041	g98492	i0	92.308	1.42916666666667	39	1	15	1	175	211	46142	46104	Chlamydomonas chlamydogama strain 11-48b chloroplast, complete genome	blastn	343	54.7	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas chlamydogama
12761945	12761945	PRJDB12578_S_NODE_97011_length_302_cov_1.636364_g73953_i0	PRJDB12578	97011	302	1.636364	4.94181928	Tetradesmus lancea	3073545	Plants	Plants	52.8	0.028	NTclustered	gi\|2661059500\|gb\|OR502671.1\|	3073545	g73953	i0	94.286	0.115894039735099	35	0	11	2	23	55	151730	151764	Tetradesmus lancea strain FBCC-A0708 chloroplast, complete genome	blastn	35	52.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Tetradesmus	Tetradesmus lancea
13734299	13734299	PRJDB12578_S_NODE_196971_length_168_cov_0.764706_g173913_i0	PRJDB12578	196971	168	0.764706	1.28470608	Sphaeropleales	35491	Plants	Plants	259	7.75e-65	NTclustered	gi\|6120006\|gb\|AF183466.1\|	3092	g173913	i0	94.675	100.517857142857	169	6	100	2	1	168	1053	887	Characiopodium hindakii strain UTEX 2098 28S ribosomal RNA gene, partial sequence	blastn	16887	261	0.992337164750958	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Neochloridaceae	Characiopodium	Characiopodium hindakii
17852716	17852716	PRJDB12578_S_NODE_113555_length_256_cov_1.256039_g90497_i0	PRJDB12578	113555	256	1.256039	3.21545984	Neochloris aquatica	3099	Plants	Plants	407	4.31e-109	NTclustered	gi\|1008861455\|ref\|NC_029670.1\|	3099	g90497	i0	95.331	157.1328125	257	10	100	2	1	256	80394	80139	Neochloris aquatica strain UTEX 138 chloroplast, complete genome	blastn	40226	407	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Neochloridaceae	Neochloris	Neochloris aquatica
21677252	21677252	PRJDB12578_S_NODE_109498_length_265_cov_1.175926_g86440_i0	PRJDB12578	109498	265	1.175926	3.1162039	Chlorococcum sp. KSF0227	2978530	Plants	Plants	63.9	1.12e-5	NTclustered	gi\|2441075444\|gb\|OP448669.1\|	2978530	g86440	i0	97.297	0.675471698113208	37	1	14	0	32	68	69831	69867	Chlorococcum sp. KSF0227 chloroplast, complete genome	blastn	179	63.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlorococcaceae	Chlorococcum	Chlorococcum sp. KSF0227
24229476	24229476	PRJDB12578_S_NODE_188040_length_172_cov_1.674797_g164982_i0	PRJDB12578	188040	172	1.674797	2.88065084	Chlamydomonas reinhardtii	3055	Plants	Plants	56.5	0.001	NTclustered	gi\|294846000\|gb\|GU814015.1\|	3055	g164982	i0	100	0.174418604651163	30	0	17	0	1	30	293495	293466	Chlamydomonas reinhardtii strain CC-2290 NIC7m (NIC7m), SPS1m (SPS1m), SPP1Cm (SPP1Cm), EIF5Bbm (EIF5Bbm), PTC1m (PTC1m), 182394m (182394m), 97782m (97782m), RFC4m (RFC4m), 182392m (182392m), ALB3m (ALB3m), PSF2m (PSF2m), 182390m (182390m), 182389m (182389m), 294687m (294687m), HDH1m (HDH1m), TOC34m (TOC34m), 522875m (522875m), LPS1m (LPS1m), PDK1m (PDK1m), CGL70m (CGL70m), NMDA1m (NMDA1m), DRG1m (DRG1m), OTU2m (OTU2m), 155027m (155027m), MTP0618m (MTP0618m), PR46bm (PR46bm), PR46am (PR46am), GCSHm (GCSHm), UBCH1m (UBCH1m), MADS2m (MADS2m), PKY1m (PKY1m), MIDm (MIDm), DLA3m (DLA3m), 522872m (522872m), MTD1m (MTD1m), LEU1Sm (LEU1Sm), SPL2m (SPL2m), HGRP1m (HGRP1m), UTP1m (UTP1m), MTP0796m (MTP0796m), and MT0828m (MT0828m) genes, complete cds	blastn	30	56.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii

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