metadata: contig_metadata: 16 rows where bioproject = "PRJEB7366" and tax_clade = "Cyanobacteriota/Melainabacteria group"

16 rows where bioproject = "PRJEB7366" 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
2685326	2685326	PRJEB7366_P_NODE_21243_length_164_cov_1.682171_g20809_i0	PRJEB7366	21243	164	1.682171	2.75876044	uncultured Cyanobacterium sp.	751952	Bacteria	Bacteria	287	3.45e-73	NTclustered	gi\|371534702\|gb\|JQ003547.1\|	751952	g20809	i0	98.171	97.1280487804878	164	3	100	0	1	164	440	277	Uncultured Cyanobacterium sp. isolate DGGE gel band 5 16S ribosomal RNA gene, partial sequence	blastn	15929	287	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Cyanobacterium	uncultured Cyanobacterium sp.
9062526	9062526	PRJEB7366_P_NODE_19448_length_173_cov_1.311594_g19014_i0	PRJEB7366	19448	173	1.311594	2.26905762	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	315	1.68e-81	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g19014	i0	99.422	169.300578034682	173	1	100	0	1	173	187	359	Uncultured Chroococcidiopsis sp. clone GKJWQY101AIMXN 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	29289	315	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19260863	19260863	PRJEB7366_P_NODE_5896_length_367_cov_2.771084_g5463_i0	PRJEB7366	5896	367	2.771084	10.16987828	Dolichospermum sp. UHCC 0315A	1914871	Bacteria	Bacteria	82.4	4.45e-11	NTclustered	gi\|1731522919\|gb\|CP043056.1\|	1914871	g5463	i0	86.486	8.35422343324251	74	10	20	0	134	207	2228239	2228166	Dolichospermum sp. UHCC 0315A chromosome, complete genome	blastn	3066	82.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp. UHCC 0315A
20536137	20536137	PRJEB7366_P_NODE_15497_length_198_cov_1.625767_g15063_i0	PRJEB7366	15497	198	1.625767	3.21901866	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	322	1.18e-83	NTclustered	gi\|1280084619\|gb\|MF574181.1\|	119533	g15063	i0	95.96	188.80303030303	198	8	100	0	1	198	5110	4913	Scytonema hyalinum rrn type 1 operon, precursor RNA and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, 23S ribosomal RNA, 23S-5S ITS, and 5S ribosomal RNA genes, complete sequence	blastn	37383	322	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
21812015	21812015	PRJEB7366_P_NODE_19858_length_171_cov_1.176471_g19424_i0	PRJEB7366	19858	171	1.176471	2.01176541	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	72.4	3.11e-13	NR	MFN8674480.1	2762020	g19424	i0	67.3	2.7719298245614	52	17	91.2	0	167	12	267	318	MFN8674480.1 transaldolase [Candidatus Sericytochromatia bacterium]	diamond	474	72.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
24361061	24361061	PRJEB7366_P_NODE_15600_length_197_cov_1.783951_g15166_i0	PRJEB7366	15600	197	1.783951	3.51438347	Bacteria	2	Bacteria	Bacteria	76.3	2.08e-14	NR	WP_303674415.1	758823	g15166	i0	58.1	11.9847715736041	62	26	94.4	0	197	12	278	339	WP_303674415.1 adenosine deaminase [Vampirovibrio chlorellavorus]	diamond	2361	77	0.990909090909091	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales		Vampirovibrio	Vampirovibrio chlorellavorus
24361076	24361076	PRJEB7366_P_NODE_21840_length_161_cov_3.317460_g21406_i0	PRJEB7366	21840	161	3.31746	5.3411106	Planktothrix agardhii	1160	Bacteria	Bacteria	60.1	4.66e-10	NR	MCF3574114.1	2884176	g21406	i0	69.8	1.58385093167702	43	13	80.1	0	160	32	9	51	MCF3574114.1 hypothetical protein [Planktothrix agardhii 1812]	diamond	255	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
29465326	29465326	PRJEB7366_P_NODE_24570_length_151_cov_1.379310_g24136_i0	PRJEB7366	24570	151	1.37931	2.0827581	Aerosakkonema funiforme	1246630	Bacteria	Bacteria	73.2	1.97e-13	NR	WP_190465238.1	1246630	g24136	i0	60	0.993377483443709	50	20	99.3	0	2	151	58	107	WP_190465238.1 colicin uptake protein [Aerosakkonema funiforme]	diamond	150	73.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Aerosakkonematales	Aerosakkonemataceae	Aerosakkonema	Aerosakkonema funiforme
29489921	29489921	PRJEB7366_P_NODE_17890_length_181_cov_2.458904_g17456_i0	PRJEB7366	17890	181	2.458904	4.45061624	Cyanophyceae	3028117	Bacteria	Bacteria	63.5	2.36e-10	NR	MFM6407101.1	1127	g17456	i0	61.9	2.08839779005525	42	16	69.6	0	180	55	3	44	MFM6407101.1 tetratricopeptide repeat protein [Microcystis sp.]	diamond	378	63.9	0.993740219092332	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp.
29900697	29900697	PRJEB7366_P_NODE_19271_length_174_cov_1.151079_g18837_i0	PRJEB7366	19271	174	1.151079	2.00287746	Tolypothrix	111782	Bacteria	Bacteria	50.1	3.42e-5	NR	MBW4480428.1	2835095	g18837	i0	52.3	1.68965517241379	44	20	75.9	1	152	21	194	236	MBW4480428.1 DUF4114 domain-containing protein [Tolypothrix brevis GSE-NOS-MK-07-07A]	diamond	294	50.4	0.994047619047619	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix brevis
30097229	30097229	PRJEB7366_P_NODE_24512_length_151_cov_1.379310_g24078_i0	PRJEB7366	24512	151	1.37931	2.0827581	Leptolyngbya sp. BL-A-14	3104317	Bacteria	Bacteria	48.5	8.58e-5	NR	XGV97451.1	3104317	g24078	i0	48.8	2.68211920529801	43	21	85.4	1	22	150	6	47	XGV97451.1 MAG: DUF6875 domain-containing protein [Leptolyngbya sp. BL-A-14]	diamond	405	48.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. BL-A-14
30697556	30697556	PRJEB7366_P_NODE_7594_length_313_cov_1.910072_g7160_i0	PRJEB7366	7594	313	1.910072	5.97852536	Stanieria sp. NIES-3757	1807358	Bacteria	Bacteria	49.7	2.41e-4	NR	BAU62978.1	1807358	g7160	i0	36.5	0.996805111821086	104	50	99.7	2	1	312	128	215	BAU62978.1 hypothetical protein STA3757_03310 [Stanieria sp. NIES-3757]	diamond	312	49.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria sp. NIES-3757
31202702	31202702	PRJEB7366_P_NODE_21275_length_164_cov_1.550388_g20841_i0	PRJEB7366	21275	164	1.550388	2.54263632	Planktothrix prolifica	54307	Bacteria	Bacteria	63.2	1e-10	NR	WP_052349574.1	54307	g20841	i0	63.5	1.90243902439024	52	18	95.1	1	5	160	56	106	WP_052349574.1 profilin [Planktothrix prolifica]	diamond	312	63.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix prolifica
31544000	31544000	PRJEB7366_P_NODE_6076_length_360_cov_1.353846_g5643_i0	PRJEB7366	6076	360	1.353846	4.8738456	Nostoc	1177	Bacteria	Bacteria	46.2	0.00882	NR	WP_335104626.1	1180	g5643	i0	34.4	1.625	64	42	53.3	0	5	196	2635	2698	WP_335104626.1 amino acid adenylation domain-containing protein, partial [Nostoc sp.]	diamond	585	46.6	0.991416309012876	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
31993941	31993941	PRJEB7366_P_NODE_13958_length_212_cov_0.903955_g13524_i0	PRJEB7366	13958	212	0.903955	1.9163846	Candidatus Tanganyikabacteria bacterium	2961651	Bacteria	Bacteria	43.1	0.0165	NR	MBM3268983.1	2961651	g13524	i0	40.3	0.877358490566038	62	29	76.4	1	170	9	68	129	MBM3268983.1 2-phosphosulfolactate phosphatase [Candidatus Tanganyikabacteria bacterium]	diamond	186	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Tanganyikabacteria bacterium
32215525	32215525	PRJEB7366_P_NODE_19538_length_172_cov_2.919708_g19104_i0	PRJEB7366	19538	172	2.919708	5.02189776	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	98.2	1.04e-22	NR	MDR2430851.1	2053573	g19104	i0	89.3	7.79651162790698	56	6	97.7	0	170	3	247	302	MDR2430851.1 type I glyceraldehyde-3-phosphate dehydrogenase [Candidatus Margulisiibacteriota bacterium]	diamond	1341	98.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium

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