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

7 rows where analysis = "blastn", bioproject = "PRJNA874604" 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
852112	852112	PRJNA874604_P_NODE_54021_length_277_cov_1.127451_g53669_i0	PRJNA874604	54021	277	1.127451	3.12303927	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	475	1.2799999999999997e-129	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g53669	i0	97.491	248.610108303249	279	5	100	2	1	277	1245586	1245308	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	68865	475	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
4680022	4680022	PRJNA874604_P_NODE_29164_length_348_cov_1.669091_g28812_i0	PRJNA874604	29164	348	1.669091	5.80843668	Nostoc sp. PCC 7524	28072	Bacteria	Bacteria	628	1.1999999999999999e-175	NTclustered	gi\|427363208\|gb\|CP003552.1\|	28072	g28812	i0	100	3.60919540229885	340	0	98	0	1	340	6008722	6008383	Nostoc sp. PCC 7524, complete genome	blastn	1256	628	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7524
4680891	4680891	PRJNA874604_P_NODE_76364_length_249_cov_0.875000_g76012_i0	PRJNA874604	76364	249	0.875	2.17875	Stenomitos frigidus	1886765	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2814759481\|gb\|CP170648.1\|	3070788	g76012	i0	100	0.112449799196787	28	0	11	0	158	185	3484724	3484697	MAG: Stenomitos frigidus ULC029 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos frigidus
11056127	11056127	PRJNA874604_P_NODE_69209_length_251_cov_0.865169_g68857_i0	PRJNA874604	69209	251	0.865169	2.17157419	Anabaena azotica	197653	Bacteria	Bacteria	130	1.02e-25	NTclustered	gi\|2894833396\|gb\|CP178454.1\|	3392114	g68857	i0	82.119	1.32669322709163	151	27	60	0	101	251	1269884	1270034	Anabaena azotica SJ-1 chromosome, complete genome	blastn	333	130	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena azotica
18702718	18702718	PRJNA874604_P_NODE_101875_length_227_cov_3.000000_g101523_i0	PRJNA874604	101875	227	3	6.81	Synechococcus sp. RS9902	221345	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1895794691\|gb\|CP047949.1\|	221345	g101523	i0	97.059	1.02202643171806	34	0	15	1	122	155	2439424	2439456	Synechococcus sp. RS9902 chromosome, complete genome	blastn	232	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. RS9902
18702988	18702988	PRJNA874604_P_NODE_25735_length_365_cov_1.739726_g25383_i0	PRJNA874604	25735	365	1.739726	6.3499999	Nostoc sp. PCC 7524	28072	Bacteria	Bacteria	616	9.799999999999999e-172	NTclustered	gi\|427363208\|gb\|CP003552.1\|	28072	g25383	i0	99.702	4.47671232876712	336	1	92	0	30	365	6009116	6008781	Nostoc sp. PCC 7524, complete genome	blastn	1634	616	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7524
22528885	22528885	PRJNA874604_P_NODE_58098_length_269_cov_1.571429_g57746_i0	PRJNA874604	58098	269	1.571429	4.22714401	Nostoc sp. NIES-4103	2005458	Bacteria	Bacteria	67.6	8.8e-7	NTclustered	gi\|1210228378\|dbj\|AP018288.1\|	2005458	g57746	i0	100	10.1040892193309	36	0	13	0	150	185	1145133	1145168	Nostoc sp. NIES-4103 DNA, nearly complete genome	blastn	2718	67.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-4103

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