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

8 rows where analysis = "blastn", bioproject = "PRJNA1010780" 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
3981480	3981480	PRJNA1010780_S_NODE_16444_length_494_cov_3.427015_g15197_i0	PRJNA1010780	16444	494	3.427015	16.9294541	Pseudanabaena galeata	1112103	Bacteria	Bacteria	52.8	0.048	NTclustered	gi\|2498980257\|gb\|CP112874.1\|	2602720	g15197	i0	100	0.0566801619433198	28	0	6	0	164	191	3725363	3725336	Pseudanabaena galeata CCNP1313 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena galeata
12908697	12908697	PRJNA1010780_S_NODE_10451_length_744_cov_43.157969_g9473_i0	PRJNA1010780	10451	744	43.157969	321.09528936	Chondrocystis sp. NIES-4102	2005460	Bacteria	Bacteria	54.7	0.021	NTclustered	gi\|1210223977\|dbj\|AP018281.1\|	2005460	g9473	i0	94.444	0.0483870967741935	36	0	5	2	26	59	112220	112185	Chondrocystis sp. NIES-4102 DNA, complete genome	blastn	36	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chondrocystis	Chondrocystis sp. NIES-4102
12908777	12908777	PRJNA1010780_S_NODE_23911_length_332_cov_1.885522_g22622_i0	PRJNA1010780	23911	332	1.885522	6.25993304	Gloeothece verrucosa	2546359	Bacteria	Bacteria	63.9	1.44e-5	NTclustered	gi\|306980173\|gb\|CP002198.1\|	497965	g22622	i0	100	0.762048192771084	34	0	10	0	136	169	6031981	6032014	Cyanothece sp. PCC 7822, complete genome	blastn	253	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece verrucosa
16304062	16304062	PRJNA1010780_S_NODE_51633_length_171_cov_1.867647_g50344_i0	PRJNA1010780	51633	171	1.867647	3.19367637	Microcystis	1125	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1519305953\|dbj\|AP019314.1\|	213615	g50344	i0	100	0.327485380116959	28	0	16	0	5	32	2577911	2577938	Microcystis viridis NIES-102 DNA, complete genome	blastn	56	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis viridis
18006972	18006972	PRJNA1010780_S_NODE_54455_length_165_cov_1.692308_g53166_i0	PRJNA1010780	54455	165	1.692308	2.7923082	Pseudanabaena galeata	1112103	Bacteria	Bacteria	60.2	8.25e-5	NTclustered	gi\|2498980257\|gb\|CP112874.1\|	2602720	g53166	i0	100	0.375757575757576	32	0	19	0	86	117	857521	857552	Pseudanabaena galeata CCNP1313 chromosome, complete genome	blastn	62	60.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena galeata
19280660	19280660	PRJNA1010780_S_NODE_29816_length_266_cov_3.978355_g28527_i0	PRJNA1010780	29816	266	3.978355	10.5824243	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g28527	i0	100	0.105263157894737	28	0	11	0	67	94	4925448	4925421	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
20556448	20556448	PRJNA1010780_S_NODE_9497_length_803_cov_2.798177_g8586_i0	PRJNA1010780	9497	803	2.798177	22.46936131	Prochlorococcus sp. MIT 1223	3096217	Bacteria	Bacteria	58.4	0.002	NTclustered	gi\|2625929803\|gb\|CP139303.1\|	3096217	g8586	i0	97.059	0.0423412204234122	34	1	4	0	306	339	133163	133130	Prochlorococcus sp. MIT 1223 chromosome, complete genome	blastn	34	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus sp. MIT 1223
25227773	25227773	PRJNA1010780_S_NODE_27740_length_286_cov_1.685259_g26451_i0	PRJNA1010780	27740	286	1.685259	4.81984074	Synechocystis	1142	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2032561288\|gb\|CP054306.1\|	2732530	g26451	i0	100	0.195804195804196	28	0	10	0	200	227	1236610	1236583	Synechocystis sp. PCC 7338 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7338

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