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

10 rows where analysis = "blastn", bioproject = "PRJNA688931" 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
2453332	2453332	PRJNA688931_P_NODE_20602_length_225_cov_2.534091_g20389_i0	PRJNA688931	20602	225	2.534091	5.70170475	Chroococcidiopsis	54298	Bacteria	Bacteria	416	6.159999999999998e-112	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g20389	i0	100	189.577777777778	225	0	100	0	1	225	320	96	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	42655	416	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
6282111	6282111	PRJNA688931_P_NODE_7005_length_411_cov_2.099448_g6792_i0	PRJNA688931	7005	411	2.099448	8.62873128	Chroococcidiopsis	54298	Bacteria	Bacteria	754	0	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g6792	i0	99.757	118.968369829684	411	1	100	0	1	411	1819	1409	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	48896	754	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
8830997	8830997	PRJNA688931_P_NODE_15307_length_264_cov_1.162791_g15094_i0	PRJNA688931	15307	264	1.162791	3.06976824	Chroococcidiopsis	54298	Bacteria	Bacteria	254	6.16e-63	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g15094	i0	99.286	127.515151515152	140	1	53	0	1	140	2609	2748	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	33664	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
10106719	10106719	PRJNA688931_P_NODE_28548_length_190_cov_1.765957_g28335_i0	PRJNA688931	28548	190	1.765957	3.3553183	Chroococcidiopsis	54298	Bacteria	Bacteria	278	2.47e-70	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g28335	i0	95.93	164.9	172	5	90	2	1	171	3319	3149	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	31331	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
10106772	10106772	PRJNA688931_P_NODE_7328_length_401_cov_5.082386_g7115_i0	PRJNA688931	7328	401	5.082386	20.38036786	root	1	Root_unresolved	Root_unresolved	736	0	NTclustered	gi\|326699003\|gb\|JF344102.1\|	1211	g7115	i0	99.751	101.017456359102	401	1	100	0	1	401	801	401	Uncultured cyanobacterium clone RODAS-124 16S ribosomal RNA gene, partial sequence	blastn	40508	741	0.993252361673414	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
13932054	13932054	PRJNA688931_P_NODE_44111_length_161_cov_3.071429_g43898_i0	PRJNA688931	44111	161	3.071429	4.94500069	Chroococcidiopsis	54298	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|485099067\|ref\|NR_102464.1\|	251229	g43898	i0	100	101.515527950311	161	0	100	0	1	161	4	164	Chroococcidiopsis thermalis PCC 7203 16S ribosomal RNA, partial sequence	blastn	16344	298	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
16480907	16480907	PRJNA688931_P_NODE_26053_length_200_cov_1.357616_g25840_i0	PRJNA688931	26053	200	1.357616	2.715232	Oscillatoriales	1150	Bacteria	Bacteria	361	2.5399999999999998e-95	NTclustered	gi\|428274175\|gb\|KC146553.1\|	1211	g25840	i0	99.495	162.54	198	1	99	0	3	200	50	247	Uncultured cyanobacterium clone MID5_rep_c3856 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32508	364	0.991758241758242	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
16480955	16480955	PRJNA688931_P_NODE_44293_length_158_cov_3.954128_g44080_i0	PRJNA688931	44293	158	3.954128	6.24752224	Chroococcidiopsis	54298	Bacteria	Bacteria	276	7.120000000000001e-70	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g44080	i0	98.101	166.518987341772	158	3	100	0	1	158	340	497	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	26310	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
16480970	16480970	PRJNA688931_P_NODE_9853_length_337_cov_3.569444_g9640_i0	PRJNA688931	9853	337	3.569444	12.02902628	Chroococcidiopsis	54298	Bacteria	Bacteria	599	9.06e-167	NTclustered	gi\|146740648\|emb\|AM709635.1\|	171389	g9640	i0	98.81	159.20178041543	336	4	99	0	1	336	2998	2663	Chroococcidiopsis sp. SAG 2025 partial ribosomal RNA operon, strain SAG 2025	blastn	53651	604	0.991721854304636	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. SAG 2025
21580235	21580235	PRJNA688931_P_NODE_13777_length_279_cov_2.308696_g13564_i0	PRJNA688931	13777	279	2.308696	6.44126184	Cyanophyceae	3028117	Bacteria	Bacteria	510	3.5299999999999996e-140	NTclustered	gi\|55669000\|gb\|AY790395.1\|	1211	g13564	i0	99.642	99.5197132616487	279	1	100	0	1	279	375	97	Uncultured cyanobacterium clone GLT8 16S ribosomal RNA gene, partial sequence	blastn	27766	510	1	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);;