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

11 rows where analysis = "blastn", bioproject = "PRJNA188516" 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
5469179	5469179	PRJNA188516_P_NODE_5905_length_162_cov_1.380531_g5855_i0	PRJNA188516	5905	162	1.380531	2.23646022	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	195	2.12e-45	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g5855	i0	88.415	1.96296296296296	164	15	100	4	1	162	2594201	2594040	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	318	195	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
6157914	6157914	PRJNA188516_P_NODE_1145_length_350_cov_2.289037_g1095_i0	PRJNA188516	1145	350	2.289037	8.0116295	Nostocaceae	1162	Bacteria	Bacteria	630	3.3399999999999984e-176	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g1095	i0	99.145	282.274285714286	351	1	100	2	1	350	2378397	2378746	Nostoc sp. PCC 7120 DNA, complete genome	blastn	98796	630	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
8707918	8707918	PRJNA188516_P_NODE_1707_length_271_cov_1.495495_g1657_i0	PRJNA188516	1707	271	1.495495	4.05279145	Microcoleus	44471	Bacteria	Bacteria	496	9.55e-136	NTclustered	gi\|389547084\|gb\|JQ402012.1\|	1211	g1657	i0	99.631	100.007380073801	271	1	100	0	1	271	24	294	Uncultured cyanobacterium clone CNY_02268 16S ribosomal RNA gene, partial sequence	blastn	27102	496	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
8707919	8707919	PRJNA188516_P_NODE_2407_length_221_cov_1.558140_g2357_i0	PRJNA188516	2407	221	1.55814	3.4434894	Chroococcidiopsis	54298	Bacteria	Bacteria	324	3.76e-84	NTclustered	gi\|225696259\|gb\|FJ805926.1\|	259957	g2357	i0	93.213	149.085972850679	221	14	100	1	1	221	2855	3074	Uncultured Chroococcidiopsis sp. clone AS3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32948	327	0.990825688073395	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9983243	9983243	PRJNA188516_P_NODE_568_length_522_cov_1.534884_g518_i0	PRJNA188516	568	522	1.534884	8.01209448	Nostocaceae	1162	Bacteria	Bacteria	926	0	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g518	i0	98.844	303.890804597701	519	6	100	0	4	522	2378274	2377756	Nostoc sp. PCC 7120 DNA, complete genome	blastn	158631	926	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
11844376	11844376	PRJNA188516_P_NODE_370_length_666_cov_1.894652_g326_i0	PRJNA188516	370	666	1.894652	12.61838232	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	913	0	NTclustered	gi\|225696282\|gb\|FJ805949.1\|	259957	g326	i0	91.48	158.65015015015	669	50	100	7	1	666	2626	1962	Uncultured Chroococcidiopsis sp. clone AS5_7 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	105661	913	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13119557	13119557	PRJNA188516_P_NODE_2311_length_226_cov_1.395480_g2261_i0	PRJNA188516	2311	226	1.39548	3.1537848	Plectolyngbya koreana	3016458	Bacteria	Bacteria	283	6.55e-72	NTclustered	gi\|2106138547\|gb\|OK382087.1\|	2880695	g2261	i0	89.778	146.101769911504	225	18	99	5	1	223	2030	2251	Plectolyngbya koreana FBCC-A1478 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	33019	283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Plectolyngbya	Plectolyngbya koreana
15668560	15668560	PRJNA188516_P_NODE_1613_length_281_cov_1.512931_g1563_i0	PRJNA188516	1613	281	1.512931	4.25133611	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	453	6.08e-123	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g1563	i0	95.73	110.142348754448	281	12	100	0	1	281	3568	3848	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	30950	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20181248	20181248	PRJNA188516_P_NODE_3936_length_171_cov_0.852459_g3886_i0	PRJNA188516	3936	171	0.852459	1.45770489	root	1	Root_unresolved	Root_unresolved	311	2.14e-80	NTclustered	gi\|321140180\|gb\|GQ325743.1\|	1211	g3886	i0	99.415	102.602339181287	171	1	100	0	1	171	449	279	Uncultured cyanobacterium clone SP1_1B_34 16S ribosomal RNA gene, partial sequence	blastn	17545	311	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
21456968	21456968	PRJNA188516_P_NODE_577_length_518_cov_2.176972_g527_i0	PRJNA188516	577	518	2.176972	11.27671496	Nostocaceae	1162	Bacteria	Bacteria	880	0	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g527	i0	97.476	285.353281853282	515	13	100	0	1	515	2380475	2380989	Nostoc sp. PCC 7120 DNA, complete genome	blastn	147813	885	0.994350282485876	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
23317879	23317879	PRJNA188516_P_NODE_2099_length_238_cov_2.306878_g2049_i0	PRJNA188516	2099	238	2.306878	5.49036964	Oculatella lusitanica	2928764	Bacteria	Bacteria	407	3.9599999999999994e-109	NTclustered	gi\|1793889078\|gb\|MN061918.1\|	2692086	g2049	i0	97.872	148.323529411765	235	5	99	0	4	238	3223	2989	Oculatella lusitanica LEGE 161147 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	35301	407	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella lusitanica

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