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

9 rows where analysis = "blastn", bioproject = "PRJNA1218816" 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
333329	333329	PRJNA1218816_P_NODE_41401_length_298_cov_3.724444_g40968_i0	PRJNA1218816	41401	298	3.724444	11.09884312	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	448	3.0199999999999996e-121	NTclustered	gi\|225696219\|gb\|FJ805886.1\|	259957	g40968	i0	94.237	109.11744966443	295	14	98	3	6	297	2098	1804	Uncultured Chroococcidiopsis sp. clone NA4_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32517	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
2321605	2321605	PRJNA1218816_P_NODE_53742_length_251_cov_0.865169_g53309_i0	PRJNA1218816	53742	251	0.865169	2.17157419	Nostocales	1161	Bacteria	Bacteria	388	1.5299999999999998e-103	NTclustered	gi\|2874254083\|emb\|OY970166.1\|	1211	g53309	i0	94.821	270.378486055777	251	9	100	4	1	251	2506698	2506944	MAG: uncultured cyanobacterium isolate MFD01721.bin.c.4 genome assembly, chromosome: 1	blastn	67865	388	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
8699329	8699329	PRJNA1218816_P_NODE_64127_length_227_cov_2.058442_g63694_i0	PRJNA1218816	64127	227	2.058442	4.67266334	Cyanophyceae	3028117	Bacteria	Bacteria	331	2.32e-86	NTclustered	gi\|984535223\|dbj\|AP017367.1\|	1080068	g63694	i0	92.952	187.145374449339	227	16	100	0	1	227	281655	281881	Leptolyngbya sp. O-77 DNA, complete genome	blastn	42482	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. O-77
9261178	9261178	PRJNA1218816_P_NODE_11808_length_724_cov_3.104455_g11401_i0	PRJNA1218816	11808	724	3.104455	22.4762542	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1166	0	NTclustered	gi\|225696246\|gb\|FJ805913.1\|	259957	g11401	i0	95.616	118.193370165746	730	26	100	6	1	724	2174	2903	Uncultured Chroococcidiopsis sp. clone AN1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	85572	1166	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9261404	9261404	PRJNA1218816_P_NODE_45608_length_281_cov_1.466346_g45175_i0	PRJNA1218816	45608	281	1.466346	4.12043226	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	424	4.77e-114	NTclustered	gi\|225696185\|gb\|FJ805852.1\|	259957	g45175	i0	93.95	165.914590747331	281	16	100	1	1	281	2127	1848	Uncultured Chroococcidiopsis sp. clone AR1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	46622	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15636541	15636541	PRJNA1218816_P_NODE_64053_length_227_cov_4.987013_g63620_i0	PRJNA1218816	64053	227	4.987013	11.32051951	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	385	1.76e-102	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g63620	i0	97.357	225.867841409692	227	5	99	1	2	227	2818	2592	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	51272	385	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
23998337	23998337	PRJNA1218816_P_NODE_25259_length_415_cov_2.190058_g24826_i0	PRJNA1218816	25259	415	2.190058	9.0887407	Oscillatoriales	1150	Bacteria	Bacteria	756	0	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g24826	i0	99.518	128.156626506024	415	2	100	0	1	415	101974	102388	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	53185	761	0.993429697766097	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
24559585	24559585	PRJNA1218816_P_NODE_46020_length_279_cov_1.737864_g45587_i0	PRJNA1218816	46020	279	1.737864	4.84864056	cyanobacterium NIES-36	2510787	Bacteria	Bacteria	359	1.35e-94	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g45587	i0	89.928	147.136200716846	278	28	99	0	2	279	172	449	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	41051	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
25272472	25272472	PRJNA1218816_P_NODE_57880_length_246_cov_2.121387_g57447_i0	PRJNA1218816	57880	246	2.121387	5.21861202	root	1	Root_unresolved	Root_unresolved	455	1.4500000000000002e-123	NTclustered	gi\|588284496\|gb\|KF951520.1\|	1211	g57447	i0	100	100.028455284553	246	0	100	0	1	246	174	419	Uncultured cyanobacterium clone PS41 16S ribosomal RNA gene, partial sequence	blastn	24607	455	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium

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