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

9 rows where analysis = "blastn", bioproject = "PRJNA694770" 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
7054048	7054048	PRJNA694770_P_NODE_76526_length_253_cov_1.344444_g76232_i0	PRJNA694770	76526	253	1.344444	3.40144332	Microcoleus vaginatus	119532	Bacteria	Bacteria	446	9.01e-121	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g76232	i0	98.419	5.48221343873518	253	4	100	0	1	253	1476309	1476057	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	1387	446	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
7054246	7054246	PRJNA694770_P_NODE_83966_length_248_cov_1.760000_g83672_i0	PRJNA694770	83966	248	1.76	4.3648	Anabaena sp. YBS01	2490939	Bacteria	Bacteria	370	5.45e-98	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g83672	i0	93.878	99.2620967741936	245	15	99	0	4	248	5551161	5550917	Anabaena sp. YBS01 chromosome, complete genome	blastn	24617	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
10109963	10109963	PRJNA694770_P_NODE_87148_length_247_cov_0.885057_g86854_i0	PRJNA694770	87148	247	0.885057	2.18609079	Tolypothrix	111782	Bacteria	Bacteria	191	4.53e-44	NTclustered	gi\|2316438351\|gb\|CP064879.1\|	1188	g86854	i0	80.723	2.01619433198381	249	44	100	4	1	247	1297797	1298043	Tolypothrix sp. PCC 7601 chromosome, complete genome	blastn	498	191	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix sp. PCC 7601
13429656	13429656	PRJNA694770_P_NODE_94351_length_244_cov_0.900585_g94057_i0	PRJNA694770	94351	244	0.900585	2.1974274	Anabaena sp. YBS01	2490939	Bacteria	Bacteria	424	4.05e-114	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g94057	i0	97.951	1	244	5	100	0	1	244	5565376	5565619	Anabaena sp. YBS01 chromosome, complete genome	blastn	244	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
16483453	16483453	PRJNA694770_P_NODE_45313_length_310_cov_1.649789_g45019_i0	PRJNA694770	45313	310	1.649789	5.1143459	Nostocaceae	1162	Bacteria	Bacteria	573	4.999999999999998e-159	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g45019	i0	100	21.1516129032258	310	0	100	0	1	310	4273831	4273522	Nostoc sp. PCC 7120 DNA, complete genome	blastn	6557	573	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
18527823	18527823	PRJNA694770_P_NODE_95015_length_243_cov_0.905882_g94721_i0	PRJNA694770	95015	243	0.905882	2.20129326	Cylindrospermum sp. NIES-4074	2005457	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1210208533\|dbj\|AP018269.1\|	2005457	g94721	i0	100	0.119341563786008	29	0	12	0	199	227	5836035	5836007	Cylindrospermum sp. NIES-4074 DNA, nearly complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum sp. NIES-4074
21077420	21077420	PRJNA694770_P_NODE_61197_length_278_cov_1.190244_g60903_i0	PRJNA694770	61197	278	1.190244	3.30887832	Nostoc sp. NIES-3756	1751286	Bacteria	Bacteria	215	3.08e-51	NTclustered	gi\|953513865\|dbj\|AP017296.1\|	1751286	g60903	i0	81.749	0.946043165467626	263	43	94	5	18	278	401496	401755	Nostoc sp. NIES-3756 plasmid pNOS3756_1 DNA, complete genome	blastn	263	215	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-3756
21078145	21078145	PRJNA694770_P_NODE_87897_length_247_cov_0.885057_g87603_i0	PRJNA694770	87897	247	0.885057	2.18609079	Leptolyngbya sp. BL0902	1115757	Bacteria	Bacteria	86.1	2.2e-12	NTclustered	gi\|1949996095\|gb\|CP046155.1\|	1115757	g87603	i0	87.013	0.311740890688259	77	9	31	1	132	208	3596278	3596353	Leptolyngbya sp. BL0902 chromosome, complete genome	blastn	77	86.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. BL0902
22857283	22857283	PRJNA694770_P_NODE_1238_length_1768_cov_6.083186_g1100_i0	PRJNA694770	1238	1768	6.083186	107.55072848	Chroococcidiopsis	54298	Bacteria	Bacteria	2409	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g1100	i0	91.241	103.377262443439	1781	138	99	16	1	1767	1642	3418	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	182771	2409	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.

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