metadata: contig_metadata: 19 rows where bioproject = "PRJNA789095" and tax_clade = "Cyanobacteriota/Melainabacteria group"

19 rows where bioproject = "PRJNA789095" 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
2489942	2489942	PRJNA789095_P_NODE_47382_length_292_cov_1.630137_g46048_i0	PRJNA789095	47382	292	1.630137	4.76000004	Chroococcaceae	1890464	Bacteria	Bacteria	418	2.3199999999999996e-112	NTclustered	gi\|485099145\|ref\|NR_102540.1\|	1173026	g46048	i0	92.466	286.256849315069	292	22	100	0	1	292	2875	2584	Gloeocapsa sp. PCC 7428 strain PCC 7428 23S ribosomal RNA, complete sequence	blastn	83587	418	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
3322480	3322480	PRJNA789095_P_NODE_61423_length_260_cov_2.144385_g60089_i0	PRJNA789095	61423	260	2.144385	5.575401	Brasilonema sennae	1397703	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1702166658\|gb\|CP030118.1\|	415709	g60089	i0	100	0.107692307692308	28	0	11	0	161	188	1061530	1061557	Brasilonema sennae CENA114 chromosome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema sennae
4598742	4598742	PRJNA789095_P_NODE_36784_length_335_cov_1.148855_g35450_i0	PRJNA789095	36784	335	1.148855	3.84866425	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	427	4.49e-115	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g35450	i0	89.881	128.64776119403	336	29	99	5	3	335	2861	3194	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	43097	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
5042721	5042721	PRJNA789095_P_NODE_35864_length_341_cov_0.936567_g34530_i0	PRJNA789095	35864	341	0.936567	3.19369347	Chroococcaceae	1890464	Bacteria	Bacteria	503	7.4e-138	NTclustered	gi\|485099145\|ref\|NR_102540.1\|	1173026	g34530	i0	93.294	111.692082111437	343	19	100	4	1	341	968	1308	Gloeocapsa sp. PCC 7428 strain PCC 7428 23S ribosomal RNA, complete sequence	blastn	38087	503	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
15242892	15242892	PRJNA789095_P_NODE_53692_length_277_cov_2.259804_g52358_i0	PRJNA789095	53692	277	2.259804	6.25965708	Chroococcus	70190	Bacteria	Bacteria	501	2.11e-137	NTclustered	gi\|322504110\|emb\|FR798921.1\|	980450	g52358	i0	99.278	105.072202166065	277	2	100	0	1	277	1	277	Chroococcus sp. 9E-04 partial 16S rRNA gene, strain 9E-04	blastn	29105	501	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chroococcus	Chroococcus sp. 9E-04
16073724	16073724	PRJNA789095_P_NODE_59413_length_265_cov_1.203125_g58079_i0	PRJNA789095	59413	265	1.203125	3.18828125	cyanobacterium NIES-2125	2510788	Bacteria	Bacteria	281	2.84e-71	NTclustered	gi\|1566846232\|dbj\|LC455610.1\|	2510788	g58079	i0	86.09	175.720754716981	266	32	100	4	1	265	140	401	Cyanobacterium NIES-2125 gene for 23S ribosomal RNA, partial sequence	blastn	46566	281	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-2125
17349762	17349762	PRJNA789095_P_NODE_69174_length_248_cov_0.880000_g67840_i0	PRJNA789095	69174	248	0.88	2.1824	uncultured cyanobacterium	1211	Bacteria	Bacteria	431	2.47e-116	NTclustered	gi\|386685926\|gb\|JQ612142.1\|	1211	g67840	i0	97.984	99.6008064516129	248	5	100	0	1	248	636	389	Uncultured cyanobacterium clone MSmat.3.13 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	24701	431	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
18623386	18623386	PRJNA789095_P_NODE_82235_length_196_cov_7.300813_g80901_i0	PRJNA789095	82235	196	7.300813	14.30959348	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	329	6.99e-86	NTclustered	gi\|2245124533\|gb\|CP097480.1\|	2653189	g80901	i0	96.939	2	196	6	100	0	1	196	6144586	6144781	Chroococcidiopsis sp. CCNUC1 chromosome, complete genome	blastn	392	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
23723494	23723494	PRJNA789095_P_NODE_43399_length_308_cov_1.451064_g42065_i0	PRJNA789095	43399	308	1.451064	4.46927712	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	442	1.4599999999999994e-119	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g42065	i0	92.532	120.821428571429	308	23	100	0	1	308	3266	2959	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	37213	442	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
24166178	24166178	PRJNA789095_P_NODE_80359_length_218_cov_6.586207_g79025_i0	PRJNA789095	80359	218	6.586207	14.35793126	root	1	Root_unresolved	Root_unresolved	180	8.47e-41	NTclustered	gi\|1861038541\|dbj\|LC557454.1\|	1126	g79025	i0	99	66.9724770642202	100	1	46	0	119	218	2510	2411	Microcystis aeruginosa NIES-1062 gene for 23S rRNA, partial sequence	blastn	14600	180	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
24997741	24997741	PRJNA789095_P_NODE_62920_length_257_cov_1.440217_g61586_i0	PRJNA789095	62920	257	1.440217	3.70135769	uncultured Rivularia sp.	447564	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2621703013\|emb\|OY762007.1\|	447564	g61586	i0	100	0.108949416342412	28	0	11	0	203	230	4852664	4852637	MAG: uncultured Rivularia sp. isolate bc3217e8-a359-4fa3-9fd5-735ade2a2895 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rivulariaceae	Rivularia	uncultured Rivularia sp.
27622566	27622566	PRJNA789095_P_NODE_41844_length_310_cov_3.286920_g40510_i0	PRJNA789095	41844	310	3.28692	10.189452	Cyanobacteria bacterium J06649_11	3023232	Bacteria	Bacteria	43.5	0.0176	NR	MEO0687191.1	3023232	g40510	i0	30.6	0.696774193548387	72	44	69.7	1	303	88	2	67	MEO0687191.1 YbjN domain-containing protein [Cyanobacteria bacterium J06649_11]	diamond	216	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06649_11
27780417	27780417	PRJNA789095_P_NODE_79584_length_226_cov_2.875817_g78250_i0	PRJNA789095	79584	226	2.875817	6.49934642	Cyanobacteria bacterium J06553_1	3023125	Bacteria	Bacteria	63.5	6.58e-10	NR	MEL7523216.1	3023125	g78250	i0	58.8	0.676991150442478	51	21	67.7	0	69	221	122	172	MEL7523216.1 endonuclease/exonuclease/phosphatase family protein [Cyanobacteria bacterium J06553_1]	diamond	153	63.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06553_1
29832578	29832578	PRJNA789095_P_NODE_71171_length_245_cov_6.133721_g69837_i0	PRJNA789095	71171	245	6.133721	15.02761645	Cyanobacteria bacterium J06553_1	3023125	Bacteria	Bacteria	75.1	1.53e-13	NR	MEL7520422.1	3023125	g69837	i0	68.9	0.551020408163265	45	14	55.1	0	244	110	367	411	MEL7520422.1 reverse transcriptase family protein [Cyanobacteria bacterium J06553_1]	diamond	135	75.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06553_1
30116794	30116794	PRJNA789095_P_NODE_41232_length_310_cov_4.388186_g39898_i0	PRJNA789095	41232	310	4.388186	13.6033766	Cyanobacteria bacterium J06553_1	3023125	Bacteria	Bacteria	58.2	3.2e-7	NR	MEL7520422.1	3023125	g39898	i0	63	0.445161290322581	46	15	42.6	1	178	309	651	696	MEL7520422.1 reverse transcriptase family protein [Cyanobacteria bacterium J06553_1]	diamond	138	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06553_1
30211518	30211518	PRJNA789095_P_NODE_13392_length_783_cov_1.363380_g12157_i0	PRJNA789095	13392	783	1.36338	10.6752654	Cyanobacteria bacterium J06553_1	3023125	Bacteria	Bacteria	290	1.44e-89	NR	MEL7520422.1	3023125	g12157	i0	58.9	1.00766283524904	263	104	99.6	3	781	2	252	513	MEL7520422.1 reverse transcriptase family protein [Cyanobacteria bacterium J06553_1]	diamond	789	290	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06553_1
30780406	30780406	PRJNA789095_P_NODE_67934_length_249_cov_0.875000_g66600_i0	PRJNA789095	67934	249	0.875	2.17875	Hydrococcus sp. SU_1_0	2720475	Bacteria	Bacteria	76.6	2.28e-14	NR	NJL51449.1	2720475	g66600	i0	51.8	1	83	39	98.8	1	3	248	73	155	NJL51449.1 hypothetical protein [Hydrococcus sp. SU_1_0]	diamond	249	76.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hydrococcaceae	Hydrococcus	Hydrococcus sp. SU_1_0
31285905	31285905	PRJNA789095_P_NODE_11555_length_893_cov_7.596341_g10396_i0	PRJNA789095	11555	893	7.596341	67.83532513	Hydrococcus sp. SU_1_0	2720475	Bacteria	Bacteria	64.7	7.71e-8	NR	NJL51449.1	2720475	g10396	i0	48.3	0.201567749160134	60	31	20.2	0	610	789	222	281	NJL51449.1 hypothetical protein [Hydrococcus sp. SU_1_0]	diamond	180	64.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hydrococcaceae	Hydrococcus	Hydrococcus sp. SU_1_0
32393306	32393306	PRJNA789095_P_NODE_60559_length_262_cov_1.867725_g59225_i0	PRJNA789095	60559	262	1.867725	4.8934395	Aphanothece sp. CMT-3BRIN-NPC111	2839655	Bacteria	Bacteria	114	2.57e-29	NR	MBW4575085.1	2839655	g59225	i0	90.3	0.709923664122137	62	6	71	0	188	3	14	75	MBW4575085.1 sulfate ABC transporter permease subunit CysT [Aphanothece sp. CMT-3BRIN-NPC111]	diamond	186	114	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Aphanothece	Aphanothece sp. CMT-3BRIN-NPC111

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