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

15 rows where bioproject = "PRJEB49404" 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
3929810	3929810	PRJEB49404_P_NODE_355524_length_233_cov_1.994845_g341723_i0	PRJEB49404	355524	233	1.994845	4.64798885	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	381	2.3399999999999995e-101	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g341723	i0	96.154	162.523605150215	234	7	100	2	1	233	1753	1521	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	37868	381	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7368476	7368476	PRJEB49404_P_NODE_247506_length_302_cov_5.718631_g233705_i0	PRJEB49404	247506	302	5.718631	17.27026562	Bacteria	2	Bacteria	Bacteria	446	1.0999999999999995e-120	NTclustered	gi\|325515184\|gb\|HQ912222.1\|	1211	g233705	i0	93.399	103.400662251656	303	17	99	3	1	301	5	306	Uncultured cyanobacterium clone BacR91 16S ribosomal RNA gene, partial sequence	blastn	31227	446	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
7747968	7747968	PRJEB49404_P_NODE_180627_length_378_cov_2.418879_g166831_i0	PRJEB49404	180627	378	2.418879	9.14336262	Nostoc sp. C117	3349875	Bacteria	Bacteria	462	1.4e-125	NTclustered	gi\|2831016856\|gb\|CP170991.1\|	3349875	g166831	i0	93.082	227.12962962963	318	18	84	4	2	318	147302	147616	Nostoc sp. C117 chromosome, complete genome	blastn	85855	462	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C117
9045617	9045617	PRJEB49404_P_NODE_75988_length_698_cov_7.860395_g15558_i5	PRJEB49404	75988	698	7.860395	54.8655571	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1016	0	NTclustered	gi\|225696229\|gb\|FJ805896.1\|	259957	g15558	i5	93.059	110.919770773639	706	31	100	13	1	698	2600	3295	Uncultured Chroococcidiopsis sp. clone NA2_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	77422	1016	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9919120	9919120	PRJEB49404_P_NODE_197268_length_355_cov_3.693038_g183469_i0	PRJEB49404	197268	355	3.693038	13.1102849	root	1	Root_unresolved	Root_unresolved	656	0	NTclustered	gi\|238632324\|gb\|FJ967932.1\|	1211	g183469	i0	100	100.997183098592	355	0	100	0	1	355	783	429	Uncultured cyanobacterium clone BAC_2_G07 16S ribosomal RNA (rrn) gene, partial sequence	blastn	35854	656	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
16688044	16688044	PRJEB49404_P_NODE_514134_length_178_cov_1.741007_g500333_i0	PRJEB49404	514134	178	1.741007	3.09899246	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	182	1.84e-41	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g500333	i0	85.795	713.415730337079	176	19	98	5	5	178	3680305	3680134	Leptolyngbya sp. 7M chromosome	blastn	126988	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
20501116	20501116	PRJEB49404_P_NODE_28137_length_1392_cov_8.947524_g15558_i1	PRJEB49404	28137	1392	8.947524	124.54953408	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	2030	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g15558	i1	92.99	111.63433908046	1398	88	99	8	1	1391	3027	1633	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	155395	2030	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22668064	22668064	PRJEB49404_P_NODE_605158_length_158_cov_1.991597_g591357_i0	PRJEB49404	605158	158	1.991597	3.14672326	root	1	Root_unresolved	Root_unresolved	292	7.07e-75	NTclustered	gi\|389547084\|gb\|JQ402012.1\|	1211	g591357	i0	100	100	158	0	100	0	1	158	180	23	Uncultured cyanobacterium clone CNY_02268 16S ribosomal RNA gene, partial sequence	blastn	15800	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
23059475	23059475	PRJEB49404_P_NODE_435179_length_201_cov_1.524691_g421378_i0	PRJEB49404	435179	201	1.524691	3.06462891	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	265	2.06e-66	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g421378	i0	90.547	106.388059701493	201	18	100	1	1	201	2795	2994	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	21384	265	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
26907001	26907001	PRJEB49404_P_NODE_439782_length_199_cov_2.612500_g425981_i0	PRJEB49404	439782	199	2.6125	5.198875	Synechococcus sp. CCY	1131	Bacteria	Bacteria	91.3	1.86e-20	NR	WP_216910510.1	2815603	g425981	i0	60	0.979899497487437	65	26	98	0	195	1	3	67	WP_216910510.1 hypothetical protein [Synechococcus sp. CCY 0621]	diamond	195	91.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CCY 0621
27500959	27500959	PRJEB49404_P_NODE_234083_length_315_cov_1.528986_g220284_i0	PRJEB49404	234083	315	1.528986	4.8163059	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	163	3.48e-44	NR	HVO23940.1	2053573	g220284	i0	76.5	1.95238095238095	102	24	97.1	0	8	313	785	886	HVO23940.1 TonB-dependent receptor [Candidatus Margulisiibacteriota bacterium]	diamond	615	163	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
28423318	28423318	PRJEB49404_P_NODE_412586_length_209_cov_1.641176_g398785_i0	PRJEB49404	412586	209	1.641176	3.43005784	Chamaesiphon polymorphus	2107691	Bacteria	Bacteria	62.8	1.75e-9	NR	WP_106299967.1	2107691	g398785	i0	55.1	0.703349282296651	49	22	70.3	0	148	2	13	61	WP_106299967.1 SGNH/GDSL hydrolase family protein [Chamaesiphon polymorphus]	diamond	147	62.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon polymorphus
30152940	30152940	PRJEB49404_P_NODE_231792_length_317_cov_1.834532_g217993_i0	PRJEB49404	231792	317	1.834532	5.81546644	Stenomitos	1844270	Bacteria	Bacteria	131	5.67e-33	NR	MCY7282017.1	2880266	g217993	i0	58.5	4.00315457413249	106	40	98.4	3	5	316	364	467	MCY7282017.1 toxin [Cyanobacteria bacterium CAN_BIN43]	diamond	1269	132	0.992424242424242	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium CAN_BIN43
30159648	30159648	PRJEB49404_P_NODE_299012_length_264_cov_2.524444_g285211_i0	PRJEB49404	299012	264	2.524444	6.66453216	Alkalinema sp. FACHB-956	2692768	Bacteria	Bacteria	117	1.99e-28	NR	WP_190574486.1	2692768	g285211	i0	60.9	3.93181818181818	87	34	98.9	0	2	262	1030	1116	WP_190574486.1 SpvB/TcaC N-terminal domain-containing protein [Alkalinema sp. FACHB-956]	diamond	1038	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Alkalinema	Alkalinema sp. FACHB-956
32531425	32531425	PRJEB49404_P_NODE_456839_length_194_cov_1.593548_g443038_i0	PRJEB49404	456839	194	1.593548	3.09148312	Tildeniella nuda	2303521	Bacteria	Bacteria	45.8	2.91e-4	NR	MBW4578520.1	2136405	g443038	i0	59.4	1.48453608247423	32	13	49.5	0	194	99	63	94	MBW4578520.1 DUF1871 family protein [Tildeniella nuda ZEHNDER 1965/U140]	diamond	288	45.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Tildeniella	Tildeniella nuda

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