metadata: contig_metadata: 10 rows where bioproject = "PRJNA784298" and tax

10 rows where bioproject = "PRJNA784298" 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
765285	765285	PRJNA784298_P_NODE_14141_length_332_cov_1.189189_g13940_i0	PRJNA784298	14141	332	1.189189	3.94810748	Borodinellopsis insignis	3229915	Plants	Plants	422	2.07e-113	NTclustered	gi\|2783942509\|gb\|PQ144585.1\|	3229915	g13940	i0	93.662	103.822289156627	284	15	86	1	49	332	295227	294947	Borodinellopsis sp. QY-2024b strain FACHB 3550 chloroplast, complete genome	blastn	34469	422	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlorococcaceae	Borodinellopsis	Borodinellopsis insignis
4593490	4593490	PRJNA784298_P_NODE_12404_length_355_cov_1.092199_g12203_i0	PRJNA784298	12404	355	1.092199	3.87730645	Paradoxia multiseta	249350	Plants	Plants	634	2.6199999999999992e-177	NTclustered	gi\|723457039\|ref\|NC_025540.1\|	249350	g12203	i0	98.873	91.4422535211268	355	4	100	0	1	355	104691	104337	Paradoxia multiseta culture-collection SAG:18.84 chloroplast, complete genome	blastn	32462	634	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Paradoxia	Paradoxia multiseta
5868994	5868994	PRJNA784298_P_NODE_8385_length_435_cov_1.566298_g8184_i0	PRJNA784298	8385	435	1.566298	6.8133963	Chlamydomonas chlamydogama	225041	Plants	Plants	640	7.05e-179	NTclustered	gi\|2386956196\|ref\|NC_068623.1\|	225041	g8184	i0	93.182	146.071264367816	440	22	100	6	1	435	5696	6132	Chlamydomonas chlamydogama strain 11-48b chloroplast, complete genome	blastn	63541	640	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas chlamydogama
6317149	6317149	PRJNA784298_P_NODE_12805_length_349_cov_1.250000_g12604_i0	PRJNA784298	12805	349	1.25	4.3625	Chlorellales	35460	Plants	Plants	601	2.6099999999999998e-167	NTclustered	gi\|723457039\|ref\|NC_025540.1\|	249350	g12604	i0	97.708	129.120343839542	349	8	100	0	1	349	2798	3146	Paradoxia multiseta culture-collection SAG:18.84 chloroplast, complete genome	blastn	45063	601	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Paradoxia	Paradoxia multiseta
6317255	6317255	PRJNA784298_P_NODE_24605_length_248_cov_0.880000_g24404_i0	PRJNA784298	24605	248	0.88	2.1824	Trebouxia	13786	Plants	Plants	436	5.3e-118	NTclustered	gi\|162134351\|gb\|EU123983.1\|	160068	g24404	i0	98.394	84.1693548387097	249	3	100	1	1	248	1687	1935	Trebouxia aggregata strain SAG 219-1d D1 reaction center protein of photosystem II (psbA) and hypothetical protein (orf341) genes, complete cds; and tRNA-His (trnH(gug)) and tRNA-Gly (trnG(ucc)) genes, complete sequence; chloroplast	blastn	20874	436	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia aggregata
8418441	8418441	PRJNA784298_P_NODE_20207_length_274_cov_3.134328_g20006_i0	PRJNA784298	20207	274	3.134328	8.58805872	Tetrabaena socialis	47790	Plants	Plants	440	4.599999999999999e-119	NTclustered	gi\|1042780592\|gb\|KX232643.1\|	47790	g20006	i0	95.62	141.518248175182	274	12	100	0	1	274	23788	23515	Tetrabaena socialis chloroplast	blastn	38776	440	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Tetrabaenaceae	Tetrabaena	Tetrabaena socialis
13967266	13967266	PRJNA784298_P_NODE_8931_length_421_cov_4.701149_g8730_i0	PRJNA784298	8931	421	4.701149	19.79183729	Trebouxiophyceae	75966	Plants	Plants	63.9	1.87e-5	NTclustered	gi\|371782132\|emb\|HE610164.1\|	33092	g8730	i0	95	15.5083135391924	40	2	10	0	364	403	37	76	Koliella longiseta plastid partial 23S rRNA gene, strain SAG 470-1	blastn	6529	63.9	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Prasiolales	Koliellaceae	Koliella	Koliella longiseta
16067838	16067838	PRJNA784298_P_NODE_21453_length_265_cov_2.656250_g21252_i0	PRJNA784298	21453	265	2.65625	7.0390625	Chlamydomonas sp. UWO 241	1653778	Plants	Plants	427	3.44e-115	NTclustered	gi\|1423312327\|gb\|MH590838.1\|	1653778	g21252	i0	95.849	133.652830188679	265	10	100	1	1	265	69779	69516	Chlamydomonas sp. UWO 241 plastid, complete genome	blastn	35418	427	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas sp. UWO 241
19892289	19892289	PRJNA784298_P_NODE_6316_length_504_cov_1.162413_g6116_i0	PRJNA784298	6316	504	1.162413	5.85856152	Borodinellopsis texensis	1148060	Plants	Plants	765	0	NTclustered	gi\|1509777606\|gb\|MG778121.1\|	1148060	g6116	i0	94.071	150.753968253968	506	26	100	3	1	504	245564	245061	Borodinellopsis texensis cell division protein (ftsH), ribosomal protein S8 (rps8), ribosomal protein L5 (rpl5), ribosomal protein L14 (rpl14), and ribosomal protein L16 (rpl16) genes, complete cds; tRNA-Arg (trnR-ACG) gene, complete sequence; hypothetical chloroplast RF1 (ycf1), ribosomal protein S12 (rps12), subunit IX of photosystem I (psaJ), CF0 subunit IV of ATP synthase (atpI), photosystem II reaction center subunit X (psbJ), and P700 apoprotein A1 of photosystem I (psaA) genes, complete cds; exon 2,; tRNA-Gly (trnG-GCC) and tRNA-Met (trnM-CAU) genes, complete sequence; ATP-dependent Clp protease proteolytic subunit (clpP) gene, complete cds; tRNA-Leu (trnL-UAG) gene, complete sequence; photochlorophyllide reductase subunit L (chlL) gene, complete cds; tRNA-Gly (trnG-UCC) and tRNA-Trp (trnW-CCA) genes, complete sequence; photosystem II protein K (psbK) gene, complete cds; tRNA-Cys (trnC-GCA) gene, complete sequence; protochlorophyllide reductase subunit B (chlB), D1 reaction center protein of photosystem II (psbA), ribosomal protein S2 (rps2), and ribosomal protein S18 (rps18) genes, complete cds; exon 3,; tRNA-Lys (trnK-UUU), tRNA-Ser (trnS-GCU), and tRNA-Met (trnM-CAU) genes, complete sequence; beta'' subunit of RNA polymerase (rpoC2), ribosomal protein S3 (rps3), cytochrome b6/f complex subunit V (petG), photosystem II protein L (psbL), photosystem II protein VI (psbF), ATP synthase CF0 C subunit (atpH), ATP synthase CF0 B subunit (atpF), P700 apoprotein A2 of photosystem I (psaB), CF1 alpha subunit of ATP synthase (atpA), and photosystem II protein I (psbI) genes, complete cds; tRNA-Ser (trnS-UGA) gene, complete sequence; ribosomal protein L20 (rpl20) gene, complete cds; ribosomal protein L32 (rpl32) gene, partial cds; tRNA-Val (trnV-UAC), tRNA-Pro (trnP-UGG), and tRNA-His (trnH-GUG) genes, complete sequence; CP43 chlorophyll apoprotein of photosystem II (psbC), hypothetical protein, beta' subunit of RNA polymerase (rpoC1), apocytochrome f of cytochrome b6/f complex (petA), and cytochrome b6/f complex s…	blastn	75980	765	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlorococcaceae	Borodinellopsis	Borodinellopsis texensis
24164827	24164827	PRJNA784298_P_NODE_17439_length_297_cov_1.316964_g17238_i0	PRJNA784298	17439	297	1.316964	3.91138308	Ulvophyceae	33103	Plants	Plants	451	2.33e-122	NTclustered	gi\|2473930131\|ref\|NC_072924.1\|	138667	g17238	i0	94	128.616161616162	300	15	100	2	1	297	176348	176049	Monostroma nitidum chloroplast, complete genome	blastn	38199	451	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulvales	Monostromataceae	Monostroma	Monostroma nitidum

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