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

9 rows where analysis = "blastn", bioproject = "PRJNA770826" 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
746854	746854	PRJNA770826_P_NODE_20281_length_180_cov_1.068702_g20110_i0	PRJNA770826	20281	180	1.068702	1.9236636	Sphaerospermopsis torques-reginae	984207	Bacteria	Bacteria	84.2	5.41e-12	NTclustered	gi\|2080647037\|gb\|CP080598.1\|	984208	g20110	i0	89.394	0.711111111111111	66	7	37	0	9	74	3253834	3253769	Sphaerospermopsis torques-reginae ITEP-024 chromosome	blastn	128	84.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Sphaerospermopsis	Sphaerospermopsis torques-reginae
4575135	4575135	PRJNA770826_P_NODE_17124_length_195_cov_2.157534_g16953_i0	PRJNA770826	17124	195	2.157534	4.2071913	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	361	2.46e-95	NTclustered	gi\|225696240\|gb\|FJ805907.1\|	259957	g16953	i0	100	197.733333333333	195	0	100	0	1	195	2449	2255	Uncultured Chroococcidiopsis sp. clone NA3_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	38558	361	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5035025	5035025	PRJNA770826_P_NODE_11024_length_243_cov_1.072165_g10853_i0	PRJNA770826	11024	243	1.072165	2.60536095	Fischerella	1190	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2314726996\|dbj\|AP024677.1\|	1191	g10853	i0	100	0.477366255144033	30	0	12	0	205	234	1620672	1620643	MAG: Fischerella sp. KatS3mg066 DNA, complete genome	blastn	116	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Fischerella	Fischerella sp.
10951035	10951035	PRJNA770826_P_NODE_40389_length_163_cov_0.912281_g40218_i0	PRJNA770826	40389	163	0.912281	1.48701803	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	291	2.64e-74	NTclustered	gi\|225696240\|gb\|FJ805907.1\|	259957	g40218	i0	98.773	191.588957055215	163	2	100	0	1	163	1609	1771	Uncultured Chroococcidiopsis sp. clone NA3_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	31229	291	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19873736	19873736	PRJNA770826_P_NODE_5336_length_367_cov_1.606918_g5165_i0	PRJNA770826	5336	367	1.606918	5.89738906	Dolichospermum flos-aquae	1166	Bacteria	Bacteria	89.8	2.66e-13	NTclustered	gi\|1832564030\|gb\|CP051206.1\|	315271	g5165	i0	85.882	14.858310626703	85	11	23	1	32	115	1397917	1397833	Dolichospermum flos-aquae CCAP 1403/13F chromosome, complete genome	blastn	5453	89.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum flos-aquae
20333126	20333126	PRJNA770826_P_NODE_17536_length_193_cov_1.444444_g17365_i0	PRJNA770826	17536	193	1.444444	2.78777692	Thermosynechococcus	146785	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|1741466979\|gb\|CP040671.1\|	2583530	g17365	i0	100	3.91709844559586	28	0	15	0	44	71	64024	64051	Thermosynechococcus sp. CL-1 chromosome, complete genome	blastn	756	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae	Thermosynechococcus	Thermosynechococcus sp. CL-1
23699953	23699953	PRJNA770826_P_NODE_7019_length_312_cov_10.828897_g6848_i0	PRJNA770826	7019	312	10.828897	33.78615864	Moorena producens	1155739	Bacteria	Bacteria	60.2	1.74e-4	NTclustered	gi\|2412135964\|gb\|CP017708.2\|	1454205	g6848	i0	100	0.689102564102564	32	0	10	0	254	285	4446700	4446731	Moorena producens JHB chromosome, complete genome	blastn	215	60.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena producens
24158372	24158372	PRJNA770826_P_NODE_4419_length_410_cov_1.930748_g4248_i0	PRJNA770826	4419	410	1.930748	7.9160668	Oscillatoriales	1150	Bacteria	Bacteria	89.8	3e-13	NTclustered	gi\|2395771017\|gb\|CP066886.2\|	147317	g4248	i0	76.571	5.2609756097561	175	33	42	7	235	408	1689089	1688922	Arthrospira sp. PCC 9108 chromosome, complete genome	blastn	2157	89.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Arthrospira	Arthrospira sp. PCC 9108
24973523	24973523	PRJNA770826_P_NODE_27380_length_168_cov_0.873950_g27209_i0	PRJNA770826	27380	168	0.87395	1.468236	Cyanobium sp. M30B3	2831057	Bacteria	Bacteria	113	6.3800000000000005e-21	NTclustered	gi\|2041287931\|gb\|CP073761.1\|	2831057	g27209	i0	89.773	8.08928571428571	88	9	52	0	81	168	489867	489954	MAG: Cyanobium sp. M30B3 chromosome, complete genome	blastn	1359	113	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);;