metadata: contig_metadata: 21 rows where bioproject = "PRJNA1000943", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

21 rows where bioproject = "PRJNA1000943", tax_clade = "Cyanobacteriota/Melainabacteria group" 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
2695327	2695327	PRJNA1000943_P_NODE_15603_length_242_cov_0.834320_g15465_i0	PRJNA1000943	15603	242	0.83432	2.0190544	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	329	8.99e-86	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g15465	i0	91.286	231.074380165289	241	21	99	0	1	241	3669250	3669490	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	55920	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
2695346	2695346	PRJNA1000943_P_NODE_3063_length_441_cov_2.116848_g2926_i0	PRJNA1000943	3063	441	2.116848	9.33529968	Synechococcales	1890424	Bacteria	Bacteria	199	2.8e-62	NR	CAK29280.1	316278	g2926	i0	68.8	9.18367346938776	138	43	93.9	0	415	2	35	172	CAK29280.1 Nucleoside diphosphate kinase [Synechococcus sp. RCC307]	diamond	4050	201	0.990049751243781	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. RCC307
7797590	7797590	PRJNA1000943_P_NODE_12207_length_250_cov_0.881356_g12069_i0	PRJNA1000943	12207	250	0.881356	2.20339	Synechococcus sp. PCC 75	1131	Bacteria	Bacteria	125	1.11e-34	NR	WP_015167005.1	1173263	g12069	i0	70.7	4.896	82	24	98.4	0	248	3	1	82	WP_015167005.1 nucleoside-diphosphate kinase [Synechococcus sp. PCC 7502]	diamond	1224	125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. PCC 7502
10348349	10348349	PRJNA1000943_P_NODE_9429_length_271_cov_1.651515_g9291_i0	PRJNA1000943	9429	271	1.651515	4.47560565	Trichocoleus sp. 1.9A	2876723	Bacteria	Bacteria	344	3.6599999999999997e-90	NTclustered	gi\|2095813678\|gb\|OK161232.1\|	2876723	g9291	i0	91.935	177.09594095941	248	17	92	3	24	271	3409	3653	Trichocoleus sp. 1.9A 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	47993	344	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus	Trichocoleus sp. 1.9A
13752697	13752697	PRJNA1000943_P_NODE_13591_length_246_cov_1.803468_g13453_i0	PRJNA1000943	13591	246	1.803468	4.43653128	root	1	Root_unresolved	Root_unresolved	141	4.61e-29	NTclustered	gi\|586852035\|gb\|KF896310.1\|	1211	g13453	i0	88.136	50.0365853658537	118	14	48	0	126	243	90	207	Uncultured cyanobacterium clone T0_C1 16S ribosomal RNA gene, partial sequence	blastn	12309	141	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
15447806	15447806	PRJNA1000943_P_NODE_13453_length_247_cov_0.896552_g13315_i0	PRJNA1000943	13453	247	0.896552	2.21448344	Aliterella atlantica	1827278	Bacteria	Bacteria	130	3.919999999999999e-34	NR	WP_045055105.1	1827278	g13315	i0	83.8	0.97165991902834	80	13	97.2	0	242	3	257	336	WP_045055105.1 glutamate--cysteine ligase [Aliterella atlantica]	diamond	240	130	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
15447900	15447900	PRJNA1000943_P_NODE_6533_length_318_cov_1.534694_g6395_i0	PRJNA1000943	6533	318	1.534694	4.88032692	uncultured cyanobacterium	1211	Bacteria	Bacteria	527	4.06e-145	NTclustered	gi\|389547566\|gb\|JQ402494.1\|	1211	g6395	i0	96.541	100.487421383648	318	11	100	0	1	318	643	326	Uncultured cyanobacterium clone CNY_02855 16S ribosomal RNA gene, partial sequence	blastn	31955	527	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
24371034	24371034	PRJNA1000943_P_NODE_4280_length_380_cov_2.188925_g4143_i0	PRJNA1000943	4280	380	2.188925	8.317915	Dulcicalothrix desertica	32056	Bacteria	Bacteria	697	0	NTclustered	gi\|283766156\|gb\|GQ980023.1\|	232991	g4143	i0	99.737	169.597368421053	380	1	100	0	1	380	63	442	Calothrix desertica PCC 7102 23S large subunit ribosomal RNA (rrnL) gene, partial sequence	blastn	64447	697	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Dulcicalothrix	Dulcicalothrix desertica
26717408	26717408	PRJNA1000943_P_NODE_8681_length_281_cov_1.875000_g8543_i0	PRJNA1000943	8681	281	1.875	5.26875	Brasilonema sp. CT11	2748322	Bacteria	Bacteria	69.7	1.84e-11	NR	MBP5977729.1	2748322	g8543	i0	49.4	0.886120996441281	83	40	86.5	1	243	1	88	170	MBP5977729.1 hypothetical protein [Brasilonema sp. CT11]	diamond	249	69.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema sp. CT11
26970945	26970945	PRJNA1000943_P_NODE_15982_length_228_cov_2.012903_g15844_i0	PRJNA1000943	15982	228	2.012903	4.5894188400000004	Pleurocapsa sp. SU_196_0	2720476	Bacteria	Bacteria	89	7.06e-20	NR	NJK44778.1	2720476	g15844	i0	57.3	1.97368421052632	75	32	98.7	0	227	3	52	126	NJK44778.1 hypothetical protein [Pleurocapsa sp. SU_196_0]	diamond	450	89	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. SU_196_0
27343319	27343319	PRJNA1000943_P_NODE_13863_length_246_cov_0.901734_g13725_i0	PRJNA1000943	13863	246	0.901734	2.21826564	Cyanophyceae	3028117	Bacteria	Bacteria	104	7.56e-26	NR	WP_223048715.1	2917832	g13725	i0	64.2	5.91463414634146	81	25	98.8	1	244	2	61	137	WP_223048715.1 peroxiredoxin [Leptothermofonsia sichuanensis]	diamond	1455	105	0.990476190476191	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptothermofonsia	Leptothermofonsia sichuanensis
28037825	28037825	PRJNA1000943_P_NODE_12725_length_249_cov_0.886364_g12587_i0	PRJNA1000943	12725	249	0.886364	2.20704636	Chroococcaceae	1890464	Bacteria	Bacteria	150	1.5e-41	NR	WP_073550709.1	329163	g12587	i0	92.7	5.92771084337349	82	6	98.8	0	2	247	144	225	WP_073550709.1 FAD-binding oxidoreductase [Chroogloeocystis siderophila]	diamond	1476	151	0.993377483443709	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chroogloeocystis	Chroogloeocystis siderophila
28076592	28076592	PRJNA1000943_P_NODE_6925_length_310_cov_1.316456_g6787_i0	PRJNA1000943	6925	310	1.316456	4.0810136	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	73.2	7.38e-13	NR	MDY7014614.1	2847862	g6787	i0	38.9	0.919354838709677	95	48	82.3	1	49	303	80	174	MDY7014614.1 PEP-CTERM sorting domain-containing protein [Cyanobacteriota bacterium]	diamond	285	73.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28100725	28100725	PRJNA1000943_P_NODE_10405_length_260_cov_1.171123_g10267_i0	PRJNA1000943	10405	260	1.171123	3.0449198	root	1	Root_unresolved	Root_unresolved	102	3.71e-23	NR	WP_015204073.1	241425	g10267	i0	58.1	35.55	86	36	99.2	0	259	2	207	292	WP_015204073.1 NAD-dependent succinate-semialdehyde dehydrogenase [Crinalium epipsammum]	diamond	9243	103	0.990291262135922	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Gomontiellaceae	Crinalium	Crinalium epipsammum
28613444	28613444	PRJNA1000943_P_NODE_7747_length_296_cov_1.080717_g7609_i0	PRJNA1000943	7747	296	1.080717	3.19892232	Rippkaea orientalis	2546366	Bacteria	Bacteria	133	4.519999999999999e-35	NR	WP_012597003.1	2546366	g7609	i0	60.8	5.92905405405405	97	36	98.3	1	4	294	222	316	WP_012597003.1 pyridoxal-phosphate-dependent aminotransferase family protein [Rippkaea orientalis]	diamond	1755	133	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Rippkaea	Rippkaea orientalis
28637847	28637847	PRJNA1000943_P_NODE_9387_length_272_cov_1.226131_g9249_i0	PRJNA1000943	9387	272	1.226131	3.33507632	Bacteria	2	Bacteria	Bacteria	43.1	0.039	NR	PLS69598.1	2054928	g9249	i0	46.2	0.860294117647059	39	21	43	0	70	186	607	645	PLS69598.1 MAG: hypothetical protein CV045_00975 [Cyanobacteria bacterium M5B4]	diamond	234	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium M5B4
28834442	28834442	PRJNA1000943_P_NODE_6248_length_324_cov_1.243028_g6110_i0	PRJNA1000943	6248	324	1.243028	4.02741072	Calothrix sp. NIES-21	1187	Bacteria	Bacteria	68.2	1.1e-10	NR	WP_096606147.1	1954172	g6110	i0	66.7	0.416666666666667	45	15	41.7	0	1	135	75	119	WP_096606147.1 Rieske 2Fe-2S domain-containing protein [Calothrix sp. NIES-2100]	diamond	135	68.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-2100
29048233	29048233	PRJNA1000943_P_NODE_6128_length_326_cov_2.343874_g5990_i0	PRJNA1000943	6128	326	2.343874	7.64102924	Cyanophyceae	3028117	Bacteria	Bacteria	75.5	7.86e-14	NR	MBF2077789.1	2774349	g5990	i0	43.5	3.02760736196319	108	60	98.5	1	326	6	127	234	MBF2077789.1 SIMPL domain-containing protein [Synechococcales cyanobacterium T60_A2020_003]	diamond	987	75.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales			Synechococcales cyanobacterium T60_A2020_003
31202940	31202940	PRJNA1000943_P_NODE_8855_length_279_cov_1.514563_g8717_i0	PRJNA1000943	8855	279	1.514563	4.22563077	Coleofasciculus sp. H7-2	3351545	Bacteria	Bacteria	127	9.91e-32	NR	WP_378176314.1	3351545	g8717	i0	66	1.01075268817204	94	28	96.8	1	8	277	411	504	WP_378176314.1 phosphoketolase [Coleofasciculus sp. H7-2]	diamond	282	127	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. H7-2
32405615	32405615	PRJNA1000943_P_NODE_14219_length_245_cov_0.906977_g14081_i0	PRJNA1000943	14219	245	0.906977	2.22209365	Brasilonema sp. CT11	2748322	Bacteria	Bacteria	51.2	1.47e-5	NR	MBP5977894.1	2748322	g14081	i0	53.8	0.636734693877551	52	24	63.7	0	236	81	51	102	MBP5977894.1 hypothetical protein [Brasilonema sp. CT11]	diamond	156	51.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema sp. CT11
32405621	32405621	PRJNA1000943_P_NODE_479_length_1022_cov_10.962065_g396_i0	PRJNA1000943	479	1022	10.962065	112.0323043	Nostoc sp. EfeVER	1180	Bacteria	Bacteria	49.7	0.00234	NR	WP_322687120.1	3075406	g396	i0	47.3	0.161448140900196	55	27	15.6	2	1004	846	59	113	WP_322687120.1 hypothetical protein [Nostoc sp. EfeVER01]	diamond	165	49.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. EfeVER01

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