metadata: contig_metadata: 18 rows where bioproject = "PRJNA1004255" and tax_clade = "Cyanobacteriota/Melainabacteria group"

18 rows where bioproject = "PRJNA1004255" 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
3979691	3979691	PRJNA1004255_S_NODE_7404_length_227_cov_7.375000_g7196_i0	PRJNA1004255	7404	227	7.375	16.74125	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	364	2.289999999999999e-96	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g7196	i0	96.396	99.0660792951542	222	7	97	1	1	221	3036	2815	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	22488	364	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5256128	5256128	PRJNA1004255_S_NODE_11245_length_191_cov_1.905405_g11037_i0	PRJNA1004255	11245	191	1.905405	3.63932355	uncultured cyanobacterium	1211	Bacteria	Bacteria	348	1.87e-91	NTclustered	gi\|691483300\|gb\|KM006914.1\|	1211	g11037	i0	99.476	73.979057591623	191	1	100	0	1	191	591	401	Uncultured cyanobacterium clone 4B-23 16S ribosomal RNA gene, partial sequence	blastn	14130	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
5256197	5256197	PRJNA1004255_S_NODE_7805_length_223_cov_2.444444_g7597_i0	PRJNA1004255	7805	223	2.444444	5.45111012	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	363	8.049999999999997e-96	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g7597	i0	95.964	173.224215246637	223	9	100	0	1	223	2057	1835	Uncultured Chroococcidiopsis sp. clone AR1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	38629	363	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9928950	9928950	PRJNA1004255_S_NODE_13448_length_176_cov_3.924812_g13240_i0	PRJNA1004255	13448	176	3.924812	6.90766912	Cyanophyceae	3028117	Bacteria	Bacteria	215	1.79e-51	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g13240	i0	88.764	182.880681818182	178	17	100	3	1	176	2378124	2377948	Nostoc sp. PCC 7120 DNA, complete genome	blastn	32187	215	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
9928973	9928973	PRJNA1004255_S_NODE_4148_length_280_cov_9.877637_g3940_i0	PRJNA1004255	4148	280	9.877637	27.6573836	Oscillatoriales	1150	Bacteria	Bacteria	518	2.12e-142	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g3940	i0	100	171.696428571429	280	0	100	0	1	280	1373525	1373246	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	48075	518	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
10356425	10356425	PRJNA1004255_S_NODE_4829_length_266_cov_4.053812_g4621_i0	PRJNA1004255	4829	266	4.053812	10.78313992	uncultured cyanobacterium	1211	Bacteria	Bacteria	427	3.4599999999999998e-115	NTclustered	gi\|298231357\|emb\|FN811228.1\|	1211	g4621	i0	99.156	101.353383458647	237	2	89	0	30	266	5	241	Uncultured cyanobacterium partial 16S rRNA gene, clone UMAB-cl-44	blastn	26960	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
13754384	13754384	PRJNA1004255_S_NODE_17771_length_154_cov_6.990991_g17563_i0	PRJNA1004255	17771	154	6.990991	10.76612614	root	1	Root_unresolved	Root_unresolved	285	1.14e-72	NTclustered	gi\|192337829\|gb\|EU751438.1\|	1211	g17563	i0	100	99.3961038961039	154	0	100	0	1	154	479	632	Uncultured cyanobacterium clone HK05-E01 16S ribosomal RNA gene, partial sequence	blastn	15307	285	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
14181936	14181936	PRJNA1004255_S_NODE_18592_length_151_cov_3.916667_g18384_i0	PRJNA1004255	18592	151	3.916667	5.91416717	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	198	1.5e-46	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g18384	i0	91.608	97.5695364238411	143	12	95	0	1	143	2806	2948	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	14733	198	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
14181973	14181973	PRJNA1004255_S_NODE_692_length_512_cov_17.622601_g485_i0	PRJNA1004255	692	512	17.622601	90.22771712	Aliterella chasmolithica	2739056	Bacteria	Bacteria	671	0	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g485	i0	91.581	109.259765625	487	39	95	2	4	489	2450	1965	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	55941	671	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
15455893	15455893	PRJNA1004255_S_NODE_2053_length_353_cov_6.487097_g1845_i0	PRJNA1004255	2053	353	6.487097	22.89945241	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	562	1.25e-155	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g1845	i0	95.455	202.067988668555	352	16	99	0	2	353	1245979	1245628	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	71330	562	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
16303494	16303494	PRJNA1004255_S_NODE_4353_length_276_cov_3.879828_g4145_i0	PRJNA1004255	4353	276	3.879828	10.70832528	Nostoc	1177	Bacteria	Bacteria	449	7.699999999999998e-122	NTclustered	gi\|2237829811\|dbj\|AP025732.1\|	449208	g4145	i0	96.014	269.315217391304	276	11	100	0	1	276	1737924	1737649	Nostoc cf. commune SO-36 DNA, complete genome	blastn	74331	449	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune
20554426	20554426	PRJNA1004255_S_NODE_2917_length_315_cov_1.790441_g2709_i0	PRJNA1004255	2917	315	1.790441	5.63988915	Nostoc sp. CENA543	1869241	Bacteria	Bacteria	191	5.99e-44	NTclustered	gi\|1334417636\|gb\|CP023278.1\|	1869241	g2709	i0	79.848	4.91428571428571	263	51	83	2	48	309	4489538	4489799	Nostoc sp. CENA543 chromosome, complete genome	blastn	1548	191	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CENA543
23105508	23105508	PRJNA1004255_S_NODE_419_length_632_cov_12.023769_g234_i0	PRJNA1004255	419	632	12.023769	75.99022008	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	965	0	NTclustered	gi\|225696255\|gb\|FJ805922.1\|	259957	g234	i0	95.114	106.92246835443	614	27	97	2	1	613	2872	2261	Uncultured Chroococcidiopsis sp. clone SA2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	67575	965	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23953340	23953340	PRJNA1004255_S_NODE_1639_length_381_cov_2.772189_g1431_i0	PRJNA1004255	1639	381	2.772189	10.56204009	Leptolyngbya	47251	Bacteria	Bacteria	507	6.45e-139	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g1431	i0	92.201	157.779527559055	359	26	94	2	2	359	248556	248199	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	60114	507	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
24379263	24379263	PRJNA1004255_S_NODE_2780_length_320_cov_3.700361_g2572_i0	PRJNA1004255	2780	320	3.700361	11.8411552	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	407	5.5599999999999995e-109	NTclustered	gi\|225696185\|gb\|FJ805852.1\|	259957	g2572	i0	89.688	158.684375	320	32	99	1	2	320	3353	3034	Uncultured Chroococcidiopsis sp. clone AR1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	50779	407	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25227199	25227199	PRJNA1004255_S_NODE_7320_length_228_cov_6.140541_g7112_i0	PRJNA1004255	7320	228	6.140541	14.00043348	Cyanophyceae	3028117	Bacteria	Bacteria	403	4.87e-108	NTclustered	gi\|939107919\|gb\|KT887919.1\|	1211	g7112	i0	99.107	99.8991228070175	224	2	98	0	5	228	1	224	Uncultured cyanobacterium isolate DGGE gel band 07UNW42a01S 16S ribosomal RNA gene, partial sequence	blastn	22777	403	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
26741728	26741728	PRJNA1004255_S_NODE_4541_length_272_cov_4.882096_g4333_i0	PRJNA1004255	4541	272	4.882096	13.27930112	Synechococcus	1129	Bacteria	Bacteria	43.1	0.0358	NR	WP_170953846.1	337067	g4333	i0	46.3	0.904411764705882	41	22	45.2	0	154	32	175	215	WP_170953846.1 FAD-binding domain-containing protein [Synechococcus sp. UW105]	diamond	246	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. UW105
28866087	28866087	PRJNA1004255_S_NODE_10288_length_199_cov_1.807692_g10080_i0	PRJNA1004255	10288	199	1.807692	3.59730708	Synechococcaceae bacterium WB4_1_0192	2448788	Bacteria	Bacteria	40.8	0.0306	NR	NBW64034.1	2448788	g10080	i0	39.2	0.768844221105528	51	29	73.9	1	10	156	7	57	NBW64034.1 hypothetical protein [Synechococcaceae bacterium WB4_1_0192]	diamond	153	40.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae		Synechococcaceae bacterium WB4_1_0192

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