metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA917598" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA917598" 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
896131	896131	PRJNA917598_P_NODE_47701_length_332_cov_1.378378_g46757_i0	PRJNA917598	47701	332	1.378378	4.57621496	Phaeodactylum tricornutum CCAP 1	2850	SAR_Eukaryotes	SAR_Eukaryotes	77.4	2.9e-15	NR	XP_002178631.1	556484	g46757	i0	46	1.57228915662651	100	52	90.4	1	330	31	47	144	XP_002178631.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1]	diamond	522	77.4	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
7629849	7629849	PRJNA917598_P_NODE_92166_length_243_cov_0.905882_g91222_i0	PRJNA917598	92166	243	0.905882	2.20129326	Bacillariophyceae	33849	SAR_Eukaryotes	SAR_Eukaryotes	85.1	3.84e-17	NR	KAG7366422.1	303405	g91222	i0	75.5	9.22222222222222	53	13	65.4	0	82	240	94	146	KAG7366422.1 NAD-dependent epimerase/dehydratase [Nitzschia inconspicua]	diamond	2241	85.1	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
8550140	8550140	PRJNA917598_P_NODE_91027_length_244_cov_0.900585_g90083_i0	PRJNA917598	91027	244	0.900585	2.1974274	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	135	7.12e-38	NR	KAI2502075.1	210448	g90083	i0	74.1	7.9672131147541	81	21	99.6	0	1	243	51	131	KAI2502075.1 ribosomal uS7-like protein [Fragilaria crotonensis]	diamond	1944	135	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Fragilariales	Fragilariaceae	Fragilaria	Fragilaria crotonensis
26771479	26771479	PRJNA917598_P_NODE_96101_length_241_cov_0.916667_g95157_i0	PRJNA917598	96101	241	0.916667	2.20916747	Phaeodactylum tricornutum CCAP 1	2850	SAR_Eukaryotes	SAR_Eukaryotes	78.6	1.9e-16	NR	XP_002186290.1	556484	g95157	i0	61.9	0.784232365145228	63	24	78.4	0	49	237	4	66	XP_002186290.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1]	diamond	189	78.6	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
26936898	26936898	PRJNA917598_P_NODE_71042_length_270_cov_1.172589_g70098_i0	PRJNA917598	71042	270	1.172589	3.1659903	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	95.1	3.35e-22	NR	GFH59293.1	426638	g70098	i0	54.8	4.68888888888889	84	35	93.3	1	14	265	1	81	GFH59293.1 RL9, ribosomal protein 9 [Chaetoceros tenuissimus]	diamond	1266	95.9	0.991657977059437	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Chaetocerotaceae	Chaetoceros	Chaetoceros tenuissimus
30126511	30126511	PRJNA917598_P_NODE_68472_length_275_cov_1.485149_g67528_i0	PRJNA917598	68472	275	1.485149	4.08415975	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	85.1	6.9e-17	NR	KAK1737196.1	267567	g67528	i0	46.3	2.57454545454545	80	39	82.9	1	274	47	321	400	KAK1737196.1 U2 snRNP-associated SURP motif-containing protein [Skeletonema marinoi]	diamond	708	85.1	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Skeletonemataceae	Skeletonema	Skeletonema marinoi
30341100	30341100	PRJNA917598_P_NODE_37272_length_376_cov_1.524752_g36328_i0	PRJNA917598	37272	376	1.524752	5.73306752	Seminavis robusta	568900	SAR_Eukaryotes	SAR_Eukaryotes	105	6.54e-26	NR	CAB9514451.1	568900	g36328	i0	43.3	0.957446808510638	120	67	94.9	1	357	1	5	124	CAB9514451.1 EFh [Seminavis robusta]	diamond	360	105	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Seminavis	Seminavis robusta
32086675	32086675	PRJNA917598_P_NODE_88158_length_246_cov_0.890173_g87214_i0	PRJNA917598	88158	246	0.890173	2.18982558	Coscinodiscophyceae	33836	SAR_Eukaryotes	SAR_Eukaryotes	115	7.5599999999999995e-28	NR	KAL3768771.1	259834	g87214	i0	69.1	4.96341463414634	81	25	98.8	0	243	1	1267	1347	KAL3768771.1 hypothetical protein ACHAWU_006872 [Discostella pseudostelligera]	diamond	1221	116	0.991379310344828	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Discostella	Discostella pseudostelligera
32174509	32174509	PRJNA917598_P_NODE_66038_length_280_cov_1.115942_g65094_i0	PRJNA917598	66038	280	1.115942	3.1246376	Ulnaria acus	1436140	SAR_Eukaryotes	SAR_Eukaryotes	43.1	0.0148	NR	YP_003359455.1	1436140	g65094	i0	33.8	0.825	77	36	66.4	1	232	47	49	125	YP_003359455.1 ribosomal protein S8 [Ulnaria acus]	diamond	231	43.1	1	Eukaryota	Sar	Bacillariophyta	Fragilariophyceae	Licmophorales	Ulnariaceae	Ulnaria	Ulnaria acus
32876136	32876136	PRJNA917598_P_NODE_88720_length_245_cov_1.563953_g87776_i0	PRJNA917598	88720	245	1.563953	3.83168485	Cylindrotheca	2852	SAR_Eukaryotes	SAR_Eukaryotes	63.2	2.46e-9	NR	CAJ1909979.1	2856	g87776	i0	54.7	6.53877551020408	53	24	64.9	0	2	160	383	435	CAJ1909979.1 unnamed protein product [Cylindrotheca closterium]	diamond	1602	63.5	0.995275590551181	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Cylindrotheca	Cylindrotheca closterium

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