metadata: contig_metadata: 15 rows where bioproject = "PRJNA683902" and tax_clade = "Cyanobacteriota/Melainabacteria group"

15 rows where bioproject = "PRJNA683902" 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
665220	665220	PRJNA683902_S_NODE_18141_length_258_cov_2.868778_g17697_i0	PRJNA683902	18141	258	2.868778	7.40144724	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	350	7.44e-92	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g17697	i0	91.085	442.480620155039	258	23	100	0	1	258	3680042	3679785	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	114160	350	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
4493384	4493384	PRJNA683902_S_NODE_6624_length_722_cov_18.000000_g6265_i0	PRJNA683902	6624	722	18	129.96	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	977	0	NTclustered	gi\|225696219\|gb\|FJ805886.1\|	259957	g6265	i0	91.233	143.41135734072	730	46	100	17	1	722	2652	1933	Uncultured Chroococcidiopsis sp. clone NA4_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	103543	977	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5769010	5769010	PRJNA683902_S_NODE_39005_length_152_cov_2.026087_g38561_i0	PRJNA683902	39005	152	2.026087	3.07965224	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	182	1.52e-41	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g38561	i0	88.742	133.368421052632	151	14	99	3	3	152	3682302	3682154	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	20272	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
14694448	14694448	PRJNA683902_S_NODE_8612_length_543_cov_20.990119_g8194_i0	PRJNA683902	8612	543	20.990119	113.97634617	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	861	0	NTclustered	gi\|225696252\|gb\|FJ805919.1\|	259957	g8194	i0	95.749	120.206261510129	541	12	98	10	14	543	1562	2102	Uncultured Chroococcidiopsis sp. clone A1_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	65272	861	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15967873	15967873	PRJNA683902_S_NODE_11773_length_386_cov_12.836676_g11329_i0	PRJNA683902	11773	386	12.836676	49.54956936	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	538	2.3199999999999993e-148	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g11329	i0	93.629	97.0673575129534	361	21	93	2	1	359	2141	1781	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	37468	538	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
17243127	17243127	PRJNA683902_S_NODE_15174_length_303_cov_24.364662_g14730_i0	PRJNA683902	15174	303	24.364662	73.82492586	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	462	1.1e-125	NTclustered	gi\|225696250\|gb\|FJ805917.1\|	259957	g14730	i0	94.098	163.970297029703	305	16	100	1	1	303	2988	2684	Uncultured Chroococcidiopsis sp. clone A1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	49683	462	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
17243197	17243197	PRJNA683902_S_NODE_22254_length_220_cov_1.918033_g21810_i0	PRJNA683902	22254	220	1.918033	4.2196726	Moorena producens	1155739	Bacteria	Bacteria	60.2	1.16e-4	NTclustered	gi\|2412135964\|gb\|CP017708.2\|	1454205	g21810	i0	100	0.609090909090909	32	0	15	0	128	159	8473007	8473038	Moorena producens JHB chromosome, complete genome	blastn	134	60.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena	Moorena producens
17243224	17243224	PRJNA683902_S_NODE_24954_length_203_cov_2.102410_g24510_i0	PRJNA683902	24954	203	2.10241	4.2678923	Thalassoporum mexicanum	3457544	Bacteria	Bacteria	76.8	1.05e-9	NTclustered	gi\|427988066\|gb\|CP003592.1\|	82654	g24510	i0	91.071	1.10344827586207	56	5	28	0	147	202	1760284	1760339	Pseudanabaena sp. PCC 7367, complete genome	blastn	224	76.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Thalassoporaceae	Thalassoporum	Thalassoporum mexicanum
18517497	18517497	PRJNA683902_S_NODE_38435_length_153_cov_3.008621_g37991_i0	PRJNA683902	38435	153	3.008621	4.60319013	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	178	1.98e-40	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g37991	i0	87.582	106.830065359477	153	19	100	0	1	153	3680962	3681114	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	16345	178	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
18517545	18517545	PRJNA683902_S_NODE_6315_length_759_cov_24.490305_g5975_i0	PRJNA683902	6315	759	24.490305	185.88141495	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1336	0	NTclustered	gi\|225696219\|gb\|FJ805886.1\|	259957	g5975	i0	98.421	123.00395256917	760	11	100	1	1	759	1933	2692	Uncultured Chroococcidiopsis sp. clone NA4_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	93360	1336	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19026893	19026893	PRJNA683902_S_NODE_15675_length_294_cov_14.996109_g15231_i0	PRJNA683902	15675	294	14.996109	44.08856046	Chroococcidiopsidales	1890505	Bacteria	Bacteria	538	1.7199999999999995e-148	NTclustered	gi\|442539708\|gb\|KC218853.1\|	1211	g15231	i0	99.66	102.061224489796	294	1	100	0	1	294	432	139	Uncultured cyanobacterium clone NAT29 16S ribosomal RNA gene, partial sequence	blastn	30006	538	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
21067786	21067786	PRJNA683902_S_NODE_30837_length_175_cov_3.333333_g30393_i0	PRJNA683902	30837	175	3.333333	5.83333275	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	213	6.39e-51	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g30393	i0	89.017	121.36	173	17	98	2	4	175	3162	2991	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	21238	213	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
24891298	24891298	PRJNA683902_S_NODE_12500_length_363_cov_3.914110_g12056_i0	PRJNA683902	12500	363	3.91411	14.2082193	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	477	4.789999999999998e-130	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g12056	i0	92.105	162.446280991736	342	21	94	6	23	363	2151833	2151497	Leptolyngbya sp. 7M chromosome	blastn	58968	477	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
28408667	28408667	PRJNA683902_S_NODE_22706_length_217_cov_1.588889_g22262_i0	PRJNA683902	22706	217	1.588889	3.44788913	Richelia intracellularis HH	1164990	Bacteria	Bacteria	131	6.389999999999999e-38	NR	CCH68009.1	1165094	g22262	i0	98.3	0.829493087557604	60	1	82.9	0	216	37	33	92	CCH68009.1 hypothetical protein RINTHH_18540 [Richelia intracellularis HH01]	diamond	180	131	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia intracellularis
29671218	29671218	PRJNA683902_S_NODE_31290_length_174_cov_1.394161_g30846_i0	PRJNA683902	31290	174	1.394161	2.42584014	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	60.5	1.84e-9	NR	MBX9724270.1	2364082	g30846	i0	93.3	0.517241379310345	30	2	51.7	0	2	91	141	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	90	60.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales 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);;