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

15 rows where analysis = "blastn", bioproject = "PRJNA509429" 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
485174	485174	PRJNA509429_P_NODE_2761_length_849_cov_5.229730_g2262_i0	PRJNA509429	2761	849	5.22973	44.4004077	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1086	0	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g2262	i0	89.825	151.563015312132	855	75	100	9	1	849	2439	3287	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	128677	1086	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
485189	485189	PRJNA509429_P_NODE_30861_length_219_cov_6.771739_g30033_i0	PRJNA509429	30861	219	6.771739	14.83010841	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	401	1.6699999999999995e-107	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g30033	i0	100	147.945205479452	217	0	99	0	3	219	514	298	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	32400	401	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
1110761	1110761	PRJNA509429_P_NODE_1941_length_995_cov_29.293750_g1538_i1	PRJNA509429	1941	995	29.29375	291.4728125	Nostoc	1177	Bacteria	Bacteria	1131	0	NTclustered	gi\|953508392\|dbj\|AP017295.1\|	1751286	g1538	i1	87.351	286.329648241206	1004	106	100	20	1	995	1522967	1521976	Nostoc sp. NIES-3756 DNA, complete genome	blastn	284898	1133	0.998234774933804	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-3756
4312087	4312087	PRJNA509429_P_NODE_1564_length_1092_cov_21.068117_g1219_i0	PRJNA509429	1564	1092	21.068117	230.06383764	Leptolyngbya sp. BL-A-14	3104317	Bacteria	Bacteria	706	0	NTclustered	gi\|2804745243\|gb\|CP166621.1\|	3104317	g1219	i0	79.141	119.973443223443	1117	161	99	63	1	1088	1777378	1778451	MAG: Leptolyngbya sp. BL-A-14 chromosome, complete genome	blastn	131011	706	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. BL-A-14
4312133	4312133	PRJNA509429_P_NODE_32204_length_213_cov_1.219101_g31376_i0	PRJNA509429	32204	213	1.219101	2.59668513	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	267	6.149999999999999e-67	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g31376	i0	89.302	159.924882629108	215	20	100	3	1	213	3681934	3682147	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	34064	267	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
4939001	4939001	PRJNA509429_P_NODE_2324_length_921_cov_5.344244_g1877_i0	PRJNA509429	2324	921	5.344244	49.22048724	Nostoc	1177	Bacteria	Bacteria	1223	0	NTclustered	gi\|1468713264\|gb\|CP031941.1\|	446679	g1877	i0	90.733	135.203040173724	928	71	99	14	1	917	55201	56124	Nostoc sphaeroides strain Kutzing En chromosome, complete genome	blastn	124522	1234	0.991085899513776	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sphaeroides
8138358	8138358	PRJNA509429_P_NODE_44367_length_168_cov_1.030075_g43539_i0	PRJNA509429	44367	168	1.030075	1.730526	Synechococcus sp. SynAce01	1916956	Bacteria	Bacteria	217	4.73e-52	NTclustered	gi\|1104554094\|gb\|CP018091.1\|	1916956	g43539	i0	89.881	145.25	168	17	100	0	1	168	798341	798174	Synechococcus sp. SynAce01 chromosome, complete genome	blastn	24402	217	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. SynAce01
10039325	10039325	PRJNA509429_P_NODE_42048_length_174_cov_4.064748_g41220_i0	PRJNA509429	42048	174	4.064748	7.07266152	Oscillatoriales	1150	Bacteria	Bacteria	316	4.7e-82	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g41220	i0	99.425	153.885057471264	174	1	100	0	1	174	1755	1928	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	26776	316	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
10689013	10689013	PRJNA509429_P_NODE_37889_length_188_cov_3.202614_g37061_i0	PRJNA509429	37889	188	3.202614	6.02091432	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	309	8.66e-80	NTclustered	gi\|225696185\|gb\|FJ805852.1\|	259957	g37061	i0	96.757	203.095744680851	185	6	98	0	4	188	1844	1660	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	38182	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12589723	12589723	PRJNA509429_P_NODE_40450_length_179_cov_3.194444_g39622_i0	PRJNA509429	40450	179	3.194444	5.71805476	Nostoc	1177	Bacteria	Bacteria	331	1.74e-86	NTclustered	gi\|1796909370\|gb\|CP046703.1\|	76335	g39622	i0	100	260.804469273743	179	0	100	0	1	179	3058429	3058607	Nostoc sp. ATCC 53789 chromosome, complete genome	blastn	46684	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. ATCC 53789
13239171	13239171	PRJNA509429_P_NODE_38771_length_185_cov_2.126667_g37943_i0	PRJNA509429	38771	185	2.126667	3.93433395	Limnothrix sp. BL-A-16	3104318	Bacteria	Bacteria	113	7.14e-21	NTclustered	gi\|2804687704\|gb\|CP166615.1\|	3104318	g37943	i0	80.645	76.0756756756757	155	23	82	7	34	185	3045091	3045241	MAG: Limnothrix sp. BL-A-16 chromosome, complete genome	blastn	14074	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Limnothrix	Limnothrix sp. BL-A-16
18336980	18336980	PRJNA509429_P_NODE_50995_length_152_cov_0.957265_g50167_i0	PRJNA509429	50995	152	0.957265	1.4550428	Nostoc sp. UHCC 0702	2814655	Bacteria	Bacteria	196	5.429999999999999e-46	NTclustered	gi\|1996588181\|gb\|CP071065.1\|	2814655	g50167	i0	90.132	25.6842105263158	152	14	100	1	1	152	6760723	6760573	Nostoc sp. UHCC 0702 chromosome, complete genome	blastn	3904	196	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0702
18962375	18962375	PRJNA509429_P_NODE_29075_length_230_cov_2.169231_g28247_i0	PRJNA509429	29075	230	2.169231	4.9892313	root	1	Root_unresolved	Root_unresolved	425	1.05e-114	NTclustered	gi\|54398233\|gb\|AY398618.2\|	1211	g28247	i0	100	107.530434782609	230	0	100	0	1	230	602	373	Uncultured cyanobacterium clone Dpcom152 16S ribosomal RNA gene, partial sequence	blastn	24732	425	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
20887267	20887267	PRJNA509429_P_NODE_22977_length_273_cov_3.180672_g22149_i0	PRJNA509429	22977	273	3.180672	8.68323456	Aliterella chasmolithica	2739056	Bacteria	Bacteria	370	6.09e-98	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g22149	i0	91.209	119.062271062271	273	22	99	2	1	272	2276	2005	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	32504	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
22787793	22787793	PRJNA509429_P_NODE_1938_length_996_cov_5.652445_g1538_i0	PRJNA509429	1938	996	5.652445	56.2983522	Oscillatoriales	1150	Bacteria	Bacteria	1210	0	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g1538	i0	88.767	277.434738955823	1006	89	100	18	1	996	2722	1731	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	276325	1219	0.992616899097621	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium

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