metadata: contig_metadata: 8 rows where bioproject = "PRJNA484127" and tax

8 rows where bioproject = "PRJNA484127" 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
8101579	8101579	PRJNA484127_P_NODE_24367_length_273_cov_1.560000_g24218_i0	PRJNA484127	24367	273	1.56	4.2588	Monoraphidium neglectum	145388	Plants	Plants	231	3e-56	NTclustered	gi\|926777793\|ref\|XM_014041917.1\|	145388	g24218	i0	85.398	61.9523809523809	226	29	82	3	20	243	242	19	Monoraphidium neglectum heat shock 70kDa protein 1/8 mRNA	blastn	16913	231	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Sphaeropleales	Selenastraceae	Monoraphidium	Monoraphidium neglectum
16399889	16399889	PRJNA484127_P_NODE_37253_length_244_cov_0.912281_g37104_i0	PRJNA484127	37253	244	0.912281	2.22596564	Eukaryota	2759	Plants	Plants	58.4	4.73e-4	NTclustered	gi\|2082241338\|ref\|XM_043060459.1\|	3055	g37104	i0	100	12.4508196721311	31	0	13	0	77	107	5993	5963	Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g146567v5), mRNA	blastn	3038	58.4	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Chlamydomonadaceae	Chlamydomonas	Chlamydomonas reinhardtii
19574373	19574373	PRJNA484127_P_NODE_29776_length_253_cov_0.866667_g29627_i0	PRJNA484127	29776	253	0.866667	2.19266751	Coccomyxa subellipsoidea	248742	Plants	Plants	158	4.729999999999999e-34	NTclustered	gi\|545356038\|ref\|XM_005643719.1\|	574566	g29627	i0	78.125	3.71541501976285	256	50	100	4	1	253	886	1138	Coccomyxa subellipsoidea C-169 nuclear RNA helicase-like protein Bat1 mRNA	blastn	940	158	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae		Coccomyxaceae	Coccomyxa	Coccomyxa subellipsoidea
26601155	26601155	PRJNA484127_P_NODE_10881_length_370_cov_2.572391_g10732_i0	PRJNA484127	10881	370	2.572391	9.5178467	Helicosporidium sp. ATCC 5	1907511	Plants	Plants	151	8.59e-44	NR	KDD76381.1	1291522	g10732	i0	65.4	1.71081081081081	104	36	84.3	0	2	313	74	177	KDD76381.1 hypothetical protein H632_c248p2 [Helicosporidium sp. ATCC 50920]	diamond	633	151	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Helicosporidium	Helicosporidium sp. ATCC 50920
30408646	30408646	PRJNA484127_P_NODE_40473_length_227_cov_2.025974_g40324_i0	PRJNA484127	40473	227	2.025974	4.59896098	Eukaryota	2759	Plants	Plants	70.5	4.74e-13	NR	KAK9804915.1	41462	g40324	i0	64.2	2.8942731277533	53	19	70	0	2	160	101	153	KAK9804915.1 hypothetical protein WJX72_011827 [[Myrmecia] bisecta]	diamond	657	70.9	0.994358251057828	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Trebouxiales	Trebouxiaceae	Myrmecia	[Myrmecia] bisecta
30914027	30914027	PRJNA484127_P_NODE_30434_length_252_cov_0.871508_g30285_i0	PRJNA484127	30434	252	0.871508	2.19620016	root	1	Root_unresolved	Root_unresolved	50.4	7.67e-5	NR	KAF5830871.1	3046	g30285	i0	38.6	10.4761904761905	70	41	83.3	1	243	34	92	159	KAF5830871.1 hypothetical protein DUNSADRAFT_13931 [Dunaliella salina]	diamond	2640	50.8	0.992125984251969	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Chlorophyceae	Chlamydomonadales	Dunaliellaceae	Dunaliella	Dunaliella salina
31261482	31261482	PRJNA484127_P_NODE_25795_length_267_cov_1.567010_g25646_i0	PRJNA484127	25795	267	1.56701	4.1839167	Chlorellaceae	35461	Plants	Plants	91.7	3.09e-19	NR	KAK2078008.1	3111	g25646	i0	54	4.8876404494382	87	37	97.8	1	267	7	123	206	KAK2078008.1 T-complex protein 1 subunit eta [Prototheca wickerhamii]	diamond	1305	92	0.996739130434783	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Prototheca	Prototheca wickerhamii
31276847	31276847	PRJNA484127_P_NODE_21795_length_285_cov_1.669811_g21646_i0	PRJNA484127	21795	285	1.669811	4.75896135	Auxenochlorella protothecoides	3075	Plants	Plants	45.1	0.00938	NR	XP_011400040.1	3075	g21646	i0	45.3	1.11578947368421	53	28	55.8	1	119	277	16	67	XP_011400040.1 Phospholipase B-like 1 [Auxenochlorella protothecoides]	diamond	318	45.1	1	Eukaryota	core chlorophytes	Viridiplantae	Chlorophyta	Trebouxiophyceae	Chlorellales	Chlorellaceae	Auxenochlorella	Auxenochlorella protothecoides

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