metadata: contig_metadata: 5 rows where bioproject = "PRJNA734313" and tax

5 rows where bioproject = "PRJNA734313" 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
16019233	16019233	PRJNA734313_S_NODE_26113_length_181_cov_1.776119_g26000_i0	PRJNA734313	26113	181	1.776119	3.21477539	Remanella sp. 1 BS-2022	2930476	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.001	NTclustered	gi\|2261269021\|emb\|OX095846.1\|	2930476	g26000	i0	100	0.635359116022099	30	0	17	0	152	181	41	12	Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+)	blastn	115	56.5	1	Eukaryota	Sar	Ciliophora	Karyorelictea	Loxodida	Loxodidae	Remanella	Remanella sp. 1 BS-2022
21119278	21119278	PRJNA734313_S_NODE_14797_length_244_cov_6.807107_g14684_i0	PRJNA734313	14797	244	6.807107	16.60934108	Phalacroma oxytoxoides	447216	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.022	NTclustered	gi\|2742502725\|gb\|PP905714.1\|	447216	g14684	i0	100	0.229508196721311	28	0	11	0	1	28	1198	1225	Phalacroma oxytoxoides isolate PhaFC3 small subunit ribosomal RNA gene, partial sequence	blastn	56	52.8	1	Eukaryota	Sar		Dinophyceae	Dinophysales	Dinophysaceae	Phalacroma	Phalacroma oxytoxoides
27188880	27188880	PRJNA734313_S_NODE_15722_length_237_cov_1.752632_g15609_i0	PRJNA734313	15722	237	1.752632	4.15373784	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	50.8	4.92e-5	NR	KAL4435527.1	5901	g15609	i0	37.7	3.8987341772151902	61	38	77.2	0	236	54	878	938	KAL4435527.1 hypothetical protein ABPG74_020303 [Tetrahymena malaccensis]	diamond	924	51.2	0.9921875	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida	Tetrahymenidae	Tetrahymena	Tetrahymena malaccensis
29546925	29546925	PRJNA734313_S_NODE_22150_length_198_cov_1.331126_g22037_i0	PRJNA734313	22150	198	1.331126	2.63562948	Aureococcus anophagefferens	44056	SAR_Eukaryotes	SAR_Eukaryotes	75.9	1.02e-14	NR	XP_009032113.1	44056	g22037	i0	59.1	3	66	25	97	2	197	6	175	240	XP_009032113.1 hypothetical protein AURANDRAFT_5643, partial [Aureococcus anophagefferens]	diamond	594	75.9	1	Eukaryota	Sar		Pelagophyceae	Pelagomonadales	Pelagomonadaceae	Aureococcus	Aureococcus anophagefferens
31126280	31126280	PRJNA734313_S_NODE_5275_length_387_cov_2.541176_g5163_i0	PRJNA734313	5275	387	2.541176	9.83435112	Ichthyophthirius multifiliis	5932	SAR_Eukaryotes	SAR_Eukaryotes	46.6	0.0082	NR	XP_004035747.1	5932	g5163	i0	54.3	0.550387596899225	35	16	27.1	0	385	281	507	541	XP_004035747.1 spfh domain band 7 family protein [Ichthyophthirius multifiliis]	diamond	213	46.6	1	Eukaryota	Sar	Ciliophora	Oligohymenophorea	Hymenostomatida		Ichthyophthirius	Ichthyophthirius multifiliis

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