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

12 rows where analysis = "blastn", bioproject = "PRJEB81463" 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
140485	140485	PRJEB81463_P_NODE_23821_length_248_cov_0.891429_g23549_i0	PRJEB81463	23821	248	0.891429	2.21074392	Nostoc sp. 'Lobaria pulmonaria (5183) cyanobiont'	1618022	Bacteria	Bacteria	303	5.61e-78	NTclustered	gi\|1349670869\|gb\|CP026692.1\|	1618022	g23549	i0	88.71	1	248	28	100	0	1	248	1424859	1424612	Nostoc sp. 'Lobaria pulmonaria (5183) cyanobiont' strain 5183 chromosome, complete genome	blastn	248	303	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. 'Lobaria pulmonaria (5183) cyanobiont'
3966601	3966601	PRJEB81463_P_NODE_23144_length_249_cov_0.886364_g22872_i0	PRJEB81463	23144	249	0.886364	2.20704636	Microcoleus vaginatus	119532	Bacteria	Bacteria	433	6.89e-117	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g22872	i0	97.992	26.3734939759036	249	5	100	0	1	249	4034430	4034678	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	6567	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
7792581	7792581	PRJEB81463_P_NODE_13607_length_284_cov_1.919431_g13335_i0	PRJEB81463	13607	284	1.919431	5.45118404	Microcoleus vaginatus	119532	Bacteria	Bacteria	492	1.2999999999999999e-134	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g13335	i0	97.887	179.225352112676	284	6	100	0	1	284	1374444	1374727	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	50900	492	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
10343667	10343667	PRJEB81463_P_NODE_5489_length_427_cov_3.915254_g5217_i0	PRJEB81463	5489	427	3.915254	16.71813458	Aliterella chasmolithica	2739056	Bacteria	Bacteria	717	0	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g5217	i0	96.956	116.789227166276	427	13	100	0	1	427	2011	2437	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	49869	717	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
13750783	13750783	PRJEB81463_P_NODE_24311_length_247_cov_0.896552_g24039_i0	PRJEB81463	24311	247	0.896552	2.21448344	Nostocaceae	1162	Bacteria	Bacteria	171	5.91e-38	NTclustered	gi\|1334417636\|gb\|CP023278.1\|	1869241	g24039	i0	79.661	2.91497975708502	236	48	96	0	4	239	5819972	5819737	Nostoc sp. CENA543 chromosome, complete genome	blastn	720	172	0.994186046511628	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CENA543
14169113	14169113	PRJEB81463_P_NODE_8632_length_342_cov_2.066914_g8360_i0	PRJEB81463	8632	342	2.066914	7.06884588	Aliterella chasmolithica	2739056	Bacteria	Bacteria	444	4.57e-120	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g8360	i0	90.087	118.631578947368	343	32	100	2	1	342	2011	2352	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	40572	444	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
15025221	15025221	PRJEB81463_P_NODE_13092_length_287_cov_1.546729_g12820_i0	PRJEB81463	13092	287	1.546729	4.43911223	Nostocaceae	1162	Bacteria	Bacteria	525	1.2999999999999995e-144	NTclustered	gi\|1796909370\|gb\|CP046703.1\|	76335	g12820	i0	99.652	266.261324041812	287	1	100	0	1	287	3059626	3059340	Nostoc sp. ATCC 53789 chromosome, complete genome	blastn	76417	525	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. ATCC 53789
16717135	16717135	PRJEB81463_P_NODE_19574_length_255_cov_1.620879_g19302_i0	PRJEB81463	19574	255	1.620879	4.13324145	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	174	4.74e-39	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g19302	i0	80.081	41.9647058823529	246	39	94	10	1	239	2362897	2363139	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	10701	174	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
17991992	17991992	PRJEB81463_P_NODE_21255_length_251_cov_1.938202_g20983_i0	PRJEB81463	21255	251	1.938202	4.86488702	Calothrix sp. PCC 7507	99598	Bacteria	Bacteria	209	1.28e-49	NTclustered	gi\|427347790\|gb\|CP003943.1\|	99598	g20983	i0	81.673	2.71713147410359	251	46	100	0	1	251	6288870	6288620	Calothrix sp. PCC 7507 chromosome, complete genome	blastn	682	209	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7507
21817479	21817479	PRJEB81463_P_NODE_898_length_1033_cov_2.635417_g714_i0	PRJEB81463	898	1033	2.635417	27.22385761	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1495	0	NTclustered	gi\|225696175\|gb\|FJ805842.1\|	259957	g714	i0	92.913	105.193610842207	1030	69	99	4	3	1030	3106	2079	Uncultured Chroococcidiopsis sp. clone AU1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	108665	1495	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21817485	21817485	PRJEB81463_P_NODE_9318_length_330_cov_1.214008_g9046_i0	PRJEB81463	9318	330	1.214008	4.0062264	cyanobacterium NIES-36	2510787	Bacteria	Bacteria	499	9.23e-137	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g9046	i0	93.994	183.715151515152	333	15	100	5	1	330	816	486	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	60626	499	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
23949776	23949776	PRJEB81463_P_NODE_14579_length_279_cov_1.514563_g14307_i0	PRJEB81463	14579	279	1.514563	4.22563077	root	1	Root_unresolved	Root_unresolved	510	3.5299999999999996e-140	NTclustered	gi\|691483284\|gb\|KM006898.1\|	1211	g14307	i0	99.642	98.8028673835125	279	1	100	0	1	279	170	448	Uncultured cyanobacterium clone 3B-31 16S ribosomal RNA gene, partial sequence	blastn	27566	510	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);;