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

11 rows where analysis = "blastn", bioproject = "PRJNA640143" 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
3160915	3160915	PRJNA640143_S_NODE_2583_length_486_cov_37.138085_g2402_i0	PRJNA640143	2583	486	37.138085	180.4910931	Aliterella chasmolithica	2739056	Bacteria	Bacteria	627	6.189999999999998e-175	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g2402	i0	91.63	115.843621399177	454	36	93	2	34	486	1965	2417	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	56300	627	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
3707113	3707113	PRJNA640143_S_NODE_28923_length_162_cov_1.328000_g28713_i0	PRJNA640143	28923	162	1.328	2.15136	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	237	3.47e-58	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g28713	i0	93.168	134.722222222222	161	11	99	0	1	161	5577607	5577447	Anabaena sp. YBS01 chromosome, complete genome	blastn	21825	237	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
5713778	5713778	PRJNA640143_S_NODE_5605_length_350_cov_3.926518_g5395_i0	PRJNA640143	5605	350	3.926518	13.742813	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	503	7.59e-138	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g5395	i0	92.635	150.485714285714	353	20	99	3	1	349	2033	2383	Uncultured Chroococcidiopsis sp. clone AS3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	52670	503	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9538351	9538351	PRJNA640143_S_NODE_18728_length_202_cov_11.563636_g18518_i0	PRJNA640143	18728	202	11.563636	23.35854472	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	292	9.52e-75	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g18518	i0	98.204	2.21287128712871	167	3	83	0	1	167	5032591	5032425	Calothrix sp. PCC 7716 DNA, complete genome	blastn	447	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
16458148	16458148	PRJNA640143_S_NODE_17973_length_206_cov_17.147929_g17763_i0	PRJNA640143	17973	206	17.147929	35.32473374	Bacteria	2	Bacteria	Bacteria	307	3.4800000000000004e-79	NTclustered	gi\|315190017\|gb\|HQ595208.1\|	1211	g17763	i0	100	117.776699029126	166	0	81	0	41	206	1	166	Uncultured cyanobacterium clone IC3040 16S ribosomal RNA gene, partial sequence	blastn	24262	307	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
21012368	21012368	PRJNA640143_S_NODE_25397_length_175_cov_2.224638_g25187_i0	PRJNA640143	25397	175	2.224638	3.8931165	Gloeocapsopsis crepidinum	693223	Bacteria	Bacteria	172	1.08e-38	NTclustered	gi\|2112847628\|emb\|OU815587.1\|	693223	g25187	i0	84.483	18.5142857142857	174	27	99	0	1	174	345	172	Gloeocapsopsis crepidinum cpcB gene for C-phycocyanin beta chain, strain CCAP 1425/1	blastn	3240	172	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis crepidinum
22832763	22832763	PRJNA640143_S_NODE_11658_length_253_cov_11.893519_g11448_i0	PRJNA640143	11658	253	11.893519	30.09060307	Drouetiella	2303513	Bacteria	Bacteria	351	2.02e-92	NTclustered	gi\|2312649307\|gb\|OP577847.1\|	2983374	g11448	i0	96.279	144.928853754941	215	6	84	2	6	218	2121	1907	Drouetiella lurida ACKU666 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36667	351	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella lurida
22832840	22832840	PRJNA640143_S_NODE_2198_length_519_cov_4.788382_g2042_i0	PRJNA640143	2198	519	4.788382	24.85170258	Microcystis	1125	Bacteria	Bacteria	553	1.1399999999999995e-152	NTclustered	gi\|2164481301\|gb\|CP089094.1\|	267865	g2042	i0	86.747	148.400770712909	498	64	96	2	1	498	4186376	4186871	Microcystis aeruginosa FACHB-905 = DIANCHI905 chromosome, complete genome	blastn	77020	553	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
23562787	23562787	PRJNA640143_S_NODE_4959_length_369_cov_3.701807_g4749_i0	PRJNA640143	4959	369	3.701807	13.65966783	Drouetiella epilithica	3059494	Bacteria	Bacteria	555	2.1899999999999999e-153	NTclustered	gi\|2312649311\|gb\|OP577851.1\|	2983373	g4749	i0	96.429	119.457994579946	336	12	91	0	1	336	2438	2103	Drouetiella epilithica ACKU670 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	44080	555	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Drouetiella	Drouetiella epilithica
23562805	23562805	PRJNA640143_S_NODE_5559_length_351_cov_106.149682_g5349_i0	PRJNA640143	5559	351	106.149682	372.58538382	Cyanobacteria bacterium K4m	2830641	Bacteria	Bacteria	388	2.23e-103	NTclustered	gi\|2029258269\|gb\|MZ020199.1\|	2830641	g5349	i0	92.91	171.680911680912	268	17	76	1	36	301	1234	1501	Cyanobacteria bacterium K4m 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	60260	388	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium K4m
25381760	25381760	PRJNA640143_S_NODE_19460_length_199_cov_1.444444_g19250_i0	PRJNA640143	19460	199	1.444444	2.87444356	Nostoc	1177	Bacteria	Bacteria	62.1	2.87e-5	NTclustered	gi\|953508392\|dbj\|AP017295.1\|	1751286	g19250	i0	88.679	0.683417085427136	53	3	25	2	1	50	1081594	1081646	Nostoc sp. NIES-3756 DNA, complete genome	blastn	136	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-3756

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