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

8 rows where analysis = "blastn", bioproject = "PRJNA890871" 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
2518302	2518302	PRJNA890871_P_NODE_74082_length_246_cov_0.890173_g73947_i0	PRJNA890871	74082	246	0.890173	2.18982558	Chlorogloeopsis	1123	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2830894453\|gb\|CP170743.1\|	184925	g73947	i0	100	0.227642276422764	28	0	11	0	73	100	4295256	4295283	Chlorogloeopsis fritschii PCC 9212 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Chlorogloeopsidaceae	Chlorogloeopsis	Chlorogloeopsis fritschii
5968187	5968187	PRJNA890871_P_NODE_62285_length_251_cov_1.730337_g62150_i0	PRJNA890871	62285	251	1.730337	4.34314587	Nostoc sp. 'Peltigera membranacea cyanobiont' N6	1261031	Bacteria	Bacteria	195	3.57e-45	NTclustered	gi\|1349664091\|gb\|CP026681.1\|	1261031	g62150	i0	88.272	6.43027888446215	162	19	65	0	1	162	1172271	1172110	Nostoc sp. 'Peltigera membranacea cyanobiont' N6 chromosome, complete genome	blastn	1614	195	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. 'Peltigera membranacea cyanobiont' N6
5968270	5968270	PRJNA890871_P_NODE_67385_length_249_cov_0.875000_g67250_i0	PRJNA890871	67385	249	0.875	2.17875	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	335	2e-87	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g67250	i0	91.429	11.5261044176707	245	20	98	1	1	244	6752915	6753159	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	2870	335	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
8895594	8895594	PRJNA890871_P_NODE_74527_length_246_cov_0.890173_g74392_i0	PRJNA890871	74527	246	0.890173	2.18982558	Nostocales	1161	Bacteria	Bacteria	267	7.289999999999999e-67	NTclustered	gi\|604876398\|gb\|CP007203.2\|	313624	g74392	i0	86.179	8.95121951219512	246	34	100	0	1	246	434447	434692	Nodularia spumigena CCY9414 genome	blastn	2202	267	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
14892587	14892587	PRJNA890871_P_NODE_46212_length_272_cov_1.512563_g46077_i0	PRJNA890871	46212	272	1.512563	4.11417136	Richelia sinica	1357545	Bacteria	Bacteria	148	3.0899999999999993e-31	NTclustered	gi\|2059364121\|gb\|CP021056.1\|	1357546	g46077	i0	86.567	0.492647058823529	134	18	49	0	139	272	1026592	1026459	Richelia sinica FACHB-800 strain FACHB 800 chromosome, complete genome	blastn	134	148	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia sinica
14892627	14892627	PRJNA890871_P_NODE_47992_length_269_cov_2.188776_g47857_i0	PRJNA890871	47992	269	2.188776	5.88780744	Nostoc sp. TCL240-02	2572090	Bacteria	Bacteria	180	1.08e-40	NTclustered	gi\|1854569723\|gb\|CP040094.1\|	2572090	g47857	i0	78.967	7.63197026022305	271	51	99	5	1	268	5850868	5850601	Nostoc sp. TCL240-02 chromosome, complete genome	blastn	2053	180	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. TCL240-02
17443179	17443179	PRJNA890871_P_NODE_65174_length_250_cov_0.870056_g65039_i0	PRJNA890871	65174	250	0.870056	2.17514	Nostoc sp. HK-01	196308	Bacteria	Bacteria	316	7.269999999999998e-82	NTclustered	gi\|1373826207\|dbj\|AP018322.1\|	196308	g65039	i0	89.6	1	250	25	100	1	1	250	18267	18515	Nostoc sp. HK-01 plasmid plasmid4 DNA, complete genome	blastn	250	316	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. HK-01
23817150	23817150	PRJNA890871_P_NODE_65599_length_250_cov_0.870056_g65464_i0	PRJNA890871	65599	250	0.870056	2.17514	Leptothermofonsia sichuanensis	2917832	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2090366103\|gb\|CP072600.1\|	2016068	g65464	i0	100	0.232	30	0	12	0	150	179	569306	569277	Leptothermofonsia sichuanensis E412 chromosome, complete genome	blastn	58	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptothermofonsia	Leptothermofonsia sichuanensis

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