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

12 rows where analysis = "blastn", bioproject = "PRJEB41113" 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
59116	59116	PRJEB41113_S_NODE_1481_length_241_cov_5.784314_g1472_i0	PRJEB41113	1481	241	5.784314	13.94019674	Trebouxia aggregata	160068	Plants	Plants	422	1.44e-113	NTclustered	gi\|162134383\|gb\|EU123994.1\|	160068	g1472	i0	98.333	13.1825726141079	240	4	99	0	2	241	6238	6477	Trebouxia aggregata strain SAG 219-1d tRNA-Trp (trnW(cca)) gene, complete sequence; and probable transport protein (cysA) and beta subunit of acetyl-CoA carboxylase (accD) genes, complete cds; chloroplast	blastn	3177	422	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia aggregata
59127	59127	PRJEB41113_S_NODE_2721_length_212_cov_1.982857_g2712_i0	PRJEB41113	2721	212	1.982857	4.20365684	Sykidion marinum	44573	Plants	Plants	285	1.69e-72	NTclustered	gi\|1197510977\|ref\|NC_034710.1\|	44573	g2712	i0	91.429	1.48584905660377	210	15	98	3	3	210	98034	97826	Pseudoneochloris marina culture UTEX:1445 chloroplast, complete genome	blastn	315	285	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Sykidiales	Sykidiacaeae	Sykidion	Sykidion marinum
2265103	2265103	PRJEB41113_S_NODE_12962_length_153_cov_2.637931_g12953_i0	PRJEB41113	12962	153	2.637931	4.03603443	Jaagichlorella	2304164	Plants	Plants	283	4.0799999999999995e-72	NTclustered	gi\|694226588\|gb\|KM116462.1\|	31301	g12953	i0	100	98.5490196078431	153	0	100	0	1	153	2699	2547	Heterochlorella luteoviridis strain SAG 2213 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence	blastn	15078	283	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Watanabeales	Watanabeaceae	Jaagichlorella	Jaagichlorella luteoviridis
5161369	5161369	PRJEB41113_S_NODE_10345_length_159_cov_1.573770_g10336_i0	PRJEB41113	10345	159	1.57377	2.5022943	Borodinellopsis texensis	1148060	Plants	Plants	289	9.22e-74	NTclustered	gi\|1509777606\|gb\|MG778121.1\|	1148060	g10336	i0	99.375	47.1069182389937	160	0	100	1	1	159	248544	248385	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	7490	289	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlorococcaceae	Borodinellopsis	Borodinellopsis texensis
5161395	5161395	PRJEB41113_S_NODE_14585_length_151_cov_2.561404_g14576_i0	PRJEB41113	14585	151	2.561404	3.86772004	Coccomyxa subellipsoidea	248742	Plants	Plants	58.4	2.65e-4	NTclustered	gi\|1870286304\|gb\|AC279733.1\|	574566	g14576	i0	92.5	0.754966887417219	40	3	26	0	112	151	6030	5991	Coccomyxa subellipsoidea C-169 clone FAHX245-O08, complete sequence	blastn	114	58.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
8986226	8986226	PRJEB41113_S_NODE_15308_length_150_cov_2.522124_g15299_i0	PRJEB41113	15308	150	2.522124	3.783186	Stichococcus bacillaris	37433	Plants	Plants	278	1.85e-70	NTclustered	gi\|723457333\|ref\|NC_025527.1\|	37433	g15299	i0	100	1	150	0	100	0	1	150	76582	76433	Stichococcus bacillaris culture-collection UTEX:176 chloroplast, complete genome	blastn	150	278	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Prasiolales	Stichococcaceae	Stichococcus	Stichococcus bacillaris
10261980	10261980	PRJEB41113_S_NODE_6509_length_177_cov_3.928571_g6500_i0	PRJEB41113	6509	177	3.928571	6.95357067	Ulva compressa	63659	Plants	Plants	156	1.11e-33	NTclustered	gi\|2043344467\|gb\|MW353781.1\|	63659	g6500	i0	84.472	103.378531073446	161	22	91	3	6	166	69521	69364	Ulva compressa isolate Uco3 plastid, complete genome	blastn	18298	156	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulvales	Ulvaceae	Ulva	Ulva compressa
11537293	11537293	PRJEB41113_S_NODE_12170_length_154_cov_8.666667_g12161_i0	PRJEB41113	12170	154	8.666667	13.34666718	Chloroidium sp. KL-2023a	3031248	Plants	Plants	224	2.5299999999999994e-54	NTclustered	gi\|2450595352\|gb\|ON986219.1\|	3031248	g12161	i0	96.992	8.7012987012987	133	4	86	0	3	135	219933	220065	Chloroidium sp. KL-2023a clone 2023 chloroplast, complete genome	blastn	1340	224	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Watanabeales	Watanabeaceae	Chloroidium	Chloroidium sp. KL-2023a
20459946	20459946	PRJEB41113_S_NODE_11697_length_155_cov_4.220339_g11688_i0	PRJEB41113	11697	155	4.220339	6.54152545	Pseudochlorella signiensis	173497	Plants	Plants	226	7.1e-55	NTclustered	gi\|2724824453\|gb\|PP746560.1\|	173497	g11688	i0	95.714	5.89677419354839	140	6	90	0	16	155	30083	29944	Pseudochlorella signiensis culture SAG:7.90 mitochondrion, complete genome	blastn	914	226	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Pseudochlorella	Pseudochlorella signiensis
20459970	20459970	PRJEB41113_S_NODE_2057_length_225_cov_4.500000_g2048_i0	PRJEB41113	2057	225	4.5	10.125	Diplosphaera sundellii	3135960	Plants	Plants	174	4.09e-39	NTclustered	gi\|2878821371\|gb\|PQ563290.1\|	3135960	g2048	i0	89.286	54.92	140	13	62	2	1	139	8174	8312	Diplosphaera sundellii mitochondrion, complete genome	blastn	12357	174	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Prasiolales	Stichococcaceae	Diplosphaera	Diplosphaera sundellii
22666756	22666756	PRJEB41113_S_NODE_5318_length_185_cov_3.736486_g5309_i0	PRJEB41113	5318	185	3.736486	6.9124991	Trebouxia	13786	Plants	Plants	289	1.11e-73	NTclustered	gi\|1750939486\|gb\|MH917293.1\|	1825957	g5309	i0	100	90.3297297297297	156	0	84	0	19	174	19304	19149	Trebouxia sp. TR9 mitochondrion, complete genome	blastn	16711	289	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Trebouxia	Trebouxia lynnae
23011149	23011149	PRJEB41113_S_NODE_959_length_264_cov_8.136564_g950_i0	PRJEB41113	959	264	8.136564	21.48052896	Nannochloris normandinae	926285	Plants	Plants	453	5.66e-123	NTclustered	gi\|922575245\|gb\|JQ921007.1\|	926285	g950	i0	97.736	96.7537878787879	265	3	99	3	2	264	565	828	Nannochloris normandinae strain SAG 9.82 23S large subunit ribosomal RNA gene, partial sequence; chloroplast	blastn	25543	453	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Nannochloris	Nannochloris normandinae

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