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

11 rows where analysis = "blastn", bioproject = "PRJNA789095" 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
2489942	2489942	PRJNA789095_P_NODE_47382_length_292_cov_1.630137_g46048_i0	PRJNA789095	47382	292	1.630137	4.76000004	Chroococcaceae	1890464	Bacteria	Bacteria	418	2.3199999999999996e-112	NTclustered	gi\|485099145\|ref\|NR_102540.1\|	1173026	g46048	i0	92.466	286.256849315069	292	22	100	0	1	292	2875	2584	Gloeocapsa sp. PCC 7428 strain PCC 7428 23S ribosomal RNA, complete sequence	blastn	83587	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
3322480	3322480	PRJNA789095_P_NODE_61423_length_260_cov_2.144385_g60089_i0	PRJNA789095	61423	260	2.144385	5.575401	Brasilonema sennae	1397703	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1702166658\|gb\|CP030118.1\|	415709	g60089	i0	100	0.107692307692308	28	0	11	0	161	188	1061530	1061557	Brasilonema sennae CENA114 chromosome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema sennae
4598742	4598742	PRJNA789095_P_NODE_36784_length_335_cov_1.148855_g35450_i0	PRJNA789095	36784	335	1.148855	3.84866425	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	427	4.49e-115	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g35450	i0	89.881	128.64776119403	336	29	99	5	3	335	2861	3194	Uncultured Chroococcidiopsis sp. clone AR1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	43097	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5042721	5042721	PRJNA789095_P_NODE_35864_length_341_cov_0.936567_g34530_i0	PRJNA789095	35864	341	0.936567	3.19369347	Chroococcaceae	1890464	Bacteria	Bacteria	503	7.4e-138	NTclustered	gi\|485099145\|ref\|NR_102540.1\|	1173026	g34530	i0	93.294	111.692082111437	343	19	100	4	1	341	968	1308	Gloeocapsa sp. PCC 7428 strain PCC 7428 23S ribosomal RNA, complete sequence	blastn	38087	503	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
15242892	15242892	PRJNA789095_P_NODE_53692_length_277_cov_2.259804_g52358_i0	PRJNA789095	53692	277	2.259804	6.25965708	Chroococcus	70190	Bacteria	Bacteria	501	2.11e-137	NTclustered	gi\|322504110\|emb\|FR798921.1\|	980450	g52358	i0	99.278	105.072202166065	277	2	100	0	1	277	1	277	Chroococcus sp. 9E-04 partial 16S rRNA gene, strain 9E-04	blastn	29105	501	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chroococcus	Chroococcus sp. 9E-04
16073724	16073724	PRJNA789095_P_NODE_59413_length_265_cov_1.203125_g58079_i0	PRJNA789095	59413	265	1.203125	3.18828125	cyanobacterium NIES-2125	2510788	Bacteria	Bacteria	281	2.84e-71	NTclustered	gi\|1566846232\|dbj\|LC455610.1\|	2510788	g58079	i0	86.09	175.720754716981	266	32	100	4	1	265	140	401	Cyanobacterium NIES-2125 gene for 23S ribosomal RNA, partial sequence	blastn	46566	281	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-2125
17349762	17349762	PRJNA789095_P_NODE_69174_length_248_cov_0.880000_g67840_i0	PRJNA789095	69174	248	0.88	2.1824	uncultured cyanobacterium	1211	Bacteria	Bacteria	431	2.47e-116	NTclustered	gi\|386685926\|gb\|JQ612142.1\|	1211	g67840	i0	97.984	99.6008064516129	248	5	100	0	1	248	636	389	Uncultured cyanobacterium clone MSmat.3.13 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	24701	431	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
18623386	18623386	PRJNA789095_P_NODE_82235_length_196_cov_7.300813_g80901_i0	PRJNA789095	82235	196	7.300813	14.30959348	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	329	6.99e-86	NTclustered	gi\|2245124533\|gb\|CP097480.1\|	2653189	g80901	i0	96.939	2	196	6	100	0	1	196	6144586	6144781	Chroococcidiopsis sp. CCNUC1 chromosome, complete genome	blastn	392	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
23723494	23723494	PRJNA789095_P_NODE_43399_length_308_cov_1.451064_g42065_i0	PRJNA789095	43399	308	1.451064	4.46927712	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	442	1.4599999999999994e-119	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g42065	i0	92.532	120.821428571429	308	23	100	0	1	308	3266	2959	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	37213	442	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
24166178	24166178	PRJNA789095_P_NODE_80359_length_218_cov_6.586207_g79025_i0	PRJNA789095	80359	218	6.586207	14.35793126	root	1	Root_unresolved	Root_unresolved	180	8.47e-41	NTclustered	gi\|1861038541\|dbj\|LC557454.1\|	1126	g79025	i0	99	66.9724770642202	100	1	46	0	119	218	2510	2411	Microcystis aeruginosa NIES-1062 gene for 23S rRNA, partial sequence	blastn	14600	180	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
24997741	24997741	PRJNA789095_P_NODE_62920_length_257_cov_1.440217_g61586_i0	PRJNA789095	62920	257	1.440217	3.70135769	uncultured Rivularia sp.	447564	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2621703013\|emb\|OY762007.1\|	447564	g61586	i0	100	0.108949416342412	28	0	11	0	203	230	4852664	4852637	MAG: uncultured Rivularia sp. isolate bc3217e8-a359-4fa3-9fd5-735ade2a2895 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rivulariaceae	Rivularia	uncultured Rivularia 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);;