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

8 rows where analysis = "blastn", bioproject = "PRJNA986547" 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
2249495	2249495	PRJNA986547_P_NODE_6662_length_264_cov_1.287958_g6580_i0	PRJNA986547	6662	264	1.287958	3.40020912	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	472	1.5599999999999998e-128	NTclustered	gi\|1280084617\|gb\|MF574179.1\|	119533	g6580	i0	98.864	274.19696969697	264	3	100	0	1	264	2847	2584	Scytonema hyalinum rrn type 2 operon, partial sequence; precursor RNA and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, tRNA-Ile, tRNA-Ala, and 23S ribosomal RNA genes and 23S-5S internal transcribed spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	72388	472	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
6376401	6376401	PRJNA986547_P_NODE_9325_length_249_cov_0.875000_g9243_i0	PRJNA986547	9325	249	0.875	2.17875	Oscillatoriales	1150	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g9243	i0	99.598	157.859437751004	249	1	100	0	1	249	102580	102828	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	39307	455	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
7650334	7650334	PRJNA986547_P_NODE_7026_length_261_cov_2.095745_g6944_i0	PRJNA986547	7026	261	2.095745	5.46989445	Microcoleus	44471	Bacteria	Bacteria	381	2.669999999999999e-101	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g6944	i0	93.077	4.8007662835249	260	18	99	0	1	260	3502830	3503089	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	1253	381	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
9902271	9902271	PRJNA986547_P_NODE_12548_length_238_cov_3.878788_g12466_i0	PRJNA986547	12548	238	3.878788	9.23151544	Planktothrix sp. GU0601_MAG3	3078749	Bacteria	Bacteria	62.1	3.55e-5	NTclustered	gi\|2643647507\|gb\|CP136572.1\|	3078749	g12466	i0	94.872	6.76470588235294	39	2	33	0	171	209	1229429	1229391	MAG: Planktothrix sp. GU0601_MAG3 chromosome, complete genome	blastn	1610	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix sp. GU0601_MAG3
11177511	11177511	PRJNA986547_P_NODE_15549_length_213_cov_5.450000_g15467_i0	PRJNA986547	15549	213	5.45	11.6085	Synechococcus sp. MVIR-18-1	1386941	Bacteria	Bacteria	62.1	3.11e-5	NTclustered	gi\|1895773479\|gb\|CP047942.1\|	1386941	g15467	i0	97.297	0.380281690140845	37	0	17	1	177	212	638678	638714	Synechococcus sp. MVIR-18-1 chromosome, complete genome	blastn	81	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. MVIR-18-1
16276971	16276971	PRJNA986547_P_NODE_12673_length_237_cov_4.298780_g12591_i0	PRJNA986547	12673	237	4.29878	10.1881086	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	248	2.53e-61	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g12591	i0	85.654	47.7932489451477	237	33	100	1	1	237	3679731	3679966	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	11327	248	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
16574818	16574818	PRJNA986547_P_NODE_2393_length_315_cov_6.024793_g2311_i0	PRJNA986547	2393	315	6.024793	18.97809795	Chroococcidiopsis	54298	Bacteria	Bacteria	518	2.42e-142	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g2311	i0	96.486	136.961904761905	313	11	99	0	1	313	795050	794738	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	43143	518	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
20100768	20100768	PRJNA986547_P_NODE_8396_length_251_cov_4.988764_g8314_i0	PRJNA986547	8396	251	4.988764	12.52179764	Nostoc sp. MS1	2764711	Bacteria	Bacteria	154	6.06e-33	NTclustered	gi\|2093825993\|dbj\|AP023441.1\|	2764711	g8314	i0	87.407	13.003984063745	135	16	54	1	117	251	3888437	3888570	Nostoc sp. MS1 DNA, complete genome	blastn	3264	154	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. MS1

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