metadata: contig_metadata: 18 rows where bioproject = "PRJEB48218" and tax_clade = "Cyanobacteriota/Melainabacteria group"

18 rows where bioproject = "PRJEB48218" 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
1337015	1337015	PRJEB48218_S_NODE_3362_length_691_cov_11201.697885_g2552_i0	PRJEB48218	3362	691	11201.697885	77403.73238535	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	582	1.98e-161	NTclustered	gi\|225696229\|gb\|FJ805896.1\|	259957	g2552	i0	89.849	77.7887120115774	463	33	66	12	120	574	3355	2899	Uncultured Chroococcidiopsis sp. clone NA2_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	53752	582	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3888870	3888870	PRJEB48218_S_NODE_6964_length_371_cov_10741.973684_g6002_i0	PRJEB48218	6964	371	10741.973684	39852.72236764	uncultured cyanobacterium	1211	Bacteria	Bacteria	411	5.049999999999999e-110	NTclustered	gi\|389547675\|gb\|JQ402603.1\|	1211	g6002	i0	96.386	69.1185983827493	249	9	67	0	1	249	249	1	Uncultured cyanobacterium clone CNY_03004 16S ribosomal RNA gene, partial sequence	blastn	25643	411	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
6440841	6440841	PRJEB48218_S_NODE_4586_length_534_cov_154.776238_g3657_i0	PRJEB48218	4586	534	154.776238	826.50511092	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	774	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g3657	i0	93.333	106.52808988764	525	33	98	2	10	532	1633	2157	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	56886	774	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
8643584	8643584	PRJEB48218_S_NODE_5647_length_440_cov_36.223844_g4692_i0	PRJEB48218	5647	440	36.223844	159.3849136	Cyanophyceae	3028117	Bacteria	Bacteria	725	0	NTclustered	gi\|55741013\|gb\|AY672718.1\|	54297	g4692	i0	96.364	103.006818181818	440	16	100	0	1	440	315	754	Arthrospira fusiformis strain AICB 664 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	45323	725	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira fusiformis
9918615	9918615	PRJEB48218_S_NODE_30008_length_152_cov_3.772358_g29046_i0	PRJEB48218	30008	152	3.772358	5.73398416	Limnospira	2596745	Bacteria	Bacteria	279	5.24e-71	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g29046	i0	100	759.611842105263	151	0	99	0	1	151	542849	542699	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	115461	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
9918667	9918667	PRJEB48218_S_NODE_4888_length_503_cov_7655.993671_g3948_i0	PRJEB48218	4888	503	7655.993671	38509.64816513	Oscillatoriales	1150	Bacteria	Bacteria	719	0	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g3948	i0	100	139.789264413519	389	0	77	0	1	389	812790	813178	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	70314	719	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
9918703	9918703	PRJEB48218_S_NODE_7148_length_363_cov_10991.020958_g6186_i0	PRJEB48218	7148	363	10991.020958	39897.40607754	Oscillatoriales	1150	Bacteria	Bacteria	420	8.189999999999998e-113	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g6186	i0	99.565	103.077134986226	230	1	63	0	24	253	811430	811659	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	37417	420	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
11193868	11193868	PRJEB48218_S_NODE_8309_length_326_cov_6.835017_g7347_i0	PRJEB48218	8309	326	6.835017	22.28215542	Gloeocapsopsis	693222	Bacteria	Bacteria	385	2.66e-102	NTclustered	gi\|1142095202\|gb\|KU847399.1\|	1433147	g7347	i0	89.103	138.865030674847	312	31	95	3	2	312	2454	2763	Gloeocapsopsis dulcis AAB1 = 1H9 16S ribosomal RNA, tRNA-Ile, 23S ribosomal RNA, and 5S ribosomal RNA genes, complete sequence	blastn	45270	385	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
12469380	12469380	PRJEB48218_S_NODE_22850_length_187_cov_31.968354_g21888_i0	PRJEB48218	22850	187	31.968354	59.78082198	Chroococcidiopsis	54298	Bacteria	Bacteria	329	6.6e-86	NTclustered	gi\|55669005\|gb\|AY790400.1\|	1211	g21888	i0	100	95.1871657754011	178	0	95	0	1	178	104	281	Uncultured cyanobacterium clone GLT13 16S ribosomal RNA gene, partial sequence	blastn	17800	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
12469576	12469576	PRJEB48218_S_NODE_9850_length_290_cov_27.222222_g8888_i0	PRJEB48218	9850	290	27.222222	78.9444438	Oscillatoriales	1150	Bacteria	Bacteria	536	6.079999999999999e-148	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g8888	i0	100	184.262068965517	290	0	100	0	1	290	812532	812821	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	53436	536	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
13743721	13743721	PRJEB48218_S_NODE_18671_length_219_cov_2.642105_g17709_i0	PRJEB48218	18671	219	2.642105	5.78620995	Synechococcus	1129	Bacteria	Bacteria	58.4	4.16e-4	NTclustered	gi\|147846875\|emb\|CT971583.1\|	32051	g17709	i0	100	0.28310502283105	31	0	14	0	1	31	271050	271020	Synechococcus WH7803 complete genome sequence	blastn	62	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. WH 7803
17568312	17568312	PRJEB48218_S_NODE_8734_length_314_cov_12888.712281_g7772_i0	PRJEB48218	8734	314	12888.712281	40470.55656234	Limnospira	2596745	Bacteria	Bacteria	370	7.14e-98	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g7772	i0	100	87.4458598726115	200	0	64	0	1	200	812237	812436	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	27458	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
20116960	20116960	PRJEB48218_S_NODE_30176_length_152_cov_1.804878_g29214_i0	PRJEB48218	30176	152	1.804878	2.74341456	Limnospira	2596745	Bacteria	Bacteria	276	6.770000000000001e-70	NTclustered	gi\|1527124258\|emb\|LR025168.1\|	118562	g29214	i0	99.342	9	152	1	100	0	1	152	847	696	Arthrospira platensis mRNA for Amine oxidase,flavin-containing (A-AO gene)	blastn	1368	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
22667345	22667345	PRJEB48218_S_NODE_4718_length_521_cov_60.764228_g3782_i0	PRJEB48218	4718	521	60.764228	316.58162788	Oscillatoriales	1150	Bacteria	Bacteria	898	0	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g3782	i0	100	133.26103646833	486	0	93	0	24	509	811430	811915	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	69429	898	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
25216502	25216502	PRJEB48218_S_NODE_26360_length_167_cov_2.557971_g25398_i0	PRJEB48218	26360	167	2.557971	4.27181157	Limnospira	2596745	Bacteria	Bacteria	279	5.9e-71	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g25398	i0	100	7.47904191616766	151	0	90	0	17	167	1296856	1297006	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	1249	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
27658840	27658840	PRJEB48218_S_NODE_24984_length_174_cov_2.179310_g24022_i0	PRJEB48218	24984	174	2.17931	3.7919994	Bacillati	1783272	Bacteria	Bacteria	82.4	1.36e-17	NR	MFN8554655.1	2364082	g24022	i0	68.5	1.86206896551724	54	17	93.1	0	162	1	74	127	MFN8554655.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	324	82.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28044221	28044221	PRJEB48218_S_NODE_16565_length_230_cov_2.860697_g15603_i0	PRJEB48218	16565	230	2.860697	6.5796031	Leptolyngbya sp. UWPOB_LEPTO1	2815653	Bacteria	Bacteria	143	8.92e-41	NR	WP_353736685.1	2815653	g15603	i0	86.5	0.965217391304348	74	10	96.5	0	2	223	115	188	WP_353736685.1 IS1 family transposase [Leptolyngbya sp. UWPOB_LEPTO1]	diamond	222	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. UWPOB_LEPTO1
31891668	31891668	PRJEB48218_S_NODE_11057_length_271_cov_3.123967_g10095_i0	PRJEB48218	11057	271	3.123967	8.46595057	Cyanophyceae	3028117	Bacteria	Bacteria	70.1	2.23e-12	NR	WP_273766868.1	2593658	g10095	i0	47.9	3.27675276752768	71	35	78.6	1	49	261	2	70	WP_273766868.1 MULTISPECIES: DUF1003 domain-containing protein [unclassified Nostoc]	diamond	888	70.5	0.994326241134752	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc

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