metadata: contig_metadata: 6 rows where bioproject = "PRJNA603943", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

6 rows where bioproject = "PRJNA603943", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Cyanobacteriota"

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
17721189	17721189	PRJNA603943_P_NODE_60754_length_247_cov_0.879310_g60562_i0	PRJNA603943	60754	247	0.87931	2.1718957	root	1	Root_unresolved	Root_unresolved	62.1	3.71e-5	NTclustered	gi\|2080647037\|gb\|CP080598.1\|	984208	g60562	i0	100	11.834008097166	33	0	13	0	191	223	3423134	3423102	Sphaerospermopsis torques-reginae ITEP-024 chromosome	blastn	2923	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Sphaerospermopsis	Sphaerospermopsis torques-reginae
25369626	25369626	PRJNA603943_P_NODE_68280_length_242_cov_0.911243_g68088_i0	PRJNA603943	68280	242	0.911243	2.20520806	Gloeocapsopsis	693222	Bacteria	Bacteria	348	2.48e-91	NTclustered	gi\|1142095202\|gb\|KU847399.1\|	1433147	g68088	i0	92.562	299.057851239669	242	18	100	0	1	242	5075	4834	Gloeocapsopsis dulcis AAB1 = 1H9 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	72372	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
28090594	28090594	PRJNA603943_P_NODE_5705_length_638_cov_1.564602_g5520_i0	PRJNA603943	5705	638	1.564602	9.98216076	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	306	1.3099999999999995e-101	NR	MBX9694561.1	2847862	g5520	i0	73.4	0.973354231974922	207	50	95	2	614	9	15	221	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	621	306	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
30869820	30869820	PRJNA603943_P_NODE_52654_length_251_cov_0.865169_g52462_i0	PRJNA603943	52654	251	0.865169	2.17157419	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	152	8.88e-46	NR	MBX9692690.1	2847862	g52462	i0	88.3	0.920318725099602	77	9	92	0	250	20	41	117	MBX9692690.1 (2Fe-2S)-binding protein [Cyanobacteriota bacterium]	diamond	231	152	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
31831429	31831429	PRJNA603943_P_NODE_22797_length_365_cov_1.044521_g22605_i0	PRJNA603943	22797	365	1.044521	3.81250165	Synechococcus	1129	Bacteria	Bacteria	80.5	7.82e-15	NR	WP_414413135.1	2291959	g22605	i0	40.5	5.75342465753425	116	33	95.3	1	350	3	142	221	WP_414413135.1 peptide chain release factor 3, partial [Synechococcus sp. R8-2]	diamond	2100	80.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. R8-2
31958113	31958113	PRJNA603943_P_NODE_3057_length_828_cov_3.219868_g2898_i0	PRJNA603943	3057	828	3.219868	26.66050704	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	124	2.68e-29	NR	WP_015138290.1	28072	g2898	i0	37.3	2.36231884057971	217	123	77.9	6	756	112	90	295	WP_015138290.1 hypothetical protein [Nostoc sp. PCC 7524]	diamond	1956	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7524

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