metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA454503" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA454503" and tax_phylum = "Cyanobacteriota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26632977	26632977	PRJNA454503_P_NODE_66941_length_207_cov_1.780822_g66612_i0	PRJNA454503	66941	207	1.780822	3.68630154	Candidatus Synechococcus spongiarum 142	1608213	Bacteria	Bacteria	40.8	0.0324	NR	KKZ15259.1	1608213	g66612	i0	41.2	0.985507246376812	68	22	72.5	2	34	183	17	84	KKZ15259.1 MAG: hypothetical protein TH68_01305 [Candidatus Synechococcus spongiarum 142]	diamond	204	40.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Candidatus Synechococcus spongiarum
26934126	26934126	PRJNA454503_P_NODE_68062_length_207_cov_0.890411_g67733_i0	PRJNA454503	68062	207	0.890411	1.84315077	Bacillati	1783272	Bacteria	Bacteria	119	5.9400000000000005e-33	NR	MBW4459677.1	1602008	g67733	i0	76.8	5	69	16	100	0	1	207	14	82	MBW4459677.1 nuclear transport factor 2 family protein [Nodosilinea sp. WJT8-NPBG4]	diamond	1035	119	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. WJT8-NPBG4
27865692	27865692	PRJNA454503_P_NODE_50305_length_215_cov_1.688312_g49976_i0	PRJNA454503	50305	215	1.688312	3.6298708	Coleofasciculaceae cyanobacterium	3081323	Bacteria	Bacteria	142	1.4e-38	NR	HEY9771584.1	3081323	g49976	i0	97.2	0.990697674418605	71	2	99.1	0	213	1	227	297	HEY9771584.1 sodium/proline symporter [Coleofasciculaceae cyanobacterium]	diamond	213	142	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium
29223693	29223693	PRJNA454503_P_NODE_63249_length_208_cov_2.340136_g62920_i0	PRJNA454503	63249	208	2.340136	4.86748288	Synechococcus sp. R60.3	2967123	Bacteria	Bacteria	70.1	6.71e-14	NR	MFS8799176.1	2967123	g62920	i0	67.3	0.706730769230769	49	16	70.7	0	55	201	27	75	MFS8799176.1 hypothetical protein [Synechococcus sp. R60.3]	diamond	147	70.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. R60.3

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