metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA980585" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA980585" 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
954412	954412	PRJNA980585_P_NODE_1381_length_978_cov_2.230939_g320_i1	PRJNA980585	1381	978	2.230939	21.81858342	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1663	0	NTclustered	gi\|225696216\|gb\|FJ805883.1\|	259957	g320	i1	97.629	101.930470347648	970	21	99	2	1	969	2363	3331	Uncultured Chroococcidiopsis sp. clone NA4_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	99688	1663	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
2230431	2230431	PRJNA980585_P_NODE_52982_length_245_cov_0.895349_g52728_i0	PRJNA980585	52982	245	0.895349	2.19360505	Picosynechococcus sp. PCC 7003	374981	Bacteria	Bacteria	254	5.65e-63	NTclustered	gi\|2275105\|emb\|X97393.1\|	374981	g52728	i0	85.425	46.5795918367347	247	33	100	3	1	245	291	46	Synechococcus sp. rnpB gene, strain PCC7003	blastn	11412	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	Picosynechococcus sp. PCC 7003
3505449	3505449	PRJNA980585_P_NODE_403_length_1538_cov_3.127645_g320_i0	PRJNA980585	403	1538	3.127645	48.1031801	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	2431	0	NTclustered	gi\|225696219\|gb\|FJ805886.1\|	259957	g320	i0	95.484	109.767880364109	1528	60	99	7	10	1533	3328	1806	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	168823	2431	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
4783350	4783350	PRJNA980585_P_NODE_57864_length_242_cov_1.136095_g57610_i0	PRJNA980585	57864	242	1.136095	2.7493499	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	309	1.17e-79	NTclustered	gi\|225696185\|gb\|FJ805852.1\|	259957	g57610	i0	98.844	172.409090909091	173	2	71	0	11	183	3410	3238	Uncultured Chroococcidiopsis sp. clone AR1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	41723	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10198085	10198085	PRJNA980585_P_NODE_59988_length_241_cov_0.916667_g59734_i0	PRJNA980585	59988	241	0.916667	2.20916747	Bacillati	1783272	Bacteria	Bacteria	433	6.63e-117	NTclustered	gi\|47118304\|dbj\|BA000022.2\|	1148	g59734	i0	99.167	170.103734439834	240	2	99	0	2	241	7695	7456	Synechocystis sp. PCC 6803 DNA, complete genome	blastn	40995	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 6803
13708710	13708710	PRJNA980585_P_NODE_52591_length_245_cov_0.895349_g52337_i0	PRJNA980585	52591	245	0.895349	2.19360505	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	187	5.809999999999998e-43	NTclustered	gi\|2583116464\|gb\|CP119968.1\|	2859516	g52337	i0	80.658	2.00408163265306	243	45	99	2	4	245	4790727	4790486	Gloeocapsopsis dulcis strain AAB1 chromosome, complete genome	blastn	491	187	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
14023191	14023191	PRJNA980585_P_NODE_26691_length_289_cov_1.143519_g26437_i0	PRJNA980585	26691	289	1.143519	3.30476991	Chroococcidiopsis	54298	Bacteria	Bacteria	518	2.19e-142	NTclustered	gi\|192337879\|gb\|EU751488.1\|	1211	g26437	i0	98.962	99.0484429065744	289	3	100	0	1	289	433	721	Uncultured cyanobacterium clone SD-H03 16S ribosomal RNA gene, partial sequence	blastn	28625	523	0.990439770554493	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
16257854	16257854	PRJNA980585_P_NODE_46473_length_248_cov_0.880000_g46219_i0	PRJNA980585	46473	248	0.88	2.1824	Synechococcus sp. A15-24	1050635	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1895823488\|gb\|CP047960.1\|	1050635	g46219	i0	100	0.116935483870968	29	0	12	0	14	42	156031	156059	Synechococcus sp. A15-24 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. A15-24
16257882	16257882	PRJNA980585_P_NODE_48773_length_247_cov_0.885057_g48519_i0	PRJNA980585	48773	247	0.885057	2.18609079	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	307	4.32e-79	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g48519	i0	89.113	2.68825910931174	248	26	100	1	1	247	8441474	8441721	Calothrix sp. PCC 7716 DNA, complete genome	blastn	664	307	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
17532996	17532996	PRJNA980585_P_NODE_5054_length_563_cov_1.361224_g4800_i0	PRJNA980585	5054	563	1.361224	7.66369112	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	833	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g4800	i0	93.75	268.097690941385	560	27	99	6	3	561	9969449	9970001	Calothrix sp. PCC 7716 DNA, complete genome	blastn	150939	833	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
18806316	18806316	PRJNA980585_P_NODE_19875_length_324_cov_1.454183_g19621_i0	PRJNA980585	19875	324	1.454183	4.71155292	Aphanizomenon flos-aquae	1176	Bacteria	Bacteria	71.3	8.4e-8	NTclustered	gi\|2004375065\|gb\|CP051188.1\|	2717882	g19621	i0	90.566	1.57716049382716	53	5	16	0	11	63	3356071	3356123	Aphanizomenon flos-aquae DEX188 chromosome, complete genome	blastn	511	71.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Aphanizomenon	Aphanizomenon flos-aquae
20081579	20081579	PRJNA980585_P_NODE_50176_length_246_cov_1.410405_g49922_i0	PRJNA980585	50176	246	1.410405	3.4695963	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	303	5.56e-78	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g49922	i0	89.024	230.30487804878	246	26	100	1	1	246	1859183	1858939	Calothrix sp. PCC 7716 DNA, complete genome	blastn	56655	303	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
20081594	20081594	PRJNA980585_P_NODE_51316_length_246_cov_0.890173_g51062_i0	PRJNA980585	51316	246	0.890173	2.18982558	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	368	1.94e-97	NTclustered	gi\|225696218\|gb\|FJ805885.1\|	259957	g51062	i0	93.852	149.524390243902	244	15	99	0	1	244	3063	2820	Uncultured Chroococcidiopsis sp. clone NA4_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36783	368	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21671787	21671787	PRJNA980585_P_NODE_39417_length_253_cov_1.755556_g39163_i0	PRJNA980585	39417	253	1.755556	4.44155668	Cyanophyceae	3028117	Bacteria	Bacteria	435	1.95e-117	NTclustered	gi\|1992526127\|gb\|CP070366.1\|	2811482	g39163	i0	97.628	141.351778656126	253	6	100	0	1	253	2493409	2493157	Thermoleptolyngbya sp. PKUAC-SCTB121 chromosome, complete genome	blastn	35762	435	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya sp. PKUAC-SCTB121
23907446	23907446	PRJNA980585_P_NODE_43839_length_250_cov_0.870056_g43585_i0	PRJNA980585	43839	250	0.870056	2.17514	Synechococcus sp. CBW1004	1353136	Bacteria	Bacteria	67.6	8.09e-7	NTclustered	gi\|1940480550\|gb\|CP060397.1\|	1353136	g43585	i0	95.238	0.312	42	2	17	0	121	162	2678529	2678488	Synechococcus sp. CBW1004 chromosome, complete genome	blastn	78	67.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1004
23907593	23907593	PRJNA980585_P_NODE_54219_length_244_cov_0.900585_g53965_i0	PRJNA980585	54219	244	0.900585	2.1974274	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	418	1.8799999999999994e-112	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g53965	i0	97.541	1	244	6	100	0	1	244	8513265	8513022	Calothrix sp. PCC 7716 DNA, complete genome	blastn	244	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
23907686	23907686	PRJNA980585_P_NODE_60599_length_241_cov_0.916667_g60345_i0	PRJNA980585	60599	241	0.916667	2.20916747	Candidatus Paraprochloron terpiosi	2892031	Bacteria	Bacteria	62.1	3.6e-5	NTclustered	gi\|2030184695\|gb\|CP073341.1\|	2829509	g60345	i0	94.872	0.161825726141079	39	2	16	0	1	39	3044929	3044891	MAG: Candidatus Paraprochloron terpiosi LD05 chromosome, complete genome	blastn	39	62.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Prochloraceae	Candidatus Paraprochloron	Candidatus Paraprochloron terpiosi

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