metadata: contig_metadata: 17 rows where bioproject = "PRJEB80557" and tax_clade = "Cyanobacteriota/Melainabacteria group"

17 rows where bioproject = "PRJEB80557" 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
996535	996535	PRJEB80557_S_NODE_28721_length_180_cov_2.320611_g28325_i0	PRJEB80557	28721	180	2.320611	4.1770998	Planktothrix	54304	Bacteria	Bacteria	333	4.87e-87	NTclustered	gi\|2261196917\|emb\|LR882969.1\|	1160	g28325	i0	100	13.0111111111111	180	0	100	0	1	180	1339606	1339427	Planktothrix agardhii strain PCC 7811 genome assembly, chromosome: I	blastn	2342	333	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
3965196	3965196	PRJEB80557_S_NODE_17944_length_223_cov_1.494253_g17548_i0	PRJEB80557	17944	223	1.494253	3.33218419	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	359	1.04e-94	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g17548	i0	95.928	197.632286995516	221	9	99	0	1	221	1777	1557	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	44072	359	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5241803	5241803	PRJEB80557_S_NODE_37985_length_158_cov_2.146789_g37589_i0	PRJEB80557	37985	158	2.146789	3.39192662	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	254	3.3400000000000003e-63	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g37589	i0	95.57	370.5	158	7	100	0	1	158	4626771	4626928	Leptolyngbya sp. 7M chromosome	blastn	58539	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
6099742	6099742	PRJEB80557_S_NODE_5045_length_383_cov_2.859281_g4649_i0	PRJEB80557	5045	383	2.859281	10.95104623	Cyanophyceae	3028117	Bacteria	Bacteria	643	4.739999999999999e-180	NTclustered	gi\|341941936\|gb\|JN225554.1\|	1211	g4649	i0	99.16	93.2297650130548	357	3	93	0	4	360	625	269	Uncultured cyanobacterium clone GSY-XJ20 16S ribosomal RNA gene, partial sequence	blastn	35707	643	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
20122979	20122979	PRJEB80557_S_NODE_12276_length_264_cov_1.627907_g11880_i0	PRJEB80557	12276	264	1.627907	4.29767448	Cyanophyceae	3028117	Bacteria	Bacteria	346	9.880000000000002e-91	NTclustered	gi\|2830894453\|gb\|CP170743.1\|	184925	g11880	i0	90.262	189.234848484848	267	22	100	4	1	264	1852300	1852565	Chlorogloeopsis fritschii PCC 9212 chromosome, complete genome	blastn	49958	348	0.994252873563218	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Chlorogloeopsidaceae	Chlorogloeopsis	Chlorogloeopsis fritschii
20123113	20123113	PRJEB80557_S_NODE_5436_length_372_cov_1.702786_g5040_i0	PRJEB80557	5436	372	1.702786	6.33436392	Planktothrix	54304	Bacteria	Bacteria	645	1.2799999999999994e-180	NTclustered	gi\|2261183531\|emb\|LR882963.1\|	1160	g5040	i0	99.437	11.6612903225806	355	2	95	0	18	372	879285	878931	Planktothrix agardhii strain No.66 genome assembly, chromosome: I	blastn	4338	645	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
20539979	20539979	PRJEB80557_S_NODE_18457_length_220_cov_2.257310_g18061_i0	PRJEB80557	18457	220	2.25731	4.966082	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	348	2.2200000000000005e-91	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g18061	i0	98.969	94.15	194	2	88	0	23	216	1861157	1860964	Calothrix sp. PCC 7716 DNA, complete genome	blastn	20713	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
24364910	24364910	PRJEB80557_S_NODE_2440_length_506_cov_3.479212_g2048_i0	PRJEB80557	2440	506	3.479212	17.60481272	Aliterella chasmolithica	2739056	Bacteria	Bacteria	702	0	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g2048	i0	92.813	127.571146245059	487	31	96	4	22	506	1965	2449	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	64551	702	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
24365057	24365057	PRJEB80557_S_NODE_9540_length_295_cov_1.459350_g9144_i0	PRJEB80557	9540	295	1.45935	4.3050825	Cyanophyceae	3028117	Bacteria	Bacteria	153	7.94e-41	NR	MBV8884510.1	2801880	g9144	i0	80.2	1.85084745762712	91	18	92.5	0	294	22	307	397	MBV8884510.1 type I DNA topoisomerase [Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35]	diamond	546	154	0.993506493506494	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae		Chroococcidiopsidaceae cyanobacterium CP_BM_RX_35
26907681	26907681	PRJEB80557_S_NODE_22842_length_200_cov_1.033113_g22446_i0	PRJEB80557	22842	200	1.033113	2.066226	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	89	1.14e-19	NR	MBI2995961.1	2052166	g22446	i0	80	1.65	55	11	82.5	0	36	200	79	133	MBI2995961.1 30S ribosomal protein S3 [Candidatus Melainabacteria bacterium]	diamond	330	89	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27160397	27160397	PRJEB80557_S_NODE_35942_length_164_cov_1.147826_g35546_i0	PRJEB80557	35942	164	1.147826	1.88243464	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	68.9	1.44e-12	NR	MBW4637947.1	2839657	g35546	i0	73.1	3.58536585365854	52	13	93.3	1	161	9	1	52	MBW4637947.1 hypothetical protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	588	68.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
27192148	27192148	PRJEB80557_S_NODE_18762_length_219_cov_0.917647_g18366_i0	PRJEB80557	18762	219	0.917647	2.00964693	Tolypothrix sp. Co-bin9	2768887	Bacteria	Bacteria	145	3.0299999999999996e-42	NR	MBD0265704.1	2768887	g18366	i0	100	1	73	0	100	0	1	219	54	126	MBD0265704.1 2'-5' RNA ligase family protein [Tolypothrix sp. Co-bin9]	diamond	219	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix sp. Co-bin9
27287104	27287104	PRJEB80557_S_NODE_37163_length_162_cov_0.920354_g36767_i0	PRJEB80557	37163	162	0.920354	1.49097348	Allocoleopsis sp.	3088169	Bacteria	Bacteria	57.8	3.14e-8	NR	HEY9662798.1	3088169	g36767	i0	55.1	1.85185185185185	49	22	90.7	0	158	12	41	89	HEY9662798.1 DUF1906 domain-containing protein [Allocoleopsis sp.]	diamond	300	57.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis sp.
27792523	27792523	PRJEB80557_S_NODE_18444_length_220_cov_2.444444_g18048_i0	PRJEB80557	18444	220	2.444444	5.3777768	Scytonema sp. PMC 1070.18	2684456	Bacteria	Bacteria	68.2	3.1e-11	NR	MEC4880965.1	2684456	g18048	i0	54.8	3.42272727272727	62	28	84.5	0	13	198	977	1038	MEC4880965.1 putative molybdenum carrier protein [Scytonema sp. PMC 1070.18]	diamond	753	68.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. PMC 1070.18
29276246	29276246	PRJEB80557_S_NODE_4829_length_389_cov_2.900000_g4433_i0	PRJEB80557	4829	389	2.9	11.281	Nostoc sp. CHAB 5834	2780403	Bacteria	Bacteria	71.2	1.92e-11	NR	MCC5609589.1	2780403	g4433	i0	76.1	0.354755784061697	46	11	35.5	0	66	203	471	516	MCC5609589.1 hypothetical protein [Nostoc sp. CHAB 5834]	diamond	138	71.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CHAB 5834
29710763	29710763	PRJEB80557_S_NODE_28930_length_180_cov_1.145038_g28534_i0	PRJEB80557	28930	180	1.145038	2.0610684	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	99.4	3.0099999999999995e-23	NR	WP_164929529.1	33072	g28534	i0	73.7	5.7	57	15	95	0	3	173	20	76	WP_164929529.1 TerC family protein [Gloeobacter violaceus]	diamond	1026	99.8	0.995991983967936	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeobacterales	Gloeobacteraceae	Gloeobacter	Gloeobacter violaceus
30666101	30666101	PRJEB80557_S_NODE_8513_length_310_cov_1.195402_g8117_i0	PRJEB80557	8513	310	1.195402	3.7057462	Scytonema sp. PCC 1	1204	Bacteria	Bacteria	167	1.05e-49	NR	WP_414588873.1	1680591	g8117	i0	90.2	0.987096774193548	102	10	98.7	0	3	308	1	102	WP_414588873.1 SDR family NAD(P)-dependent oxidoreductase [Scytonema sp. PCC 10023]	diamond	306	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. PCC 10023

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