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

12 rows where analysis = "blastn", bioproject = "PRJNA1174234" 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
1590803	1590803	PRJNA1174234_P_NODE_32122_length_246_cov_1.179191_g31926_i0	PRJNA1174234	32122	246	1.179191	2.90080986	Nostoc sp. C057	2576903	Bacteria	Bacteria	342	1.1799999999999997e-89	NTclustered	gi\|1866646741\|gb\|CP040281.1\|	2576903	g31926	i0	92.683	106.463414634146	246	4	100	6	1	246	443378	443609	Nostoc sp. C057 chromosome, complete genome	blastn	26190	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C057
4142990	4142990	PRJNA1174234_P_NODE_164_length_1977_cov_3.238971_g144_i0	PRJNA1174234	164	1977	3.238971	64.03445667	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	2987	0	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g144	i0	94.937	141.889731917046	1916	81	96	15	73	1977	33628	31718	Allocoleopsis franciscana PCC 7113, complete genome	blastn	280516	2987	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
4143110	4143110	PRJNA1174234_P_NODE_6124_length_550_cov_1.939203_g5928_i0	PRJNA1174234	6124	550	1.939203	10.6656165	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	894	0	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g5928	i0	96.029	153.210909090909	554	14	99	5	1	548	2626730	2626179	Allocoleopsis franciscana PCC 7113, complete genome	blastn	84266	894	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
4868998	4868998	PRJNA1174234_P_NODE_27764_length_258_cov_1.481081_g27568_i0	PRJNA1174234	27764	258	1.481081	3.82118898	Oscillatoriales	1150	Bacteria	Bacteria	435	2e-117	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g27568	i0	99.17	148.399224806202	241	2	95	0	1	241	101725	101965	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	38287	435	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
4869005	4869005	PRJNA1174234_P_NODE_33544_length_244_cov_0.900585_g33348_i0	PRJNA1174234	33544	244	0.900585	2.1974274	Nostoc	1177	Bacteria	Bacteria	291	4.28e-74	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g33348	i0	92.611	12.7786885245902	203	14	83	1	42	244	1414693	1414894	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	3118	291	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
5419203	5419203	PRJNA1174234_P_NODE_27345_length_261_cov_0.925532_g27149_i0	PRJNA1174234	27345	261	0.925532	2.41563852	Altericista sp. CCNU0014	3082949	Bacteria	Bacteria	224	4.77e-54	NTclustered	gi\|2597815757\|gb\|OR726009.1\|	3082949	g27149	i0	82.9	174.804597701149	269	26	100	19	1	261	1356	1612	Altericista sp. CCNU0014 23S ribosomal RNA gene, partial sequence	blastn	45624	224	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales		Altericista	Altericista sp. CCNU0014
7969442	7969442	PRJNA1174234_P_NODE_35527_length_241_cov_0.916667_g35331_i0	PRJNA1174234	35527	241	0.916667	2.20916747	Nostoc edaphicum	264686	Bacteria	Bacteria	370	5.27e-98	NTclustered	gi\|1883611395\|gb\|CP054698.1\|	1472755	g35331	i0	94.561	21.8257261410788	239	13	99	0	3	241	7431874	7431636	Nostoc edaphicum CCNP1411 chromosome, complete genome	blastn	5260	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc edaphicum
9244052	9244052	PRJNA1174234_P_NODE_24208_length_280_cov_1.096618_g24012_i0	PRJNA1174234	24208	280	1.096618	3.0705304	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	287	6.5e-73	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g24012	i0	85.211	37.3214285714286	284	36	100	5	1	280	2152089	2151808	Leptolyngbya sp. 7M chromosome	blastn	10450	287	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
9969043	9969043	PRJNA1174234_P_NODE_27148_length_262_cov_1.111111_g26952_i0	PRJNA1174234	27148	262	1.111111	2.91111082	Cyanophyceae	3028117	Bacteria	Bacteria	412	9.52e-111	NTclustered	gi\|1949996095\|gb\|CP046155.1\|	1115757	g26952	i0	95.057	211.709923664122	263	12	100	1	1	262	786089	785827	Leptolyngbya sp. BL0902 chromosome, complete genome	blastn	55468	412	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. BL0902
11794794	11794794	PRJNA1174234_P_NODE_4950_length_605_cov_2.270677_g4757_i0	PRJNA1174234	4950	605	2.270677	13.73759585	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	900	0	NTclustered	gi\|225696224\|gb\|FJ805891.1\|	259957	g4757	i0	93.575	108.171900826446	607	33	100	4	1	605	2440	3042	Uncultured Chroococcidiopsis sp. clone NA2_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	65444	900	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13069692	13069692	PRJNA1174234_P_NODE_21531_length_298_cov_0.875556_g21335_i0	PRJNA1174234	21531	298	0.875556	2.60915688	Aliterella chasmolithica	2739056	Bacteria	Bacteria	379	1.12e-100	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g21335	i0	90.102	119.939597315436	293	27	98	2	7	298	2287	1996	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	35742	379	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
14345007	14345007	PRJNA1174234_P_NODE_10432_length_427_cov_1.330508_g10236_i0	PRJNA1174234	10432	427	1.330508	5.68126916	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	593	5.449999999999998e-165	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g10236	i0	91.822	165.461358313817	428	32	100	3	1	427	453	28	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	70652	593	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana

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