metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA703759" and tax_clade = "Cyanobacteriota/Melainabacteria group"

5 rows where analysis = "blastn", bioproject = "PRJNA703759" and tax_clade = "Cyanobacteriota/Melainabacteria group"

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
1960170	1960170	PRJNA703759_P_NODE_2182_length_1172_cov_5.604186_g1765_i0	PRJNA703759	2182	1172	5.604186	65.68105992	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	2080	0	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g1765	i0	98.72	141.347269624573	1172	14	99	1	2	1172	1183	12	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	165659	2080	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
4512531	4512531	PRJNA703759_P_NODE_31904_length_260_cov_1.668449_g31428_i0	PRJNA703759	31904	260	1.668449	4.3379674	Trichodesmium erythraeum	1206	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|110164990\|gb\|CP000393.1\|	203124	g31428	i0	100	0.111538461538462	29	0	11	0	106	134	6882746	6882774	Trichodesmium erythraeum IMS101, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Trichodesmium	Trichodesmium erythraeum
15986929	15986929	PRJNA703759_P_NODE_28713_length_271_cov_1.575758_g28237_i0	PRJNA703759	28713	271	1.575758	4.27030418	Synechococcus sp. PCC 7502	1173263	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|427993480\|gb\|CP003594.1\|	1173263	g28237	i0	100	0.103321033210332	28	0	10	0	165	192	2416474	2416447	Synechococcus sp. PCC 7502, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. PCC 7502
17262596	17262596	PRJNA703759_P_NODE_40954_length_249_cov_0.886364_g40478_i0	PRJNA703759	40954	249	0.886364	2.20704636	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	257	4.45e-64	NTclustered	gi\|2245124533\|gb\|CP097480.1\|	2653189	g40478	i0	89.1	1.69477911646586	211	17	85	3	1	211	1675716	1675512	Chroococcidiopsis sp. CCNUC1 chromosome, complete genome	blastn	422	257	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
23637189	23637189	PRJNA703759_P_NODE_27459_length_275_cov_1.985149_g26983_i0	PRJNA703759	27459	275	1.985149	5.45915975	Cyanobium sp. M30B3	2831057	Bacteria	Bacteria	150	8.709999999999998e-32	NTclustered	gi\|2041287931\|gb\|CP073761.1\|	2831057	g26983	i0	88.095	2.62909090909091	126	15	46	0	150	275	1233133	1233008	MAG: Cyanobium sp. M30B3 chromosome, complete genome	blastn	723	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. M30B3

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