metadata: contig_metadata: 13 rows where bioproject = "PRJNA1218816", tax_clade = "Sar" and tax

13 rows where bioproject = "PRJNA1218816", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

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
1046205	1046205	PRJNA1218816_P_NODE_13521_length_652_cov_7.386874_g13101_i0	PRJNA1218816	13521	652	7.386874	48.16241848	Thalassiosira	35127	SAR_Eukaryotes	SAR_Eukaryotes	1171	0	NTclustered	gi\|2862228846\|gb\|PQ645480.1\|	1048533	g13101	i0	99.08	100.19018404908	652	6	100	0	1	652	3522	4173	Thalassiosira bioculata isolate AGSB0307 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	65324	1171	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira bioculata
2884437	2884437	PRJNA1218816_P_NODE_58023_length_246_cov_1.393064_g57590_i0	PRJNA1218816	58023	246	1.393064	3.42693744	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	138	2.67e-36	NR	GKY98155.1	2872254	g57590	i0	79	0.98780487804878	81	17	98.8	0	245	3	148	228	GKY98155.1 Inositol monophosphatase 2 [Mayamaea pseudoterrestris]	diamond	243	138	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
4874386	4874386	PRJNA1218816_P_NODE_45824_length_280_cov_1.487923_g45391_i0	PRJNA1218816	45824	280	1.487923	4.1661844	Thalassiosirales	33847	SAR_Eukaryotes	SAR_Eukaryotes	433	7.89e-117	NTclustered	gi\|74325165\|ref\|NC_007405.1\|	35128	g45391	i0	95.255	99.4571428571429	274	12	98	1	7	280	12492	12220	Thalassiosira pseudonana mitochondrion, complete genome	blastn	27848	435	0.995402298850575	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira pseudonana
6711384	6711384	PRJNA1218816_P_NODE_64326_length_210_cov_5.211679_g63893_i0	PRJNA1218816	64326	210	5.211679	10.9445259	Cyclotella cryptica	29204	SAR_Eukaryotes	SAR_Eukaryotes	292	9.97e-75	NTclustered	gi\|1169296927\|gb\|KY364697.1\|	29204	g63893	i0	91.905	93.6857142857143	210	15	100	2	1	210	5607	5814	Cyclotella cryptica 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	19674	292	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
7987003	7987003	PRJNA1218816_P_NODE_8047_length_953_cov_1.629545_g7710_i0	PRJNA1218816	8047	953	1.629545	15.52956385	Phaeodactylum tricornutum CCAP 1	2850	SAR_Eukaryotes	SAR_Eukaryotes	350	2.039999999999999e-118	NR	XP_002181180.1	556484	g7710	i0	79.2	6.32423924449108	212	44	66.7	0	927	292	6	217	XP_002181180.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1]	diamond	6027	350	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
8699265	8699265	PRJNA1218816_P_NODE_32867_length_346_cov_2.853480_g32434_i0	PRJNA1218816	32867	346	2.85348	9.8730408	Thalassiosira	35127	SAR_Eukaryotes	SAR_Eukaryotes	634	2.5599999999999996e-177	NTclustered	gi\|675821511\|dbj\|AB827536.1\|	137771	g32434	i0	99.711	100.014450867052	346	1	100	0	1	346	452	107	Uncultured diatom gene for 18S rRNA, partial sequence, clone: HP18D-93	blastn	34605	640	0.990625	Eukaryota	Sar	Bacillariophyta					uncultured diatom
20734662	20734662	PRJNA1218816_P_NODE_15397_length_595_cov_2.632184_g14972_i0	PRJNA1218816	15397	595	2.632184	15.6614948	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	313	2.45e-80	NTclustered	gi\|657012367\|gb\|KF302531.1\|	2850	g14972	i0	83.832	25.236974789916	334	48	56	6	1	331	346	16	Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds	blastn	15016	313	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
20734812	20734812	PRJNA1218816_P_NODE_38697_length_312_cov_1.196653_g38264_i0	PRJNA1218816	38697	312	1.196653	3.73355736	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	152	3.86e-40	NR	CAB9501098.1	568900	g38264	i0	76	1	104	24	100	1	1	312	335	437	CAB9501098.1 NAD(P) transhydrogenase [Seminavis robusta]	diamond	312	152	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
22723178	22723178	PRJNA1218816_P_NODE_45038_length_283_cov_1.466667_g44605_i0	PRJNA1218816	45038	283	1.466667	4.15066761	Chaetoceros tenuissimus	426638	SAR_Eukaryotes	SAR_Eukaryotes	120	1.6699999999999998e-32	NR	GFH58943.1	426638	g44605	i0	74.7	0.92226148409894	87	22	92.2	0	21	281	25	111	GFH58943.1 hypothetical protein CTEN210_15419 [Chaetoceros tenuissimus]	diamond	261	120	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
23285816	23285816	PRJNA1218816_P_NODE_62459_length_241_cov_1.375000_g62026_i0	PRJNA1218816	62459	241	1.375	3.31375	Thalassiosira pseudonana	35128	SAR_Eukaryotes	SAR_Eukaryotes	165	2.67e-36	NTclustered	gi\|224002558\|ref\|XM_002290915.1\|	296543	g62026	i0	80.444	73.3983402489627	225	36	92	5	1	221	166	386	Thalassiosira pseudonana CCMP1335 hypothetical protein (AHC3), mRNA	blastn	17689	165	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira pseudonana
23998396	23998396	PRJNA1218816_P_NODE_59179_length_245_cov_0.895349_g58746_i0	PRJNA1218816	59179	245	0.895349	2.19360505	Thalassiosira	35127	SAR_Eukaryotes	SAR_Eukaryotes	453	5.1900000000000006e-123	NTclustered	gi\|98990570\|gb\|DQ514795.1\|	160265	g58746	i0	100	99.6979591836735	245	0	100	0	1	245	26	270	Thalassiosira antarctica strain CCMP982 ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit (rbcL) gene, partial cds; chloroplast	blastn	24426	453	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira antarctica
27862290	27862290	PRJNA1218816_P_NODE_52345_length_255_cov_2.263736_g51912_i0	PRJNA1218816	52345	255	2.263736	5.7725268	Cyclostephanos tholiformis	382380	SAR_Eukaryotes	SAR_Eukaryotes	110	8.84e-26	NR	KAL3808413.1	382380	g51912	i0	65.5	1.97647058823529	84	29	98.8	0	255	4	626	709	KAL3808413.1 hypothetical protein ACHAXA_001350 [Cyclostephanos tholiformis]	diamond	504	110	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclostephanos	Cyclostephanos tholiformis
29883343	29883343	PRJNA1218816_P_NODE_49631_length_265_cov_1.526042_g49198_i0	PRJNA1218816	49631	265	1.526042	4.0440113	Skeletonema marinoi	267567	SAR_Eukaryotes	SAR_Eukaryotes	165	4.7e-47	NR	KAK1739474.1	267567	g49198	i0	85.2	8.92075471698113	88	13	99.6	0	264	1	246	333	KAK1739474.1 fucoxanthin-chlorophyll a-c binding protein [Skeletonema marinoi]	diamond	2364	165	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Skeletonemataceae	Skeletonema	Skeletonema marinoi

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