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

12 rows where analysis = "blastn", bioproject = "PRJNA1034995" 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
168290	168290	PRJNA1034995_S_NODE_13141_length_570_cov_154.489564_g13006_i0	PRJNA1034995	13141	570	154.489564	880.5905148	Aliterella chasmolithica	2739056	Bacteria	Bacteria	656	0	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g13006	i0	91.134	133.694736842105	485	41	85	2	15	498	2424	1941	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	76206	656	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
168380	168380	PRJNA1034995_S_NODE_23261_length_338_cov_8.027119_g23105_i0	PRJNA1034995	23261	338	8.027119	27.13166222	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	292	1.73e-74	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g23105	i0	83.486	89.8491124260355	327	41	94	10	10	328	6831653	6831974	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	30369	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
2718943	2718943	PRJNA1034995_S_NODE_36543_length_224_cov_6.541436_g36387_i0	PRJNA1034995	36543	224	6.541436	14.65281664	Calothrix parasitica	1973486	Bacteria	Bacteria	58.4	4.28e-4	NTclustered	gi\|1210161462\|dbj\|AP018227.1\|	1973488	g36387	i0	88	3.07142857142857	50	4	21	2	30	77	3851938	3851889	Calothrix parasitica NIES-267 DNA, nearly complete genome	blastn	688	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix parasitica
2718973	2718973	PRJNA1034995_S_NODE_42243_length_194_cov_3.927152_g42087_i0	PRJNA1034995	42243	194	3.927152	7.61867488	Calothrix sp. PCC 6303	1170562	Bacteria	Bacteria	187	4.4e-43	NTclustered	gi\|428233323\|gb\|CP003610.1\|	1170562	g42087	i0	86.471	56.4587628865979	170	23	88	0	25	194	735239	735408	Calothrix sp. PCC 6303, complete genome	blastn	10953	187	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
6110890	6110890	PRJNA1034995_S_NODE_44325_length_185_cov_2.091549_g44169_i0	PRJNA1034995	44325	185	2.091549	3.86936565	Nostoc	1177	Bacteria	Bacteria	148	1.96e-31	NTclustered	gi\|1210235159\|dbj\|AP018289.1\|	2005458	g44169	i0	87.121	3.21081081081081	132	15	70	1	56	185	83827	83696	Nostoc sp. NIES-4103 plasmid plasmid1 DNA, nearly complete genome	blastn	594	148	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-4103
7821171	7821171	PRJNA1034995_S_NODE_45347_length_181_cov_2.000000_g45191_i0	PRJNA1034995	45347	181	2	3.62	Nostoc sp. TCL26-01	2576904	Bacteria	Bacteria	89.8	1.17e-13	NTclustered	gi\|1866654106\|gb\|CP040297.1\|	2576904	g45191	i0	85.227	3.7292817679558	88	11	48	2	2	88	5256646	5256732	Nostoc sp. TCL26-01 chromosome, complete genome	blastn	675	89.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. TCL26-01
9096030	9096030	PRJNA1034995_S_NODE_33548_length_243_cov_4.830000_g33392_i0	PRJNA1034995	33548	243	4.83	11.7369	Leptolyngbya sp. NK1-12	2547451	Bacteria	Bacteria	322	1.51e-83	NTclustered	gi\|2591945363\|gb\|CP053586.1\|	2547451	g33392	i0	92.825	147.510288065844	223	15	91	1	1	222	450599	450821	Leptolyngbya sp. NK1-12 chromosome 1, complete sequence	blastn	35845	322	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NK1-12
16310085	16310085	PRJNA1034995_S_NODE_39253_length_208_cov_127.636364_g39097_i0	PRJNA1034995	39253	208	127.636364	265.48363712	Bacteria	2	Bacteria	Bacteria	329	7.52e-86	NTclustered	gi\|192337910\|gb\|EU751519.1\|	1211	g39097	i0	100	85.5721153846154	178	0	86	0	31	208	273	450	Uncultured cyanobacterium clone HK03-F07 16S ribosomal RNA gene, partial sequence	blastn	17799	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
19294228	19294228	PRJNA1034995_S_NODE_28396_length_283_cov_14.850000_g28240_i0	PRJNA1034995	28396	283	14.85	42.0255	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	230	1.1199999999999998e-55	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g28240	i0	84.016	60.2579505300353	244	34	86	4	42	283	3681220	3680980	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	17053	230	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
21845301	21845301	PRJNA1034995_S_NODE_24958_length_317_cov_27.875912_g24802_i0	PRJNA1034995	24958	317	27.875912	88.36664104	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	370	7.22e-98	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g24802	i0	89.456	152.08832807571	294	29	92	2	3	295	3150	2858	Uncultured Chroococcidiopsis sp. clone SA1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	48212	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22684475	22684475	PRJNA1034995_S_NODE_21958_length_354_cov_257.205788_g21802_i0	PRJNA1034995	21958	354	257.205788	910.50848952	Bacteria	2	Bacteria	Bacteria	592	1.5999999999999996e-164	NTclustered	gi\|199584193\|gb\|FJ028685.1\|	1211	g21802	i0	100	87.6610169491525	320	0	90	0	1	320	320	1	Uncultured cyanobacterium clone SSB-42 16S ribosomal RNA gene, partial sequence	blastn	31032	592	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
23120836	23120836	PRJNA1034995_S_NODE_9519_length_2431_cov_57.572446_g9518_i0	PRJNA1034995	9519	2431	57.572446	1399.58616226	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1818	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g9518	i0	93.485	103.535582064994	1228	73	99	5	1194	2416	1687	2912	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	251695	1818	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.

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