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

19 rows where analysis = "blastn", bioproject = "PRJNA859990" 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
2121279	2121279	PRJNA859990_S_NODE_16862_length_256_cov_1.803279_g16601_i0	PRJNA859990	16862	256	1.803279	4.61639424	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	416	7.159999999999998e-112	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g16601	i0	96.094	202.796875	256	9	100	1	1	256	1859076	1858822	Calothrix sp. PCC 7716 DNA, complete genome	blastn	51916	416	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
2511657	2511657	PRJNA859990_S_NODE_22062_length_241_cov_1.184524_g21801_i0	PRJNA859990	22062	241	1.184524	2.85470284	Chroococcidiopsis	54298	Bacteria	Bacteria	340	4.13e-89	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g21801	i0	92.116	2	241	19	100	0	1	241	5287913	5288153	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	482	340	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
4674233	4674233	PRJNA859990_S_NODE_10244_length_317_cov_2.122951_g9983_i0	PRJNA859990	10244	317	2.122951	6.72975467	Dulcicalothrix desertica	32056	Bacteria	Bacteria	510	4.08e-140	NTclustered	gi\|283766156\|gb\|GQ980023.1\|	232991	g9983	i0	97.333	225.984227129338	300	8	95	0	1	300	503	204	Calothrix desertica PCC 7102 23S large subunit ribosomal RNA (rrnL) gene, partial sequence	blastn	71637	510	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica
4674339	4674339	PRJNA859990_S_NODE_19264_length_247_cov_1.465517_g19003_i0	PRJNA859990	19264	247	1.465517	3.61982699	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	274	4.38e-69	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g19003	i0	86.64	23.1417004048583	247	33	100	0	1	247	556906	557152	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	5716	274	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
8498718	8498718	PRJNA859990_S_NODE_12287_length_294_cov_1.384615_g12026_i0	PRJNA859990	12287	294	1.384615	4.0707680999999996	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	466	8.22e-127	NTclustered	gi\|225696181\|gb\|FJ805848.1\|	259957	g12026	i0	95.238	105.013605442177	294	14	100	0	1	294	3734	4027	Uncultured Chroococcidiopsis sp. clone AU1_7 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	30874	466	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9773936	9773936	PRJNA859990_S_NODE_18228_length_250_cov_0.870056_g17967_i0	PRJNA859990	18228	250	0.870056	2.17514	Nostoc sp. C117	3349875	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2831016856\|gb\|CP170991.1\|	3349875	g17967	i0	100	0.844	29	0	12	0	32	60	7655568	7655596	Nostoc sp. C117 chromosome, complete genome	blastn	211	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C117
11049550	11049550	PRJNA859990_S_NODE_19529_length_247_cov_0.879310_g19268_i0	PRJNA859990	19529	247	0.87931	2.1718957	Anabaena azotica	197653	Bacteria	Bacteria	115	2.8100000000000003e-21	NTclustered	gi\|2894833396\|gb\|CP178454.1\|	3392114	g19268	i0	78.836	128.914979757085	189	27	100	12	3	185	3870503	3870684	Anabaena azotica SJ-1 chromosome, complete genome	blastn	31842	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena azotica
12715680	12715680	PRJNA859990_S_NODE_21130_length_243_cov_1.105882_g20869_i0	PRJNA859990	21130	243	1.105882	2.68729326	Nostocales	1161	Bacteria	Bacteria	226	1.2199999999999999e-54	NTclustered	gi\|1210177014\|dbj\|AP018248.1\|	231146	g20869	i0	85.581	22.9382716049383	215	31	88	0	10	224	611674	611888	Tolypothrix tenuis PCC 7101 DNA, nearly complete genome	blastn	5574	226	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix tenuis
13599654	13599654	PRJNA859990_S_NODE_3651_length_497_cov_2.384434_g3392_i0	PRJNA859990	3651	497	2.384434	11.85063698	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	676	0	NTclustered	gi\|225696224\|gb\|FJ805891.1\|	259957	g3392	i0	91.2	178.452716297787	500	40	100	3	1	497	1650	2148	Uncultured Chroococcidiopsis sp. clone NA2_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	88691	676	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
14873849	14873849	PRJNA859990_S_NODE_17592_length_252_cov_1.217877_g17331_i0	PRJNA859990	17592	252	1.217877	3.06905004	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	383	7.13e-102	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g17331	i0	94.048	295.769841269841	252	15	100	0	1	252	1858609	1858358	Calothrix sp. PCC 7716 DNA, complete genome	blastn	74534	383	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
14873894	14873894	PRJNA859990_S_NODE_21512_length_242_cov_1.485207_g21251_i0	PRJNA859990	21512	242	1.485207	3.59420094	Nostoc punctiforme	272131	Bacteria	Bacteria	226	1.2099999999999997e-54	NTclustered	gi\|186463002\|gb\|CP001037.1\|	63737	g21251	i0	84.188	5.86363636363636	234	35	96	2	10	242	6018117	6018349	Nostoc punctiforme PCC 73102 strain ATCC 29133 chromosome, complete genome	blastn	1419	226	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
14873949	14873949	PRJNA859990_S_NODE_4312_length_463_cov_0.948718_g4052_i0	PRJNA859990	4312	463	0.948718	4.39256434	Calothrix sp. PCC 6303	1170562	Bacteria	Bacteria	536	1.02e-147	NTclustered	gi\|428233323\|gb\|CP003610.1\|	1170562	g4052	i0	87.689	221.762419006479	463	53	99	4	1	461	736136	735676	Calothrix sp. PCC 6303, complete genome	blastn	102676	536	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
15263997	15263997	PRJNA859990_S_NODE_15752_length_264_cov_1.329843_g15491_i0	PRJNA859990	15752	264	1.329843	3.51078552	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	472	1.5599999999999998e-128	NTclustered	gi\|199584193\|gb\|FJ028685.1\|	1211	g15491	i0	98.864	99.9393939393939	264	3	100	0	1	264	302	39	Uncultured cyanobacterium clone SSB-42 16S ribosomal RNA gene, partial sequence	blastn	26384	472	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
16148642	16148642	PRJNA859990_S_NODE_22293_length_241_cov_0.869048_g22032_i0	PRJNA859990	22293	241	0.869048	2.09440568	Cylindrospermum sp. NIES-4074	2005457	Bacteria	Bacteria	139	1.62e-28	NTclustered	gi\|1210208533\|dbj\|AP018269.1\|	2005457	g22032	i0	81.548	4.17427385892116	168	31	70	0	1	168	1891917	1892084	Cylindrospermum sp. NIES-4074 DNA, nearly complete genome	blastn	1006	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Cylindrospermum	Cylindrospermum sp. NIES-4074
18697151	18697151	PRJNA859990_S_NODE_10575_length_313_cov_1.720833_g10314_i0	PRJNA859990	10575	313	1.720833	5.38620729	Aliterella chasmolithica	2739056	Bacteria	Bacteria	425	1.4999999999999999e-114	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g10314	i0	91.613	121.329073482428	310	22	98	4	1	308	2001	2308	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	37976	425	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
19972571	19972571	PRJNA859990_S_NODE_7316_length_368_cov_1.918644_g7055_i0	PRJNA859990	7316	368	1.918644	7.06060992	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	472	2.26e-128	NTclustered	gi\|225696254\|gb\|FJ805921.1\|	259957	g7055	i0	90	120.084239130435	370	29	99	7	1	366	2759	3124	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	44191	472	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23798235	23798235	PRJNA859990_S_NODE_7959_length_354_cov_2.601423_g7698_i0	PRJNA859990	7959	354	2.601423	9.20903742	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	433	1.0199999999999999e-116	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g7698	i0	88.92	106.254237288136	352	38	99	1	1	352	2762	3112	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	37614	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
24187757	24187757	PRJNA859990_S_NODE_7479_length_364_cov_50.646048_g7218_i0	PRJNA859990	7479	364	50.646048	184.35161472	Cyanophyceae	3028117	Bacteria	Bacteria	381	3.879999999999999e-101	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g7218	i0	85.676	62.8956043956044	370	44	99	6	1	362	2617299	2617667	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	22894	381	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
25072063	25072063	PRJNA859990_S_NODE_22380_length_240_cov_2.167665_g22119_i0	PRJNA859990	22380	240	2.167665	5.202396	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	405	1.44e-108	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g22119	i0	97.083	119.020833333333	240	7	100	0	1	240	2785	2546	Uncultured Chroococcidiopsis sp. clone NA3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28565	405	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis 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);;