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

14 rows where analysis = "blastn", bioproject = "PRJEB83711" 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
3970558	3970558	PRJEB83711_P_NODE_58284_length_253_cov_0.866667_g58018_i0	PRJEB83711	58284	253	0.866667	2.19266751	Nostoc sp. UHCC 0302	3134896	Bacteria	Bacteria	145	3.68e-30	NTclustered	gi\|2717038756\|gb\|CP151099.1\|	3134896	g58018	i0	79.048	1.61264822134387	210	44	83	0	2	211	8281896	8282105	Nostoc sp. UHCC 0302 chromosome, complete genome	blastn	408	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0302
5247472	5247472	PRJEB83711_P_NODE_77065_length_243_cov_0.917647_g76799_i0	PRJEB83711	77065	243	0.917647	2.22988221	Brasilonema sennae	1397703	Bacteria	Bacteria	248	2.6e-61	NTclustered	gi\|1702166658\|gb\|CP030118.1\|	415709	g76799	i0	86.087	2.76131687242798	230	32	95	0	6	235	2601131	2600902	Brasilonema sennae CENA114 chromosome	blastn	671	248	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema sennae
6101950	6101950	PRJEB83711_P_NODE_58125_length_253_cov_0.866667_g57859_i0	PRJEB83711	58125	253	0.866667	2.19266751	Chroococcidiopsis	54298	Bacteria	Bacteria	259	1.26e-64	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g57859	i0	85.283	2.09486166007905	265	24	100	5	1	253	3990592	3990853	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	530	259	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
6522083	6522083	PRJEB83711_P_NODE_35026_length_305_cov_1.875000_g34760_i0	PRJEB83711	35026	305	1.875	5.71875	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	248	3.38e-61	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g34760	i0	82.971	0.904918032786885	276	45	90	2	17	291	3669222	3669496	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	276	248	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
8651835	8651835	PRJEB83711_P_NODE_45947_length_275_cov_1.544554_g45681_i0	PRJEB83711	45947	275	1.544554	4.2475235	Chroococcidiopsis	54298	Bacteria	Bacteria	492	1.26e-134	NTclustered	gi\|485099067\|ref\|NR_102464.1\|	251229	g45681	i0	98.909	96.4618181818182	275	3	100	0	1	275	4	278	Chroococcidiopsis thermalis PCC 7203 16S ribosomal RNA, partial sequence	blastn	26527	492	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
10346646	10346646	PRJEB83711_P_NODE_26889_length_344_cov_1.439114_g26623_i0	PRJEB83711	26889	344	1.439114	4.95055216	Chondrocystis sp. NIES-4102	2005460	Bacteria	Bacteria	636	7.059999999999998e-178	NTclustered	gi\|1210223977\|dbj\|AP018281.1\|	2005460	g26623	i0	100	208.462209302326	344	0	100	0	1	344	4002882	4002539	Chondrocystis sp. NIES-4102 DNA, complete genome	blastn	71711	636	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chondrocystis	Chondrocystis sp. NIES-4102
10347464	10347464	PRJEB83711_P_NODE_62109_length_251_cov_0.876404_g61843_i0	PRJEB83711	62109	251	0.876404	2.19977404	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	287	5.73e-73	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g61843	i0	87.352	84.0956175298805	253	28	100	4	1	251	1381909	1381659	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	21108	287	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium MEL.A1
11622737	11622737	PRJEB83711_P_NODE_50490_length_266_cov_1.378238_g50224_i0	PRJEB83711	50490	266	1.378238	3.66611308	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	459	1.2299999999999998e-124	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g50224	i0	97.744	2.99624060150376	266	6	100	0	1	266	5975241	5974976	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	797	459	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
16720712	16720712	PRJEB83711_P_NODE_3934_length_904_cov_2.871239_g3730_i0	PRJEB83711	3934	904	2.871239	25.95600056	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1175	0	NTclustered	gi\|225696206\|gb\|FJ805873.1\|	259957	g3730	i0	90.098	132.296460176991	919	71	100	12	1	904	3194	2281	Uncultured Chroococcidiopsis sp. clone A2_15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	119596	1175	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16720728	16720728	PRJEB83711_P_NODE_40054_length_289_cov_1.157407_g39788_i0	PRJEB83711	40054	289	1.157407	3.34490623	Nostoc flagelliforme	1306274	Bacteria	Bacteria	215	3.22e-51	NTclustered	gi\|1297075411\|gb\|CP024785.1\|	2038116	g39788	i0	92.617	2.08650519031142	149	11	52	0	141	289	308929	308781	Nostoc flagelliforme CCNUN1 chromosome, complete genome	blastn	603	215	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc flagelliforme
17576484	17576484	PRJEB83711_P_NODE_39614_length_290_cov_1.331797_g39348_i0	PRJEB83711	39614	290	1.331797	3.8622113	Aliinostoc	2035978	Bacteria	Bacteria	246	1.1499999999999999e-60	NTclustered	gi\|1785994290\|gb\|MK995249.1\|	2499873	g39348	i0	84.739	18.4068965517241	249	34	85	4	35	281	566	320	Aliinostoc catenatum SA24 elongation factor Tu-A (tufA) gene, partial cds	blastn	5338	246	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Aliinostoc	Aliinostoc catenatum
20124891	20124891	PRJEB83711_P_NODE_13116_length_492_cov_2.761337_g12852_i0	PRJEB83711	13116	492	2.761337	13.58577804	Chroococcidiopsis	54298	Bacteria	Bacteria	904	0	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g12852	i0	99.797	202.193089430894	492	1	100	0	1	492	510	19	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	99479	904	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
20544807	20544807	PRJEB83711_P_NODE_31597_length_320_cov_0.829960_g31331_i0	PRJEB83711	31597	320	0.82996	2.655872	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	231	3.5899999999999997e-56	NTclustered	gi\|2245450223\|gb\|CP083762.1\|	155894	g31331	i0	91.228	1.4	171	14	54	1	1	171	103235	103066	Chroococcidiopsis sp. CCMEE 29 plasmid unnamed, complete sequence	blastn	448	231	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
23096764	23096764	PRJEB83711_P_NODE_72359_length_245_cov_0.906977_g72093_i0	PRJEB83711	72359	245	0.906977	2.22209365	Nostoc sp. C110	3349876	Bacteria	Bacteria	215	2.67e-51	NTclustered	gi\|2831011360\|gb\|CP171148.1\|	3349876	g72093	i0	83.7	10.5714285714286	227	37	93	0	11	237	5169376	5169602	Nostoc sp. C110 chromosome, complete genome	blastn	2590	215	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. C110

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