metadata: contig_metadata: 13 rows where bioproject = "PRJNA797655" and tax_clade = "Cyanobacteriota/Melainabacteria group"

13 rows where bioproject = "PRJNA797655" 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
785630	785630	PRJNA797655_S_NODE_231101_length_165_cov_2.360656_g230496_i0	PRJNA797655	231101	165	2.360656	3.8950824	uncultured Rivularia sp.	447564	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2621703013\|emb\|OY762007.1\|	447564	g230496	i0	97.059	0.206060606060606	34	0	20	1	35	67	567255	567222	MAG: uncultured Rivularia sp. isolate bc3217e8-a359-4fa3-9fd5-735ade2a2895 genome assembly, chromosome: 1	blastn	34	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rivulariaceae	Rivularia	uncultured Rivularia sp.
2057937	2057937	PRJNA797655_S_NODE_117482_length_230_cov_2.053476_g116877_i0	PRJNA797655	117482	230	2.053476	4.7229948	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	226	1.1399999999999999e-54	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g116877	i0	84.416	16.9608695652174	231	34	100	2	1	230	3226	2997	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	3901	226	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7164290	7164290	PRJNA797655_S_NODE_24046_length_392_cov_1.830946_g23442_i0	PRJNA797655	24046	392	1.830946	7.17730832	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	604	2.2899999999999992e-168	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g23442	i0	94.643	105.68112244898	392	18	100	2	1	392	3223	2835	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	41427	604	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9710231	9710231	PRJNA797655_S_NODE_112068_length_235_cov_1.250000_g111463_i0	PRJNA797655	112068	235	1.25	2.9375	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g111463	i0	100	0.119148936170213	28	0	12	0	78	105	354451	354478	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
12268403	12268403	PRJNA797655_S_NODE_84490_length_262_cov_3.301370_g83885_i0	PRJNA797655	84490	262	3.30137	8.6495894	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	446	9.379999999999998e-121	NTclustered	gi\|2729058729\|emb\|OZ007029.1\|	2137880	g83885	i0	97.328	1	262	7	100	0	1	262	16586	16325	MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1	blastn	262	446	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
14816644	14816644	PRJNA797655_S_NODE_59692_length_297_cov_1.456693_g59087_i0	PRJNA797655	59692	297	1.456693	4.32637821	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g59087	i0	88.889	0.151515151515152	45	2	14	2	47	88	1079068	1079112	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	45	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium MEL.A1
22895187	22895187	PRJNA797655_S_NODE_98118_length_248_cov_1.609756_g97513_i0	PRJNA797655	98118	248	1.609756	3.99219488	Nostoc	1177	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|186463002\|gb\|CP001037.1\|	63737	g97513	i0	100	0.451612903225806	28	0	11	0	22	49	7834486	7834513	Nostoc punctiforme PCC 73102 strain ATCC 29133 chromosome, complete genome	blastn	112	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
26610521	26610521	PRJNA797655_S_NODE_111661_length_235_cov_2.000000_g111056_i0	PRJNA797655	111661	235	2	4.7	Prochlorococcus sp. MIT 13	1220	Bacteria	Bacteria	43.1	0.0236	NR	WP_320666672.1	3096219	g111056	i0	38.8	0.625531914893617	49	30	62.6	0	19	165	12	60	WP_320666672.1 SDR family oxidoreductase [Prochlorococcus sp. MIT 1307]	diamond	147	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus sp. MIT 1307
27180080	27180080	PRJNA797655_S_NODE_219442_length_170_cov_1.889764_g218837_i0	PRJNA797655	219442	170	1.889764	3.2125988	Coleofasciculaceae cyanobacterium	3081323	Bacteria	Bacteria	40.4	0.0441	NR	HEY9637319.1	3081323	g218837	i0	41.7	0.847058823529412	48	27	84.7	1	26	169	76	122	HEY9637319.1 hypothetical protein [Coleofasciculaceae cyanobacterium]	diamond	144	40.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium
28412031	28412031	PRJNA797655_S_NODE_268706_length_152_cov_1.761468_g268101_i0	PRJNA797655	268706	152	1.761468	2.67743136	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	103	3.79e-24	NR	MBQ2984034.1	2137880	g268101	i0	98	1.97368421052632	50	1	98.7	0	150	1	363	412	MBQ2984034.1 glycogen synthase [Candidatus Gastranaerophilales bacterium]	diamond	300	103	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
29990782	29990782	PRJNA797655_S_NODE_240151_length_162_cov_1.210084_g239546_i0	PRJNA797655	240151	162	1.210084	1.96033608	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	51.2	1.3e-5	NR	MBW4637243.1	2839657	g239546	i0	96.2	0.481481481481481	26	1	48.1	0	78	1	658	683	MBW4637243.1 FG-GAP repeat protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	78	51.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
31317828	31317828	PRJNA797655_S_NODE_94535_length_251_cov_3.456731_g93930_i0	PRJNA797655	94535	251	3.456731	8.67639481	Pseudanabaena biceps	927669	Bacteria	Bacteria	43.5	0.0214	NR	NUN63272.1	927669	g93930	i0	52.3	0.525896414342629	44	19	50.2	1	173	48	16	59	NUN63272.1 hypothetical protein [Pseudanabaena biceps]	diamond	132	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena biceps
31571072	31571072	PRJNA797655_S_NODE_233816_length_164_cov_1.983471_g233211_i0	PRJNA797655	233816	164	1.983471	3.25289244	[Leptolyngbya] sp. PCC 7376	111781	Bacteria	Bacteria	41.6	0.0332	NR	WP_015134319.1	111781	g233211	i0	41	0.713414634146341	39	23	71.3	0	118	2	363	401	WP_015134319.1 CHASE2 domain-containing protein [[Leptolyngbya] sp. PCC 7376]	diamond	117	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	[Leptolyngbya] sp. PCC 7376

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