metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1195374" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1195374" 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
2871852	2871852	PRJNA1195374_P_NODE_14423_length_593_cov_13.496154_g14085_i0	PRJNA1195374	14423	593	13.496154	80.03219322	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	263	2.49e-65	NTclustered	gi\|657012369\|gb\|KF302532.1\|	2850	g14085	i0	88.479	0.365935919055649	217	25	37	0	267	483	226	10	Phaeodactylum tricornutum clone C80 40S ribosomal protein mRNA, complete cds	blastn	217	263	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
5425286	5425286	PRJNA1195374_P_NODE_68185_length_258_cov_1.248649_g67841_i0	PRJNA1195374	68185	258	1.248649	3.22151442	Attheya longicornis	451786	SAR_Eukaryotes	SAR_Eukaryotes	202	2.1999999999999997e-47	NTclustered	gi\|2046217437\|gb\|MW729336.1\|	451786	g67841	i0	84.112	69.3720930232558	214	29	82	5	9	220	38819	38609	Attheya longicornis mitochondrion, complete genome	blastn	17898	202	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Chaetocerotales	Attheyaceae	Attheya	Attheya longicornis
10524865	10524865	PRJNA1195374_P_NODE_19889_length_508_cov_2.298851_g19546_i0	PRJNA1195374	19889	508	2.298851	11.67816308	Nitzschia traheaformis	1881117	SAR_Eukaryotes	SAR_Eukaryotes	87.9	1.36e-12	NTclustered	gi\|2073953246\|gb\|MW849269.1\|	1881117	g19546	i0	77.515	1.16929133858268	169	22	33	7	342	508	46645	46491	Nitzschia traheaformis isolate Qingdao in China mitochondrion, complete genome	blastn	594	87.9	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Bacillariales	Bacillariaceae	Nitzschia	Nitzschia traheaformis
10525845	10525845	PRJNA1195374_P_NODE_68769_length_256_cov_1.568306_g68425_i0	PRJNA1195374	68769	256	1.568306	4.01486336	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.023	NTclustered	gi\|219114784\|ref\|XM_002178152.1\|	556484	g68425	i0	100	0.109375	28	0	11	0	1	28	277	250	Phaeodactylum tricornutum CCAP 1055/1 predicted protein partial mRNA	blastn	28	52.8	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
11800415	11800415	PRJNA1195374_P_NODE_5550_length_893_cov_14.629268_g5280_i0	PRJNA1195374	5550	893	14.629268	130.63936324	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	438	5.9199999999999985e-118	NTclustered	gi\|657012367\|gb\|KF302531.1\|	2850	g5280	i0	88.462	57.2351623740202	364	40	41	2	282	644	385	23	Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds	blastn	51111	438	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
14350074	14350074	PRJNA1195374_P_NODE_12912_length_624_cov_4.226860_g12576_i0	PRJNA1195374	12912	624	4.22686	26.3756064	Thalassiosira pseudonana	35128	SAR_Eukaryotes	SAR_Eukaryotes	326	3.3e-84	NTclustered	gi\|224004779\|ref\|XM_002296005.1\|	296543	g12576	i0	80.796	64.9791666666667	427	72	68	10	202	623	1441	1020	Thalassiosira pseudonana CCMP1335 F-type H-ATPase beta subunit mRNA	blastn	40547	326	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira pseudonana
20723257	20723257	PRJNA1195374_P_NODE_5617_length_889_cov_1.692402_g5346_i0	PRJNA1195374	5617	889	1.692402	15.04545378	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	512	3.42e-140	NTclustered	gi\|657012566\|gb\|KF302620.1\|	2850	g5346	i0	87.927	69.5568053993251	439	48	49	5	1	437	435	870	Phaeodactylum tricornutum clone C821 hypothetical protein mRNA, complete cds	blastn	61836	512	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
23273195	23273195	PRJNA1195374_P_NODE_12119_length_642_cov_4.520211_g11784_i0	PRJNA1195374	12119	642	4.520211	29.01975462	Thalassiosira pseudonana	35128	SAR_Eukaryotes	SAR_Eukaryotes	296	2.67e-75	NTclustered	gi\|223997787\|ref\|XM_002288531.1\|	296543	g11784	i0	83.54	35.404984423676	322	48	50	5	321	640	1721	1403	Thalassiosira pseudonana CCMP1335 heat shock protein/chaperone (hsp70_4), mRNA	blastn	22730	296	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira pseudonana
23273883	23273883	PRJNA1195374_P_NODE_4579_length_962_cov_5.353206_g4328_i0	PRJNA1195374	4579	962	5.353206	51.49784172	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	536	2.21e-147	NTclustered	gi\|657012367\|gb\|KF302531.1\|	2850	g4328	i0	92.742	49.9573804573805	372	25	39	2	343	713	393	23	Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds	blastn	48059	536	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum

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