metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1073183" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1073183" 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
1461647	1461647	PRJNA1073183_P_NODE_15622_length_330_cov_1.249027_g15527_i0	PRJNA1073183	15622	330	1.249027	4.1217891	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	241	6.18e-59	NTclustered	gi\|657012511\|gb\|KF302595.1\|	2850	g15527	i0	89.119	3.66969696969697	193	21	58	0	1	193	101	293	Phaeodactylum tricornutum clone C854 ubiquitin-ribosomal protein fusion S27a mRNA, partial cds	blastn	1211	241	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
5290134	5290134	PRJNA1073183_P_NODE_2985_length_723_cov_3.244615_g2901_i0	PRJNA1073183	2985	723	3.244615	23.45856645	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	510	9.929999999999999e-140	NTclustered	gi\|657012367\|gb\|KF302531.1\|	2850	g2901	i0	90.838	68.7869986168741	382	33	53	2	138	518	390	10	Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds	blastn	49733	510	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
5290275	5290275	PRJNA1073183_P_NODE_6045_length_515_cov_14.676471_g5952_i0	PRJNA1073183	6045	515	14.676471	75.58382565	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	466	1.52e-126	NTclustered	gi\|657012562\|gb\|KF302618.1\|	2850	g5952	i0	87.775	3.71067961165049	409	37	78	7	1	401	426	23	Phaeodactylum tricornutum clone C537 hypothetical protein mRNA, complete cds	blastn	1911	466	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
10390637	10390637	PRJNA1073183_P_NODE_3149_length_705_cov_4.330696_g3065_i0	PRJNA1073183	3149	705	4.330696	30.5314068	Phaeodactylum tricornutum	2850	SAR_Eukaryotes	SAR_Eukaryotes	420	1.6799999999999998e-112	NTclustered	gi\|657012465\|gb\|KF302574.1\|	2850	g3065	i0	88.663	37.9872340425532	344	39	49	0	331	674	1	344	Phaeodactylum tricornutum clone C567 ribosomal protein mRNA, partial cds	blastn	26781	420	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Phaeodactylaceae	Phaeodactylum	Phaeodactylum tricornutum
23139602	23139602	PRJNA1073183_P_NODE_27519_length_250_cov_0.870056_g27424_i0	PRJNA1073183	27519	250	0.870056	2.17514	Thalassiosira pseudonana	35128	SAR_Eukaryotes	SAR_Eukaryotes	217	7.59e-52	NTclustered	gi\|223997043\|ref\|XM_002288159.1\|	296543	g27424	i0	87.435	76.612	191	20	76	4	51	239	365	177	Thalassiosira pseudonana CCMP1335 histone H2B mRNA	blastn	19153	217	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Thalassiosirales	Thalassiosiraceae	Thalassiosira	Thalassiosira pseudonana

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