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

6 rows where bioproject = "PRJNA886442" and tax_clade = "Sar"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
6345448	6345448	PRJNA886442_P_NODE_12985_length_247_cov_0.896552_g12821_i0	PRJNA886442	12985	247	0.896552	2.21448344	root	1	Root_unresolved	Root_unresolved	121	6.03e-23	NTclustered	gi\|238617605\|gb\|FJ973380.1\|	45107	g12821	i0	92.771	1.34412955465587	83	6	34	0	163	245	2276	2194	Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence	blastn	332	121	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita globosa
16544036	16544036	PRJNA886442_P_NODE_8733_length_273_cov_1.035000_g8569_i0	PRJNA886442	8733	273	1.035	2.82555	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	58.4	5.39e-4	NTclustered	gi\|915002339\|ref\|XM_013393301.1\|	5801	g8569	i0	92.5	1.50549450549451	40	3	15	0	86	125	1149	1110	Eimeria acervulina hypothetical protein partial mRNA	blastn	411	58.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
17440163	17440163	PRJNA886442_P_NODE_8294_length_278_cov_2.907317_g8130_i0	PRJNA886442	8294	278	2.907317	8.08234126	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	152	2.45e-32	NTclustered	gi\|2795041697\|ref\|XM_067930728.1\|	4785	g8130	i0	82.558	3.93525179856115	172	30	62	0	40	211	19	190	Phytophthora cinnamomi 60S ribosomal protein L27a (IUM83_06510), partial mRNA	blastn	1094	152	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
28863316	28863316	PRJNA886442_P_NODE_9748_length_259_cov_1.446237_g9584_i0	PRJNA886442	9748	259	1.446237	3.74575383	Tetrahymenidae	291294	SAR_Eukaryotes	SAR_Eukaryotes	65.9	3.02e-10	NR	XP_004024223.1	5932	g9584	i0	44	1.93436293436293	84	47	97.3	0	257	6	3	86	XP_004024223.1 hypothetical protein IMG5_197540 [Ichthyophthirius multifiliis]	diamond	501	65.9	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis
29203006	29203006	PRJNA886442_P_NODE_9289_length_265_cov_1.218750_g9125_i0	PRJNA886442	9289	265	1.21875	3.2296875	Symbiodinium sp. CCMP2592	631055	SAR_Eukaryotes	SAR_Eukaryotes	45.4	0.00528	NR	CAE7343670.1	631055	g9125	i0	35.5	0.70188679245283	62	25	53.2	1	29	169	238	299	CAE7343670.1 tig, partial [Symbiodinium sp. CCMP2592]	diamond	186	45.4	1	Eukaryota	Sar		Dinophyceae	Suessiales	Symbiodiniaceae	Symbiodinium	Symbiodinium sp. CCMP2592
32237182	32237182	PRJNA886442_P_NODE_5498_length_327_cov_0.996063_g5334_i0	PRJNA886442	5498	327	0.996063	3.25712601	Stephanodiscus triporus	2934178	SAR_Eukaryotes	SAR_Eukaryotes	51.6	7.56e-5	NR	KAL3786910.1	2934178	g5334	i0	57.8	0.412844036697248	45	18	40.4	1	195	326	205	249	KAL3786910.1 hypothetical protein ACHAW5_011289 [Stephanodiscus triporus]	diamond	135	51.6	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Stephanodiscus	Stephanodiscus triporus

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