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

13 rows where analysis = "blastn", bioproject = "PRJNA986481" 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
3524574	3524574	PRJNA986481_P_NODE_803_length_1403_cov_12.577548_g646_i0	PRJNA986481	803	1403	12.577548	176.46299844	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	2091	0	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g646	i0	93.772	103.611546685674	1397	79	99	7	1	1391	1631	3025	Uncultured Chroococcidiopsis sp. clone NA3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	145367	2091	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9901468	9901468	PRJNA986481_P_NODE_18148_length_384_cov_2.173134_g17623_i0	PRJNA986481	18148	384	2.173134	8.34483456	Nostoc sp. UHCC 0870	2914041	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2190707562\|gb\|CP091913.1\|	2914041	g17623	i0	100	0.078125	30	0	8	0	317	346	333553	333524	Nostoc sp. UHCC 0870 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0870
9901746	9901746	PRJNA986481_P_NODE_37088_length_267_cov_1.977064_g36563_i0	PRJNA986481	37088	267	1.977064	5.27876088	Synechococcus sp. PROS-7-1	1442556	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1895782591\|gb\|CP047945.1\|	1442556	g36563	i0	100	0.104868913857678	28	0	10	0	26	53	76510	76483	Synechococcus sp. PROS-7-1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. PROS-7-1
10200810	10200810	PRJNA986481_P_NODE_59868_length_241_cov_1.354167_g59343_i0	PRJNA986481	59868	241	1.354167	3.26354247	Oscillatoriales	1150	Bacteria	Bacteria	427	3.079999999999999e-115	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g59343	i0	99.156	133.45643153527	237	2	98	0	5	241	2229	2465	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32163	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
14026008	14026008	PRJNA986481_P_NODE_43351_length_260_cov_0.957346_g42826_i0	PRJNA986481	43351	260	0.957346	2.4890996	Oscillatoriales	1150	Bacteria	Bacteria	457	4.3e-124	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g42826	i0	100	119.819230769231	247	0	95	0	14	260	2009	1763	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	31153	457	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
16276059	16276059	PRJNA986481_P_NODE_10673_length_501_cov_7.546460_g10152_i0	PRJNA986481	10673	501	7.54646	37.8077646	Kovacikia minuta	2931930	Bacteria	Bacteria	52.8	0.049	NTclustered	gi\|2098452651\|gb\|CP083582.1\|	2653194	g10152	i0	100	0.0558882235528942	28	0	6	0	157	184	3886849	3886876	Kovacikia minuta CCNUW1 strain CCNU0001 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Kovacikia	Kovacikia minuta
16276148	16276148	PRJNA986481_P_NODE_16333_length_406_cov_3.014006_g15808_i0	PRJNA986481	16333	406	3.014006	12.23686436	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	200	1.31e-46	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g15808	i0	87.931	0.583743842364532	174	15	57	3	132	299	3099938	3100111	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	237	200	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
16276405	16276405	PRJNA986481_P_NODE_32533_length_286_cov_5.202532_g32008_i0	PRJNA986481	32533	286	5.202532	14.87924152	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	462	1.03e-125	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g32008	i0	95.804	137.416083916084	286	12	100	0	1	286	3682448	3682163	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	39301	462	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
18825228	18825228	PRJNA986481_P_NODE_29295_length_302_cov_8.102767_g28770_i0	PRJNA986481	29295	302	8.102767	24.47035634	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	505	1.7999999999999995e-138	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g28770	i0	97.01	119.370860927152	301	8	99	1	1	301	3682727	3682428	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	36050	505	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
18825671	18825671	PRJNA986481_P_NODE_57035_length_244_cov_2.102564_g56510_i0	PRJNA986481	57035	244	2.102564	5.13025616	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g56510	i0	92.308	0.159836065573771	39	1	16	2	32	70	711003	710967	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	39	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
20398367	20398367	PRJNA986481_P_NODE_16656_length_402_cov_2.164306_g16131_i0	PRJNA986481	16656	402	2.164306	8.70051012	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|427368660\|gb\|CP003549.1\|	373994	g16131	i0	100	0.283582089552239	29	0	7	0	15	43	6297824	6297852	Rivularia sp. PCC 7116, complete genome	blastn	114	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rivulariaceae	Rivularia	Rivularia sp. PCC 7116
20398575	20398575	PRJNA986481_P_NODE_62656_length_226_cov_2.282486_g62131_i0	PRJNA986481	62656	226	2.282486	5.15841836	Nostocales	1161	Bacteria	Bacteria	329	8.3e-86	NTclustered	gi\|2830894453\|gb\|CP170743.1\|	184925	g62131	i0	93.636	175	220	14	99	0	4	223	1851886	1852105	Chlorogloeopsis fritschii PCC 9212 chromosome, complete genome	blastn	39550	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Chlorogloeopsidaceae	Chlorogloeopsis	Chlorogloeopsis fritschii
23925790	23925790	PRJNA986481_P_NODE_1539_length_1118_cov_4.000000_g1292_i0	PRJNA986481	1539	1118	4	44.72	Stanieria cyanosphaera	102116	Bacteria	Bacteria	645	4.1e-180	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g1292	i0	79.932	17.6967799642218	887	171	79	6	12	893	1	885	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	19785	645	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera

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