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

11 rows where analysis = "blastn", bioproject = "PRJNA1010662" 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
6104635	6104635	PRJNA1010662_S_NODE_1905_length_230_cov_3.855615_g1860_i0	PRJNA1010662	1905	230	3.855615	8.8679145	Oscillatoriales	1150	Bacteria	Bacteria	425	1.05e-114	NTclustered	gi\|156972227\|gb\|EF568411.1\|	1211	g1860	i0	100	102	230	0	100	0	1	230	239	10	Uncultured cyanobacterium isolate DGGE gel band Sb6 16S ribosomal RNA gene, partial sequence	blastn	23460	425	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
7379085	7379085	PRJNA1010662_S_NODE_4266_length_167_cov_2.370968_g4221_i0	PRJNA1010662	4266	167	2.370968	3.95951656	Wilmottia	1048851	Bacteria	Bacteria	291	2.7299999999999993e-74	NTclustered	gi\|1700116479\|gb\|MN158648.1\|	2593982	g4221	i0	98.193	148.502994011976	166	3	99	0	2	167	2164	2329	Wilmottia murrayi ACKU581 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	24800	291	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Wilmottiaceae	Wilmottia	Wilmottia murrayi
12480327	12480327	PRJNA1010662_S_NODE_910_length_308_cov_3.539623_g865_i0	PRJNA1010662	910	308	3.539623	10.90203884	Limnospira	2596745	Bacteria	Bacteria	542	1.3999999999999995e-149	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g865	i0	98.377	192.782467532468	308	5	100	0	1	308	813678	813371	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	59377	542	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
13754866	13754866	PRJNA1010662_S_NODE_2091_length_223_cov_5.894444_g2046_i0	PRJNA1010662	2091	223	5.894444	13.14461012	root	1	Root_unresolved	Root_unresolved	412	7.88e-111	NTclustered	gi\|347664803\|gb\|JN679197.1\|	1211	g2046	i0	100	100	223	0	100	0	1	223	765	543	Uncultured cyanobacterium clone 5.17m26 16S ribosomal RNA gene, partial sequence	blastn	22300	412	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
14183528	14183528	PRJNA1010662_P_NODE_14792_length_165_cov_0.896552_g14733_i0	PRJNA1010662	14792	165	0.896552	1.4793108	cyanobacterium endosymbiont of Epithemia clementina EcSB	3034674	Bacteria	Bacteria	99	1.75e-16	NTclustered	gi\|2499392380\|gb\|CP123991.1\|	3034674	g14733	i0	89.61	11.0484848484848	77	8	47	0	37	113	2342995	2342919	Cyanobacterium endosymbiont of Epithemia clementina EcSB isolate Gazos Creek chromosome, complete genome	blastn	1823	99	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium endosymbiont of Epithemia clementina EcSB
16303966	16303966	PRJNA1010662_S_NODE_153_length_626_cov_2.552316_g122_i0	PRJNA1010662	153	626	2.552316	15.97749816	Oscillatoriales	1150	Bacteria	Bacteria	761	0	NTclustered	gi\|1566846289\|dbj\|LC455669.1\|	118562	g122	i0	89.068	138.186900958466	622	56	99	9	4	620	1587	973	Arthrospira platensis NIES-46 gene for 23S ribosomal RNA, partial sequence	blastn	86505	767	0.992177314211212	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
17579325	17579325	PRJNA1010662_S_NODE_2374_length_212_cov_8.153846_g2329_i0	PRJNA1010662	2374	212	8.153846	17.28615352	Chroococcaceae	1890464	Bacteria	Bacteria	226	1.04e-54	NTclustered	gi\|428262672\|gb\|CP003646.1\|	1173026	g2329	i0	89.831	234.108490566038	177	17	83	1	37	212	4792835	4792659	Gloeocapsa sp. PCC 7428, complete genome	blastn	49631	226	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
19280385	19280385	PRJNA1010662_P_NODE_12216_length_170_cov_1.528926_g12157_i0	PRJNA1010662	12216	170	1.528926	2.5991742	Gloeocapsopsis crepidinum	693223	Bacteria	Bacteria	298	1.65e-76	NTclustered	gi\|222138150\|gb\|FJ589716.1\|	588587	g12157	i0	98.235	220.529411764706	170	3	100	0	1	170	2307	2138	Gloeocapsopsis crepidinum LEGE 06123 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer and tRNA-Ile gene, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	37490	298	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis crepidinum
20127946	20127946	PRJNA1010662_S_NODE_3436_length_183_cov_2.335714_g3391_i0	PRJNA1010662	3436	183	2.335714	4.27435662	Nostocales	1161	Bacteria	Bacteria	339	1.07e-88	NTclustered	gi\|1834153068\|gb\|MT366987.1\|	1211	g3391	i0	100	99.9890710382514	183	0	100	0	1	183	311	129	Uncultured cyanobacterium clone 64a 16S ribosomal RNA gene, partial sequence	blastn	18298	339	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
21831618	21831618	PRJNA1010662_P_NODE_10918_length_178_cov_1.581395_g10859_i0	PRJNA1010662	10918	178	1.581395	2.8148831	Nostoc sp. TCL26-01	2576904	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1866654106\|gb\|CP040297.1\|	2576904	g10859	i0	100	0.842696629213483	30	0	17	0	125	154	2963886	2963857	Nostoc sp. TCL26-01 chromosome, complete genome	blastn	150	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. TCL26-01
24381016	24381016	PRJNA1010662_S_NODE_3640_length_179_cov_1.360294_g3595_i0	PRJNA1010662	3640	179	1.360294	2.43492626	Spirirestis rafaelensis	293980	Bacteria	Bacteria	327	2.25e-85	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g3595	i0	100	248.597765363129	177	0	99	0	1	177	241	417	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	44499	327	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis

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