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

9 rows where analysis = "blastn", bioproject = "PRJNA376117" 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
1674798	1674798	PRJNA376117_P_NODE_44682_length_241_cov_0.916667_g44380_i0	PRJNA376117	44682	241	0.916667	2.20916747	Anabaena sp. YBS01	2490939	Bacteria	Bacteria	401	1.8699999999999993e-107	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g44380	i0	96.68	1	241	8	100	0	1	241	5550406	5550166	Anabaena sp. YBS01 chromosome, complete genome	blastn	241	401	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01
2950425	2950425	PRJNA376117_P_NODE_23903_length_286_cov_1.446009_g23601_i0	PRJNA376117	23903	286	1.446009	4.13558574	Leptolyngbya sp. BL-A-14	3104317	Bacteria	Bacteria	364	2.9899999999999993e-96	NTclustered	gi\|2804745243\|gb\|CP166621.1\|	3104317	g23601	i0	89.583	171.020979020979	288	28	100	1	1	286	3749508	3749795	MAG: Leptolyngbya sp. BL-A-14 chromosome, complete genome	blastn	48912	364	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. BL-A-14
5503534	5503534	PRJNA376117_P_NODE_34585_length_250_cov_1.740113_g34283_i0	PRJNA376117	34585	250	1.740113	4.3502825	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	315	2.62e-81	NTclustered	gi\|225696214\|gb\|FJ805881.1\|	259957	g34283	i0	89.683	160.496	252	19	99	4	1	248	1823	2071	Uncultured Chroococcidiopsis sp. clone A3_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	40124	315	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7451684	7451684	PRJNA376117_P_NODE_33506_length_251_cov_2.449438_g33204_i0	PRJNA376117	33506	251	2.449438	6.14808938	Oscillatoriales	1150	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|2095813707\|gb\|OK161270.1\|	2876722	g33204	i0	99.203	155.932270916335	251	2	100	0	1	251	3057	2807	Oscillatoria sp. 2.1A 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	39139	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. 2.1A
7451734	7451734	PRJNA376117_P_NODE_40506_length_245_cov_0.895349_g40204_i0	PRJNA376117	40506	245	0.895349	2.19360505	Limnospira	2596745	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g40204	i0	100	8.04897959183674	245	0	100	0	1	245	4257663	4257419	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	1972	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
8053303	8053303	PRJNA376117_P_NODE_40887_length_244_cov_1.350877_g40585_i0	PRJNA376117	40887	244	1.350877	3.29613988	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	298	2.56e-76	NTclustered	gi\|225696253\|gb\|FJ805920.1\|	259957	g40585	i0	89.54	110.905737704918	239	19	97	6	1	236	3288	3053	Uncultured Chroococcidiopsis sp. clone A1_6 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27061	298	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10603464	10603464	PRJNA376117_P_NODE_18009_length_325_cov_4.396825_g17707_i0	PRJNA376117	18009	325	4.396825	14.28968125	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	435	2.6e-117	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g17707	i0	90.826	193.332307692308	327	26	100	4	1	325	1626	1950	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	62833	435	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16977004	16977004	PRJNA376117_P_NODE_1074_length_1716_cov_3.096166_g926_i0	PRJNA376117	1074	1716	3.096166	53.13020856	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	1472	0	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g926	i0	94.404	206.779137529138	965	42	99	10	2	961	3669129	3670086	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	354833	1472	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
20801572	20801572	PRJNA376117_P_NODE_42617_length_243_cov_0.905882_g42315_i0	PRJNA376117	42617	243	0.905882	2.20129326	Anabaena sp. YBS01	2490939	Bacteria	Bacteria	350	6.94e-92	NTclustered	gi\|1772285456\|gb\|CP034058.1\|	2490939	g42315	i0	92.593	95.962962962963	243	18	100	0	1	243	5562447	5562205	Anabaena sp. YBS01 chromosome, complete genome	blastn	23319	350	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. YBS01

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