metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA429937" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA429937" and tax_phylum = "Cyanobacteriota"

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
1700988	1700988	PRJNA429937_P_NODE_17722_length_874_cov_5.342012_g10491_i0	PRJNA429937	17722	874	5.342012	46.68918488	Nostoc sp. MS1	2764711	Bacteria	Bacteria	462	3.4399999999999997e-125	NTclustered	gi\|2093825993\|dbj\|AP023441.1\|	2764711	g10491	i0	85.129	3.66361556064073	464	55	52	10	23	479	6720537	6720081	Nostoc sp. MS1 DNA, complete genome	blastn	3202	462	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. MS1
3638520	3638520	PRJNA429937_P_NODE_27743_length_694_cov_5.705263_g16710_i0	PRJNA429937	27743	694	5.705263	39.59452522	Oscillatoriales	1150	Bacteria	Bacteria	481	7.459999999999997e-131	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g16710	i0	95.652	75.0634005763689	299	13	71	0	24	322	812546	812844	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	52094	481	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
8740608	8740608	PRJNA429937_P_NODE_78807_length_370_cov_2.964809_g56477_i0	PRJNA429937	78807	370	2.964809	10.9697933	Microcystis	1125	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1519305953\|dbj\|AP019314.1\|	213615	g56477	i0	88.636	0.710810810810811	44	5	12	0	103	146	5259476	5259519	Microcystis viridis NIES-102 DNA, complete genome	blastn	263	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis viridis
10631605	10631605	PRJNA429937_P_NODE_99629_length_303_cov_4.427007_g77020_i0	PRJNA429937	99629	303	4.427007	13.41383121	Phormidium sp. UTEX B EE19	2094043	Bacteria	Bacteria	494	3.9e-135	NTclustered	gi\|1358126421\|gb\|KY963619.1\|	2094043	g77020	i0	96.04	108.422442244224	303	12	100	0	1	303	790	488	Phormidium sp. UTEX B EE19 23S ribosomal RNA gene, partial sequence	blastn	32852	494	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium sp. UTEX B EE19
11291056	11291056	PRJNA429937_P_NODE_96189_length_313_cov_20.066901_g73590_i0	PRJNA429937	96189	313	20.066901	62.80940013	Nostoc	1177	Bacteria	Bacteria	545	1.1e-150	NTclustered	gi\|46409894\|gb\|AY584519.1\|	63737	g73590	i0	98.083	174.900958466454	313	6	100	0	1	313	1010	1322	Nostoc punctiforme PCC 73102 23S ribosomal RNA gene, partial sequence	blastn	54744	545	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
13179698	13179698	PRJNA429937_P_NODE_152751_length_171_cov_6.338028_g130124_i0	PRJNA429937	152751	171	6.338028	10.83802788	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	195	2.25e-45	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g130124	i0	87.283	92.8713450292398	173	18	100	4	1	171	2150816	2150646	Leptolyngbya sp. 7M chromosome	blastn	15881	195	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
13840854	13840854	PRJNA429937_P_NODE_146531_length_194_cov_2.351515_g123904_i0	PRJNA429937	146531	194	2.351515	4.5619391	Synechococcus	1129	Bacteria	Bacteria	121	4.529999999999999e-23	NTclustered	gi\|2716506966\|gb\|CP034671.2\|	2283154	g123904	i0	87.5	1.62371134020619	104	13	54	0	1	104	2181380	2181483	Synechococcus elongatus PCC 11802 chromosome, complete genome	blastn	315	121	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus elongatus
13841124	13841124	PRJNA429937_P_NODE_53491_length_481_cov_3.460177_g35329_i0	PRJNA429937	53491	481	3.460177	16.64345137	Dolichospermum	748770	Bacteria	Bacteria	309	2.52e-79	NTclustered	gi\|1731522919\|gb\|CP043056.1\|	1914871	g35329	i0	79.148	5.78586278586279	446	93	93	0	8	453	2902636	2903081	Dolichospermum sp. UHCC 0315A chromosome, complete genome	blastn	2783	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp. UHCC 0315A
15115554	15115554	PRJNA429937_P_NODE_74872_length_384_cov_2.343662_g52800_i0	PRJNA429937	74872	384	2.343662	8.99966208	Cyanophyceae	3028117	Bacteria	Bacteria	121	9.9e-23	NTclustered	gi\|2874253827\|emb\|OY969811.1\|	1211	g52800	i0	98.529	1.90885416666667	68	1	18	0	88	155	1504402	1504469	MAG: uncultured cyanobacterium isolate MFD02832.bin.c.1 genome assembly, chromosome: 1	blastn	733	121	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
15728700	15728700	PRJNA429937_P_NODE_155673_length_161_cov_2.166667_g133046_i0	PRJNA429937	155673	161	2.166667	3.48833387	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	185	1.2599999999999999e-42	NTclustered	gi\|2583116464\|gb\|CP119968.1\|	2859516	g133046	i0	87.578	3.02484472049689	161	19	100	1	1	161	2832033	2831874	Gloeocapsopsis dulcis strain AAB1 chromosome, complete genome	blastn	487	185	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
16390169	16390169	PRJNA429937_P_NODE_62233_length_436_cov_6.530713_g42096_i0	PRJNA429937	62233	436	6.530713	28.47390868	Oscillatoriales	1150	Bacteria	Bacteria	627	5.499999999999998e-175	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g42096	i0	99.708	139.121559633028	342	1	78	0	89	430	103456	103115	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	60657	632	0.992088607594937	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
18938777	18938777	PRJNA429937_P_NODE_122695_length_241_cov_29.334906_g100069_i0	PRJNA429937	122695	241	29.334906	70.69712346	Trichocoleus	450526	Bacteria	Bacteria	289	1.52e-73	NTclustered	gi\|1373417990\|gb\|KY511274.1\|	1382649	g100069	i0	90.498	126.128630705394	221	17	91	4	23	241	81	299	Trichocoleus desertorum ATA4-8-CV3 clone 6 23S ribosomal RNA gene, partial sequence; 23S-5S intergenic spacer, complete sequence; and 5S ribosomal RNA gene, partial sequence	blastn	30397	289	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus	Trichocoleus desertorum
21489203	21489203	PRJNA429937_P_NODE_153977_length_167_cov_3.000000_g131350_i0	PRJNA429937	153977	167	3	5.01	Cyanophyceae	3028117	Bacteria	Bacteria	230	6.029999999999999e-56	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g131350	i0	96.403	126.508982035928	139	5	83	0	29	167	795356	795218	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	21127	231	0.995670995670996	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
22764679	22764679	PRJNA429937_P_NODE_74698_length_384_cov_7.504225_g16710_i1	PRJNA429937	74698	384	7.504225	28.816224	Oscillatoriales	1150	Bacteria	Bacteria	481	3.94e-131	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g16710	i1	95.652	125.674479166667	299	13	78	0	24	322	812546	812844	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	48259	481	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
25313643	25313643	PRJNA429937_P_NODE_32940_length_632_cov_8.515755_g20250_i0	PRJNA429937	32940	632	8.515755	53.8195716	Limnospira	2596745	Bacteria	Bacteria	1075	0	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g20250	i0	99.328	19.1439873417722	595	3	94	1	18	611	1407979	1407385	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	12099	1075	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
25313734	25313734	PRJNA429937_P_NODE_48720_length_509_cov_2.239583_g31739_i0	PRJNA429937	48720	509	2.239583	11.39947747	Cyanophyceae	3028117	Bacteria	Bacteria	121	1.35e-22	NTclustered	gi\|2874253827\|emb\|OY969811.1\|	1211	g31739	i0	98.529	1.44007858546169	68	1	13	0	228	295	1504402	1504469	MAG: uncultured cyanobacterium isolate MFD02832.bin.c.1 genome assembly, chromosome: 1	blastn	733	121	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);;