metadata: contig_metadata: 6 rows where bioproject = "PRJNA949785" and tax

6 rows where bioproject = "PRJNA949785" 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
12741284	12741284	PRJNA949785_P_NODE_10790_length_314_cov_1.278008_g10593_i0	PRJNA949785	10790	314	1.278008	4.01294512	root	1	Root_unresolved	Root_unresolved	547	3.069999999999999e-151	NTclustered	gi\|1642520538\|ref\|NC_042181.1\|	152631	g10593	i0	98.089	111.15923566879	314	6	100	0	1	314	112644	112331	Coelastrella saipanensis chloroplast, complete genome	blastn	34904	547	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Scenedesmaceae	Coelastrella	Coelastrella saipanensis
17511354	17511354	PRJNA949785_P_NODE_17814_length_244_cov_0.900585_g17617_i0	PRJNA949785	17814	244	0.900585	2.1974274	Volvox carteri	3067	Plants	Plants	52.8	0.022	NTclustered	gi\|302840091\|ref\|XM_002951556.1\|	3068	g17617	i0	100	0.114754098360656	28	0	11	0	208	235	190	163	Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_109131), mRNA	blastn	28	52.8	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Volvox	Volvox carteri
29431836	29431836	PRJNA949785_P_NODE_8629_length_358_cov_2.698246_g8432_i0	PRJNA949785	8629	358	2.698246	9.65972068	Eukaryota	2759	Plants	Plants	78.6	3.26e-14	NR	KAK9811225.1	41462	g8432	i0	36.6	3.80446927374302	112	70	93.9	1	11	346	241	351	KAK9811225.1 hypothetical protein WJX72_000252 [[Myrmecia] bisecta]	diamond	1362	78.6	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
29488502	29488502	PRJNA949785_P_NODE_17750_length_244_cov_1.801170_g17553_i0	PRJNA949785	17750	244	1.80117	4.3948548	Ochlochaete hystrix	262511	Plants	Plants	117	3.24e-29	NR	ACL97364.1	262511	g17553	i0	65.4	2.98770491803279	81	28	99.6	0	244	2	267	347	ACL97364.1 elongation factor-1 alpha-like protein, partial [Ochlochaete hystrix]	diamond	729	117	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Ulvophyceae	Ulvales	Ulvellaceae	Ochlochaete	Ochlochaete hystrix
29488514	29488514	PRJNA949785_P_NODE_7510_length_393_cov_1.278125_g7313_i0	PRJNA949785	7510	393	1.278125	5.02303125	Dunaliella salina	3046	Plants	Plants	85.5	4.01e-17	NR	KAF5837754.1	3046	g7313	i0	53.8	0.610687022900763	80	37	61.1	0	77	316	112	191	KAF5837754.1 hypothetical protein DUNSADRAFT_3897 [Dunaliella salina]	diamond	240	85.5	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Dunaliellaceae	Dunaliella	Dunaliella salina
31549336	31549336	PRJNA949785_P_NODE_10436_length_320_cov_1.858300_g10239_i0	PRJNA949785	10436	320	1.8583	5.94656	Eukaryota	2759	Plants	Plants	120	3.4800000000000003e-29	NR	KXZ52076.1	33097	g10239	i0	70.6	11.146875	85	25	79.7	0	320	66	496	580	KXZ52076.1 hypothetical protein GPECTOR_10g1099 [Gonium pectorale]	diamond	3567	121	0.991735537190083	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Volvocaceae	Gonium	Gonium pectorale

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