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

12 rows where analysis = "blastn", bioproject = "PRJNA1111077" 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
214725	214725	PRJNA1111077_P_NODE_27481_length_261_cov_1.404255_g27260_i0	PRJNA1111077	27481	261	1.404255	3.66510555	Oscillatoria acuminata	118323	Bacteria	Bacteria	385	2.07e-102	NTclustered	gi\|427998918\|gb\|CP003607.1\|	56110	g27260	i0	99.526	0.808429118773946	211	1	81	0	51	261	2528646	2528436	Oscillatoria acuminata PCC 6304, complete genome	blastn	211	385	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria acuminata
4041542	4041542	PRJNA1111077_P_NODE_25164_length_269_cov_2.081633_g24943_i0	PRJNA1111077	25164	269	2.081633	5.59959277	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	198	2.99e-46	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g24943	i0	80.075	0.988847583643123	266	53	99	0	1	266	107148	107413	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	266	198	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
4041547	4041547	PRJNA1111077_P_NODE_25364_length_268_cov_7.015385_g25143_i0	PRJNA1111077	25364	268	7.015385	18.8012318	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	374	4.6099999999999995e-99	NTclustered	gi\|225696212\|gb\|FJ805879.1\|	259957	g25143	i0	91.791	172.951492537313	268	22	100	0	1	268	1637	1904	Uncultured Chroococcidiopsis sp. clone A3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	46351	374	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7867845	7867845	PRJNA1111077_P_NODE_6187_length_462_cov_3.385604_g5966_i0	PRJNA1111077	6187	462	3.385604	15.64149048	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	682	0	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g5966	i0	93.348	228	466	23	100	5	1	462	2150907	2150446	Leptolyngbya sp. 7M chromosome	blastn	105336	682	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
10418452	10418452	PRJNA1111077_P_NODE_37509_length_234_cov_2.285714_g37288_i0	PRJNA1111077	37509	234	2.285714	5.34857076	Microcoleus vaginatus	119532	Bacteria	Bacteria	388	1.41e-103	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g37288	i0	96.581	4	234	8	100	0	1	234	5873097	5873330	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	936	388	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
10418557	10418557	PRJNA1111077_P_NODE_6569_length_451_cov_1.846561_g6348_i0	PRJNA1111077	6569	451	1.846561	8.32799011	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	728	0	NTclustered	gi\|225696255\|gb\|FJ805922.1\|	259957	g6348	i0	95.806	166.008869179601	453	15	100	4	1	451	2464	2014	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	74870	728	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
11693421	11693421	PRJNA1111077_P_NODE_27550_length_260_cov_4.379679_g27329_i0	PRJNA1111077	27550	260	4.379679	11.3871654	Planktothricoides raciborskii	132608	Bacteria	Bacteria	89.8	1.81e-13	NTclustered	gi\|2754673971\|gb\|CP159837.1\|	2792601	g27329	i0	88.158	210.996153846154	76	7	35	1	140	213	5098353	5098278	Planktothricoides raciborskii GIHE-MW2 chromosome, complete genome	blastn	54859	89.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Planktothricoides	Planktothricoides raciborskii
16323600	16323600	PRJNA1111077_P_NODE_19533_length_288_cov_2.427907_g19312_i0	PRJNA1111077	19533	288	2.427907	6.99237216	Chroococcidiopsis	54298	Bacteria	Bacteria	532	7.8e-147	NTclustered	gi\|389547738\|gb\|JQ402666.1\|	1211	g19312	i0	100	100.065972222222	288	0	100	0	1	288	367	654	Uncultured cyanobacterium clone CNY_03083 16S ribosomal RNA gene, partial sequence	blastn	28819	532	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
21891296	21891296	PRJNA1111077_P_NODE_15338_length_310_cov_3.278481_g15117_i0	PRJNA1111077	15338	310	3.278481	10.1632911	Trichormus azollae	1164	Bacteria	Bacteria	117	1.0100000000000002e-21	NTclustered	gi\|298231532\|gb\|CP002059.1\|	551115	g15117	i0	81.208	7.96129032258064	149	24	47	2	4	150	2422672	2422818	'Nostoc azollae' 0708, complete genome	blastn	2468	117	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Trichormus	Trichormus azollae
21891373	21891373	PRJNA1111077_P_NODE_18518_length_292_cov_2.041096_g18297_i0	PRJNA1111077	18518	292	2.041096	5.96000032	Oscillatoria acuminata	118323	Bacteria	Bacteria	451	2.28e-122	NTclustered	gi\|427998918\|gb\|CP003607.1\|	56110	g18297	i0	94.521	1.66780821917808	292	16	100	0	1	292	5251310	5251019	Oscillatoria acuminata PCC 6304, complete genome	blastn	487	451	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria acuminata
21891584	21891584	PRJNA1111077_P_NODE_27278_length_261_cov_4.856383_g27057_i0	PRJNA1111077	27278	261	4.856383	12.67515963	Nodosilinea sp. E11	3037479	Bacteria	Bacteria	244	3.66e-60	NTclustered	gi\|2593238647\|gb\|CP136520.1\|	3037479	g27057	i0	84.314	0.977011494252874	255	35	97	5	8	261	2474464	2474214	Nodosilinea sp. E11 chromosome	blastn	255	244	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. E11
23166939	23166939	PRJNA1111077_P_NODE_20939_length_284_cov_1.161137_g20718_i0	PRJNA1111077	20939	284	1.161137	3.29762908	Oscillatoria acuminata	118323	Bacteria	Bacteria	302	2.36e-77	NTclustered	gi\|427998918\|gb\|CP003607.1\|	56110	g20718	i0	86.38	0.982394366197183	279	34	98	4	6	283	6667466	6667191	Oscillatoria acuminata PCC 6304, complete genome	blastn	279	302	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria acuminata

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