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

15 rows where bioproject = "PRJNA797475", 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
2492372	2492372	PRJNA797475_P_NODE_2302_length_641_cov_2.125000_g2204_i0	PRJNA797475	2302	641	2.125	13.62125	root	1	Root_unresolved	Root_unresolved	1177	0	NTclustered	gi\|47594\|emb\|X53842.1\|	1148	g2204	i0	99.844	104.630265210608	641	0	100	1	1	641	263	902	Synechocystis sp. ndhE gene (partial), psaC gene for photosystem I iron-sulfur protein and ndhD-like ORF	blastn	67068	1184	0.994087837837838	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 6803
3768650	3768650	PRJNA797475_P_NODE_21823_length_251_cov_0.865169_g21724_i0	PRJNA797475	21823	251	0.865169	2.17157419	Oscillatoriales	1150	Bacteria	Bacteria	324	4.37e-84	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g21724	i0	90	5.97609561752988	250	25	99	0	1	250	938738	938987	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	1500	324	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
7159896	7159896	PRJNA797475_P_NODE_3206_length_546_cov_0.902748_g3108_i0	PRJNA797475	3206	546	0.902748	4.92900408	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	924	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g3108	i0	97.248	313.677655677656	545	15	99	0	2	546	1858739	1859283	Calothrix sp. PCC 7716 DNA, complete genome	blastn	171268	924	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
9709683	9709683	PRJNA797475_P_NODE_24388_length_248_cov_0.880000_g24289_i0	PRJNA797475	24388	248	0.88	2.1824	Leptolyngbya sp. LEGE 18517	3132512	Bacteria	Bacteria	440	4.0999999999999997e-119	NTclustered	gi\|2697880845\|gb\|PP476846.1\|	3132512	g24289	i0	98.785	107.661290322581	247	3	99	0	1	247	469	715	Leptolyngbya sp. LEGE 18517 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	26700	440	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. LEGE 18517
10985360	10985360	PRJNA797475_P_NODE_19929_length_258_cov_1.308108_g19830_i0	PRJNA797475	19929	258	1.308108	3.37491864	Spirirestis rafaelensis	293980	Bacteria	Bacteria	466	7.08e-127	NTclustered	gi\|1358126427\|gb\|KY963625.1\|	119528	g19830	i0	99.225	167.693798449612	258	2	100	0	1	258	520	777	Spirirestis rafaelensis SRS70 strain UTEX B 2660 23S ribosomal RNA gene, partial sequence	blastn	43265	466	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Spirirestis	Spirirestis rafaelensis
10985375	10985375	PRJNA797475_P_NODE_21029_length_252_cov_1.720670_g20930_i0	PRJNA797475	21029	252	1.72067	4.3360884	Nostoc sp. C117	3349875	Bacteria	Bacteria	250	7.55e-62	NTclustered	gi\|2831016856\|gb\|CP170991.1\|	3349875	g20930	i0	90.909	24.0952380952381	187	16	74	1	2	188	6456313	6456498	Nostoc sp. C117 chromosome, complete genome	blastn	6072	250	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C117
16084059	16084059	PRJNA797475_P_NODE_30853_length_233_cov_2.656250_g30754_i0	PRJNA797475	30853	233	2.65625	6.1890625	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	313	8.66e-81	NTclustered	gi\|2621703423\|emb\|OY762512.1\|	3040204	g30754	i0	91.342	114.188841201717	231	16	98	3	5	233	3669365	3669593	Pleurocapsa sp. FMAR1 isolate 44838 genome assembly, chromosome: 1	blastn	26606	313	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
20343433	20343433	PRJNA797475_P_NODE_9516_length_338_cov_1.845283_g9417_i0	PRJNA797475	9516	338	1.845283	6.23705654	Chroococcidiopsis	54298	Bacteria	Bacteria	553	7.179999999999998e-153	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g9417	i0	96.165	129.023668639053	339	12	100	1	1	338	794982	794644	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	43610	558	0.991039426523297	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
23734296	23734296	PRJNA797475_P_NODE_29719_length_241_cov_2.654762_g29620_i0	PRJNA797475	29719	241	2.654762	6.39797642	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	418	1.8599999999999995e-112	NTclustered	gi\|225696218\|gb\|FJ805885.1\|	259957	g29620	i0	97.934	105.680497925311	242	3	99	2	1	240	3153	3394	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	25469	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
27717711	27717711	PRJNA797475_P_NODE_16224_length_277_cov_1.509804_g16125_i0	PRJNA797475	16224	277	1.509804	4.18215708	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	44.7	0.0125	NR	MEB3260244.1	2847862	g16125	i0	36.8	0.823104693140794	76	44	80.1	2	55	276	2404	2477	MEB3260244.1 amino acid adenylation domain-containing protein [Cyanobacteriota bacterium]	diamond	228	44.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29138383	29138383	PRJNA797475_P_NODE_23809_length_248_cov_1.760000_g23710_i0	PRJNA797475	23809	248	1.76	4.3648	Pseudanabaena cinerea	2661616	Bacteria	Bacteria	50.4	4.65e-6	NR	WP_199302249.1	2661616	g23710	i0	36.5	0.762096774193548	63	40	76.2	0	246	58	6	68	WP_199302249.1 tetratricopeptide repeat protein [Pseudanabaena cinerea]	diamond	189	50.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena cinerea
29485180	29485180	PRJNA797475_P_NODE_25910_length_246_cov_0.890173_g25811_i0	PRJNA797475	25910	246	0.890173	2.18982558	Coleofasciculus sp. LEGE	3100458	Bacteria	Bacteria	116	1.18e-28	NR	WP_193933289.1	2777969	g25811	i0	68.2	2.08536585365854	85	23	98.8	1	2	244	196	280	WP_193933289.1 MFS transporter, partial [Coleofasciculus sp. LEGE 07092]	diamond	513	116	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. LEGE 07092
29611420	29611420	PRJNA797475_P_NODE_25210_length_247_cov_0.885057_g25111_i0	PRJNA797475	25210	247	0.885057	2.18609079	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	147	3.909999999999999e-41	NR	WP_250125609.1	155894	g25111	i0	95.1	9.95951417004049	82	4	99.6	0	2	247	55	136	WP_250125609.1 aspartate carbamoyltransferase catalytic subunit [Chroococcidiopsis sp. CCMEE 29]	diamond	2460	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
31485309	31485309	PRJNA797475_P_NODE_30996_length_228_cov_4.232258_g30897_i0	PRJNA797475	30996	228	4.232258	9.64954824	Bacteria	2	Bacteria	Bacteria	63.2	1.93e-9	NR	WP_124971646.1	1122	g30897	i0	50.9	1.89473684210526	57	28	75	0	56	226	16	72	WP_124971646.1 aminomethyl-transferring glycine dehydrogenase [Aphanothece sacrum]	diamond	432	63.5	0.995275590551181	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Aphanothece	Aphanothece sacrum
32709067	32709067	PRJNA797475_P_NODE_29960_length_241_cov_0.916667_g29861_i0	PRJNA797475	29960	241	0.916667	2.20916747	Acaryochloris sp. IP29b_bin.148	2969218	Bacteria	Bacteria	125	3.7099999999999997e-34	NR	WP_299411010.1	2969218	g29861	i0	73.4	0.983402489626556	79	21	98.3	0	3	239	83	161	WP_299411010.1 RICIN domain-containing protein [Acaryochloris sp. IP29b_bin.148]	diamond	237	125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris sp. IP29b_bin.148

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