metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA494251" and tax_clade = "Cyanobacteriota/Melainabacteria group"

12 rows where analysis = "blastn", bioproject = "PRJNA494251" 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
475421	475421	PRJNA494251_P_NODE_32161_length_264_cov_2.659686_g31847_i0	PRJNA494251	32161	264	2.659686	7.02157104	Gloeomargaritales cyanobacterium VI4D9	2898145	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2187466983\|emb\|OV696605.1\|	2898145	g31847	i0	100	0.106060606060606	28	0	11	0	49	76	1939948	1939975	Gloeomargaritales cyanobacterium VI4D9 isolate Thaho_VI4D9 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gloeomargaritales			Gloeomargaritales cyanobacterium VI4D9
475720	475720	PRJNA494251_S_NODE_641_length_268_cov_0.800000_g626_i0	PRJNA494251	641	268	0.8	2.144	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	431	2.7e-116	NTclustered	gi\|225696232\|gb\|FJ805899.1\|	259957	g626	i0	97.61	113.10447761194	251	6	94	0	14	264	2544	2794	Uncultured Chroococcidiopsis sp. clone NA3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	30312	431	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
3658099	3658099	PRJNA494251_P_NODE_52523_length_201_cov_4.039062_g52209_i0	PRJNA494251	52523	201	4.039062	8.11851462	Bacteria	2	Bacteria	Bacteria	65.8	2.25e-6	NTclustered	gi\|260070501\|gb\|GQ349231.1\|	1211	g52209	i0	91.489	1.40298507462687	47	4	23	0	155	201	1340	1294	Uncultured cyanobacterium clone SHAN605 16S ribosomal RNA gene, partial sequence	blastn	282	65.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
3658100	3658100	PRJNA494251_P_NODE_52543_length_200_cov_5.267717_g52229_i0	PRJNA494251	52543	200	5.267717	10.535434	root	1	Root_unresolved	Root_unresolved	370	4.22e-98	NTclustered	gi\|588284496\|gb\|KF951520.1\|	1211	g52229	i0	100	100.67	200	0	100	0	1	200	101	300	Uncultured cyanobacterium clone PS41 16S ribosomal RNA gene, partial sequence	blastn	20134	370	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
4301985	4301985	PRJNA494251_P_NODE_1184_length_1066_cov_4.525680_g1001_i0	PRJNA494251	1184	1066	4.52568	48.2437488	Prochlorothrix hollandica	1223	Bacteria	Bacteria	586	2.399999999999999e-162	NTclustered	gi\|146740638\|emb\|AM709625.1\|	317619	g1001	i0	83.881	357.498123827392	639	77	68	24	433	1061	2670	3292	Prochlorothrix hollandica SAG 10.89 partial ribosomal RNA operon, strain SAG 10.89	blastn	381093	586	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Prochlorotrichales	Prochlorotrichaceae	Prochlorothrix	Prochlorothrix hollandica
11954202	11954202	PRJNA494251_P_NODE_42430_length_246_cov_9.641618_g42116_i0	PRJNA494251	42430	246	9.641618	23.71838028	Aliterella chasmolithica	2739056	Bacteria	Bacteria	327	3.3e-85	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g42116	i0	94.393	109.00406504065	214	11	87	1	31	244	2178	1966	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	26815	327	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
17052885	17052885	PRJNA494251_P_NODE_51174_length_232_cov_2.276730_g50860_i0	PRJNA494251	51174	232	2.27673	5.2820136	Aliterella chasmolithica	2739056	Bacteria	Bacteria	320	5.15e-83	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g50860	i0	94.258	123.702586206897	209	12	90	0	21	229	2500	2292	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28699	320	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
17052985	17052985	PRJNA494251_S_NODE_574_length_284_cov_0.606635_g559_i0	PRJNA494251	574	284	0.606635	1.7228434	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	305	1.82e-78	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g559	i0	87.132	259.732394366197	272	32	95	3	1	271	1842	1573	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	73764	305	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19601565	19601565	PRJNA494251_S_NODE_696_length_259_cov_0.688172_g681_i0	PRJNA494251	696	259	0.688172	1.78236548	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	385	2.05e-102	NTclustered	gi\|225696248\|gb\|FJ805915.1\|	259957	g681	i0	94.779	161.96138996139	249	9	95	3	1	247	2369	2123	Uncultured Chroococcidiopsis sp. clone A1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	41948	385	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21508784	21508784	PRJNA494251_P_NODE_10917_length_407_cov_2.694611_g10611_i0	PRJNA494251	10917	407	2.694611	10.96706677	Bacteria	2	Bacteria	Bacteria	52.8	0.039	NTclustered	gi\|667665922\|dbj\|AP012549.1\|	1228987	g10611	i0	100	0.137592137592138	28	0	7	0	325	352	1613978	1614005	Cyanobacterium endosymbiont of Epithemia turgida isolate EtSB Lake Yunoko DNA, complete genome	blastn	56	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium endosymbiont of Epithemia turgida
22783955	22783955	PRJNA494251_P_NODE_21338_length_309_cov_2.233051_g21024_i0	PRJNA494251	21338	309	2.233051	6.90012759	Chroococcidiopsis	54298	Bacteria	Bacteria	547	3.0199999999999986e-151	NTclustered	gi\|192337879\|gb\|EU751488.1\|	1211	g21024	i0	98.701	98.9320388349515	308	4	99	0	1	308	580	273	Uncultured cyanobacterium clone SD-H03 16S ribosomal RNA gene, partial sequence	blastn	30570	547	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
24701411	24701411	PRJNA494251_P_NODE_40520_length_248_cov_0.880000_g40206_i0	PRJNA494251	40520	248	0.88	2.1824	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	211	3.5e-50	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g40206	i0	83.621	113.975806451613	232	31	91	6	1	225	3681401	3681170	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	28266	211	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium

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