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

8 rows where analysis = "blastn", bioproject = "PRJNA929952" 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
3806824	3806824	PRJNA929952_P_NODE_17803_length_236_cov_2.908213_g16509_i0	PRJNA929952	17803	236	2.908213	6.86338268	Nostocales	1161	Bacteria	Bacteria	237	5.44e-58	NTclustered	gi\|604876398\|gb\|CP007203.2\|	313624	g16509	i0	87.805	233.190677966102	205	21	86	3	1	203	1452140	1452342	Nodularia spumigena CCY9414 genome	blastn	55033	237	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
17487440	17487440	PRJNA929952_P_NODE_24594_length_152_cov_3.138211_g23300_i0	PRJNA929952	24594	152	3.138211	4.77008072	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	158	2.56e-34	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g23300	i0	93.396	130.506578947368	106	7	70	0	46	151	3679906	3679801	Leptolyngbya sp. 7M chromosome	blastn	19837	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
17832351	17832351	PRJNA929952_P_NODE_13754_length_285_cov_5.597656_g12461_i0	PRJNA929952	13754	285	5.597656	15.9533196	Cyanophyceae	3028117	Bacteria	Bacteria	244	4.05e-60	NTclustered	gi\|2895599925\|gb\|CP138977.1\|	93057	g12461	i0	82.517	170.410526315789	286	43	100	6	1	285	1098382	1098103	Prochlorococcus marinus str. MIT 9201 chromosome, complete genome	blastn	48567	244	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
18760753	18760753	PRJNA929952_P_NODE_12155_length_315_cov_5.702797_g10862_i0	PRJNA929952	12155	315	5.702797	17.96381055	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	359	1.55e-94	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g10862	i0	87.302	148.025396825397	315	39	100	1	1	315	3680042	3679729	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	46628	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
21311241	21311241	PRJNA929952_P_NODE_1937_length_849_cov_111.389024_g1395_i0	PRJNA929952	1937	849	111.389024	945.69281376	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	776	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g1395	i0	84.539	139.451118963486	802	105	93	16	1	793	3680909	3681700	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	118394	776	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
21311262	21311262	PRJNA929952_P_NODE_4317_length_601_cov_13.022727_g3361_i0	PRJNA929952	4317	601	13.022727	78.26658927	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	769	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g3361	i0	89.735	161.116472545757	604	58	100	4	1	601	3682162	3681560	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	96831	769	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
22586150	22586150	PRJNA929952_P_NODE_23978_length_158_cov_2.224806_g22684_i0	PRJNA929952	23978	158	2.224806	3.51519348	uncultured Chroococcales cyanobacterium	183216	Bacteria	Bacteria	270	3.3099999999999996e-68	NTclustered	gi\|453199381\|gb\|JQ997361.1\|	183216	g22684	i0	97.468	366.392405063291	158	4	100	0	1	158	90	247	Uncultured Chroococcales cyanobacterium clone GKJWQY101A3MLQ 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	57890	270	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales			uncultured Chroococcales cyanobacterium
22586160	22586160	PRJNA929952_P_NODE_4478_length_589_cov_2731.325000_g3501_i0	PRJNA929952	4478	589	2731.325	16087.50425	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	575	2.789999999999999e-159	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g3501	i0	84.564	191.219015280136	596	74	100	16	1	589	2151484	2152068	Leptolyngbya sp. 7M chromosome	blastn	112628	575	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M

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