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

8 rows where bioproject = "PRJNA575566" 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
4387679	4387679	PRJNA575566_P_NODE_5324_length_454_cov_1.862595_g5127_i0	PRJNA575566	5324	454	1.862595	8.4561813	Skeletonema menzelii	216823	SAR_Eukaryotes	SAR_Eukaryotes	172	3.24e-38	NTclustered	gi\|2739942921\|dbj\|LC814781.1\|	216823	g5127	i0	82.381	39.057268722467	210	26	44	10	255	454	32430	32222	Skeletonema menzelii NIES-2842 mitochondrial DNA, complete genome	blastn	17732	172	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Skeletonemataceae	Skeletonema	Skeletonema menzelii
6240392	6240392	PRJNA575566_P_NODE_5685_length_440_cov_2.226913_g5488_i0	PRJNA575566	5685	440	2.226913	9.7984172	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	204	1.39e-57	NR	KAG7341642.1	303405	g5488	i0	69.4	2.78181818181818	134	39	90	1	2	397	255	388	KAG7341642.1 carbamoyl-phosphate synthase large subunit [Nitzschia inconspicua]	diamond	1224	206	0.990291262135922	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia inconspicua
8212964	8212964	PRJNA575566_P_NODE_11307_length_311_cov_2.288000_g11110_i0	PRJNA575566	11307	311	2.288	7.11568	Psammoneis japonica	517775	SAR_Eukaryotes	SAR_Eukaryotes	130	1.31e-25	NTclustered	gi\|1418586704\|ref\|NC_037989.1\|	517775	g11110	i0	87.5	0.360128617363344	112	14	36	0	197	308	24361	24472	Psammoneis japonica mitochondrion, complete genome	blastn	112	130	1	Eukaryota	Sar	Bacillariophyta	Mediophyceae	Triceratiales	Plagiogrammaceae	Psammoneis	Psammoneis japonica
12039176	12039176	PRJNA575566_P_NODE_23750_length_211_cov_1.280000_g23553_i0	PRJNA575566	23750	211	1.28	2.7008	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	180	8.15e-41	NTclustered	gi\|657012367\|gb\|KF302531.1\|	2850	g23553	i0	83.938	23.4644549763033	193	25	90	6	22	211	16	205	Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds	blastn	4951	180	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
18412080	18412080	PRJNA575566_P_NODE_27035_length_205_cov_0.888889_g26838_i0	PRJNA575566	27035	205	0.888889	1.82222245	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	123	6.830000000000001e-33	NR	KAL3780735.1	29204	g26838	i0	84.8	23.209756097561	66	10	96.6	0	3	200	114	179	KAL3780735.1 hypothetical protein HJC23_001017 [Cyclotella cryptica]	diamond	4758	124	0.991935483870968	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Cyclotella	Cyclotella cryptica
20962261	20962261	PRJNA575566_P_NODE_22677_length_217_cov_1.807692_g22480_i0	PRJNA575566	22677	217	1.807692	3.92269164	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	123	1.0599999999999998e-31	NR	YP_005090330.1	2850	g22480	i0	75	17.9170506912442	72	18	99.5	0	217	2	315	386	YP_005090330.1 NADH dehydrogenase subunit 7 [Phaeodactylum tricornutum]	diamond	3888	124	0.991935483870968	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
27047961	27047961	PRJNA575566_P_NODE_27662_length_204_cov_0.895105_g27465_i0	PRJNA575566	27662	204	0.895105	1.8260142	Skeletonema marinoi	267567	SAR_Eukaryotes	SAR_Eukaryotes	53.1	9.69e-7	NR	KAK1745333.1	267567	g27465	i0	48.4	0.911764705882353	62	32	91.2	0	203	18	64	125	KAK1745333.1 60S ribosomal protein L14 [Skeletonema marinoi]	diamond	186	53.1	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Skeletonemataceae	Skeletonema	Skeletonema marinoi
32007800	32007800	PRJNA575566_P_NODE_26738_length_205_cov_1.354167_g26541_i0	PRJNA575566	26738	205	1.354167	2.77604235	Thalassiosira oceanica	159749	SAR_Eukaryotes	SAR_Eukaryotes	72	6.29e-14	NR	EJK66048.1	159749	g26541	i0	58.1	1.81463414634146	62	26	90.7	0	7	192	58	119	EJK66048.1 hypothetical protein THAOC_13056 [Thalassiosira oceanica]	diamond	372	72	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira oceanica

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