metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA784298" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA784298" 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
765247	765247	PRJNA784298_P_NODE_11021_length_377_cov_2.555921_g10820_i0	PRJNA784298	11021	377	2.555921	9.63582217	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	691	0	NTclustered	gi\|225696252\|gb\|FJ805919.1\|	259957	g10820	i0	99.735	145.989389920424	377	1	100	0	1	377	3273	2897	Uncultured Chroococcidiopsis sp. clone A1_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	55038	691	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
1213250	1213250	PRJNA784298_P_NODE_3721_length_660_cov_5.037479_g3524_i0	PRJNA784298	3721	660	5.037479	33.2473614	Cyanophyceae	3028117	Bacteria	Bacteria	898	0	NTclustered	gi\|225696187\|gb\|FJ805854.1\|	259957	g3524	i0	91.337	132.531818181818	658	56	99	1	1	658	2900	2244	Uncultured Chroococcidiopsis sp. clone AR2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	87471	898	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3316683	3316683	PRJNA784298_P_NODE_28503_length_206_cov_2.233083_g28302_i0	PRJNA784298	28503	206	2.233083	4.6001509799999996	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	348	2.05e-91	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g28302	i0	97.087	128.077669902913	206	6	100	0	1	206	2109	2314	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	26384	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5868829	5868829	PRJNA784298_P_NODE_19165_length_282_cov_3.071770_g18964_i0	PRJNA784298	19165	282	3.07177	8.6623914	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	292	1.41e-74	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g18964	i0	86.131	160.602836879433	274	35	97	3	1	273	3218	2947	Uncultured Chroococcidiopsis sp. clone SA1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	45290	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9693573	9693573	PRJNA784298_P_NODE_11068_length_376_cov_2.808581_g10867_i0	PRJNA784298	11068	376	2.808581	10.56026456	Calothrix sp. PCC 6303	1170562	Bacteria	Bacteria	446	1.41e-120	NTclustered	gi\|485099151\|ref\|NR_102546.1\|	1170562	g10867	i0	88.127	168.313829787234	379	39	100	5	1	376	1773	1398	Calothrix sp. PCC 6303 strain PCC 6303 23S ribosomal RNA, complete sequence	blastn	63286	446	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
9693594	9693594	PRJNA784298_P_NODE_12988_length_346_cov_2.216117_g12787_i0	PRJNA784298	12988	346	2.216117	7.66776482	Kovacikia minuta	2931930	Bacteria	Bacteria	538	2.0599999999999993e-148	NTclustered	gi\|2098452651\|gb\|CP083582.1\|	2653194	g12787	i0	95.308	145.161849710983	341	13	98	3	1	340	4175234	4175572	Kovacikia minuta CCNUW1 strain CCNU0001 chromosome, complete genome	blastn	50226	538	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Kovacikia	Kovacikia minuta
9693863	9693863	PRJNA784298_P_NODE_928_length_1350_cov_4.227095_g815_i0	PRJNA784298	928	1350	4.227095	57.0657825	Calothrix sp. NIES-4101	2005461	Bacteria	Bacteria	1895	0	NTclustered	gi\|1210217881\|dbj\|AP018280.1\|	2005461	g815	i0	92.047	303.431111111111	1358	92	100	15	1	1350	1243449	1242100	Calothrix sp. NIES-4101 DNA, complete genome	blastn	409632	1895	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-4101
12245017	12245017	PRJNA784298_P_NODE_3330_length_698_cov_4.344000_g3139_i0	PRJNA784298	3330	698	4.344	30.32112	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1077	0	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g3139	i0	94.564	103.921203438395	699	34	99	4	3	698	2345	3042	Uncultured Chroococcidiopsis sp. clone SA1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	72537	1077	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13519184	13519184	PRJNA784298_P_NODE_26411_length_242_cov_1.402367_g26210_i0	PRJNA784298	26411	242	1.402367	3.39372814	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	335	1.9299999999999993e-87	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g26210	i0	91.736	161.727272727273	242	19	99	1	2	242	1064	823	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	39138	335	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
14793884	14793884	PRJNA784298_P_NODE_15172_length_319_cov_3.284553_g14971_i0	PRJNA784298	15172	319	3.284553	10.47772407	uncultured Pleurocapsales cyanobacterium	183215	Bacteria	Bacteria	590	5.1299999999999986e-164	NTclustered	gi\|745734142\|gb\|KM458348.1\|	183215	g14971	i0	100	98.1065830721003	319	0	100	0	1	319	377	59	Uncultured Pleurocapsales cyanobacterium isolate OTU 00075 23S ribosomal RNA gene, partial sequence	blastn	31296	590	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales			uncultured Pleurocapsales cyanobacterium
14793963	14793963	PRJNA784298_P_NODE_23612_length_251_cov_1.724719_g23411_i0	PRJNA784298	23612	251	1.724719	4.32904469	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	377	3.2999999999999995e-100	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g23411	i0	93.701	152.529880478088	254	12	100	4	1	251	3670007	3670259	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	38285	377	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
16516239	16516239	PRJNA784298_P_NODE_7253_length_469_cov_4.964646_g7052_i0	PRJNA784298	7253	469	4.964646	23.28418974	Chroococcidiopsis	54298	Bacteria	Bacteria	649	0	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g7052	i0	91.72	110.891257995736	471	34	100	5	1	469	795165	794698	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	52008	649	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
19064954	19064954	PRJNA784298_P_NODE_25535_length_245_cov_0.895349_g25334_i0	PRJNA784298	25535	245	0.895349	2.19360505	Leptolyngbya	47251	Bacteria	Bacteria	331	2.5400000000000002e-86	NTclustered	gi\|757114186\|dbj\|AP014638.1\|	411966	g25334	i0	91.02	149.302040816327	245	22	100	0	1	245	247083	247327	Leptolyngbya boryana IAM M-101 DNA, complete genome, strain: IAM M-101	blastn	36579	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
19892175	19892175	PRJNA784298_P_NODE_22176_length_260_cov_4.133690_g21975_i0	PRJNA784298	22176	260	4.13369	10.747594	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	331	2.72e-86	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g21975	i0	90.726	115.346153846154	248	23	95	0	2	249	2807	3054	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	29990	331	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19892196	19892196	PRJNA784298_P_NODE_23856_length_250_cov_2.864407_g23655_i0	PRJNA784298	23856	250	2.864407	7.1610175	Chroococcidiopsis sp. CCMEE 010	2941234	Bacteria	Bacteria	283	7.379999999999999e-72	NTclustered	gi\|2594665719\|gb\|OR413562.1\|	2941234	g23655	i0	87.2	159.064	250	31	100	1	1	250	3743	3495	Chroococcidiopsis sp. CCMEE 010 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	39766	283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 010
22442813	22442813	PRJNA784298_P_NODE_8978_length_420_cov_4.115274_g8777_i0	PRJNA784298	8978	420	4.115274	17.2841508	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	749	0	NTclustered	gi\|225696219\|gb\|FJ805886.1\|	259957	g8777	i0	98.81	131.080952380952	420	5	100	0	1	420	2426	2845	Uncultured Chroococcidiopsis sp. clone NA4_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	55054	749	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
24164852	24164852	PRJNA784298_P_NODE_20419_length_273_cov_1.420000_g20218_i0	PRJNA784298	20419	273	1.42	3.8766	Nodularia	159191	Bacteria	Bacteria	296	1.05e-75	NTclustered	gi\|604876398\|gb\|CP007203.2\|	313624	g20218	i0	89.916	71.8864468864469	238	13	85	10	42	273	1275402	1275634	Nodularia spumigena CCY9414 genome	blastn	19625	296	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
24991760	24991760	PRJNA784298_P_NODE_19020_length_283_cov_7.985714_g18819_i0	PRJNA784298	19020	283	7.985714	22.59957062	Calothrix sp. NIES-4101	2005461	Bacteria	Bacteria	401	2.2499999999999992e-107	NTclustered	gi\|1210217881\|dbj\|AP018280.1\|	2005461	g18819	i0	92.226	277.250883392226	283	22	100	0	1	283	1244970	1244688	Calothrix sp. NIES-4101 DNA, complete genome	blastn	78462	401	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-4101
24991778	24991778	PRJNA784298_P_NODE_21060_length_268_cov_1.523077_g20859_i0	PRJNA784298	21060	268	1.523077	4.08184636	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	248	2.92e-61	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g20859	i0	83.459	3.8955223880597	266	44	99	0	1	266	6838161	6837896	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	1044	248	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2

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