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

8 rows where analysis = "blastn", bioproject = "PRJNA741997" 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
2473493	2473493	PRJNA741997_P_NODE_12582_length_694_cov_3.309179_g11516_i0	PRJNA741997	12582	694	3.309179	22.96570226	Stenomitos	1844270	Bacteria	Bacteria	1068	0	NTclustered	gi\|225696245\|gb\|FJ805912.1\|	1211	g11516	i0	94.532	223.468299711816	695	33	99	3	2	694	2873	2182	Uncultured cyanobacterium clone AN2_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	155087	1077	0.991643454038997	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
4550173	4550173	PRJNA741997_P_NODE_78784_length_247_cov_0.885057_g77664_i0	PRJNA741997	78784	247	0.885057	2.18609079	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	313	9.28e-81	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g77664	i0	89.474	1	247	26	100	0	1	247	4505591	4505837	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	247	313	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
5825011	5825011	PRJNA741997_P_NODE_32245_length_384_cov_1.234727_g31125_i0	PRJNA741997	32245	384	1.234727	4.74135168	Prochlorococcus sp. MIT 1223	3096217	Bacteria	Bacteria	65.8	4.71e-6	NTclustered	gi\|2625929803\|gb\|CP139303.1\|	3096217	g31125	i0	95.122	0.106770833333333	41	2	11	0	190	230	1693199	1693239	Prochlorococcus sp. MIT 1223 chromosome, complete genome	blastn	41	65.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus sp. MIT 1223
14750314	14750314	PRJNA741997_P_NODE_29212_length_406_cov_1.369369_g28092_i0	PRJNA741997	29212	406	1.369369	5.55963814	Synechococcus sp. KORDI-100	1280380	Bacteria	Bacteria	69.4	3.87e-7	NTclustered	gi\|670925746\|gb\|CP006269.1\|	1280380	g28092	i0	100	3.60098522167488	37	0	9	0	2	38	1420961	1420925	Synechococcus sp. KORDI-100, complete genome	blastn	1462	69.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. KORDI-100
15226732	15226732	PRJNA741997_P_NODE_87352_length_242_cov_0.911243_g86232_i0	PRJNA741997	87352	242	0.911243	2.20520806	Cyanophyceae	3028117	Bacteria	Bacteria	409	1.12e-109	NTclustered	gi\|443428703\|gb\|JX127186.1\|	1211	g86232	i0	97.107	101.020661157025	242	7	100	0	1	242	597	838	Uncultured cyanobacterium clone 3GSCS_K18 16S ribosomal RNA gene, partial sequence	blastn	24447	409	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
19848656	19848656	PRJNA741997_P_NODE_73096_length_250_cov_1.683616_g71976_i0	PRJNA741997	73096	250	1.683616	4.20904	Gloeobacter kilaueensis	1416614	Bacteria	Bacteria	93.5	1.33e-14	NTclustered	gi\|553880805\|gb\|CP003587.1\|	1183438	g71976	i0	82.143	2.912	112	16	44	4	12	121	2466790	2466899	Gloeobacter kilaueensis JS1, complete genome	blastn	728	93.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeobacterales	Gloeobacteraceae	Gloeobacter	Gloeobacter kilaueensis
24947810	24947810	PRJNA741997_P_NODE_23880_length_459_cov_1.994819_g22761_i0	PRJNA741997	23880	459	1.994819	9.15621921	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	721	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g22761	i0	94.989	174.952069716776	459	23	100	0	1	459	3682659	3682201	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	80303	721	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
25424703	25424703	PRJNA741997_P_NODE_21100_length_496_cov_1.411348_g19983_i0	PRJNA741997	21100	496	1.411348	7.00028608	Cyanophyceae	3028117	Bacteria	Bacteria	662	0	NTclustered	gi\|984535223\|dbj\|AP017367.1\|	1080068	g19983	i0	90.837	173.945564516129	502	34	99	10	2	496	282104	281608	Leptolyngbya sp. O-77 DNA, complete genome	blastn	86277	667	0.992503748125937	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. O-77

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