metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA339266" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA339266" and tax_phylum = "Cyanobacteriota"

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
11869926	11869926	PRJNA339266_P_NODE_4490_length_188_cov_5.357616_g4460_i0	PRJNA339266	4490	188	5.357616	10.07231808	Anabaenopsis elenkinii	156213	Bacteria	Bacteria	69.4	1.6e-7	NTclustered	gi\|1928838257\|gb\|CP063311.1\|	2779889	g4460	i0	82.895	0.404255319148936	76	13	40	0	22	97	2716489	2716414	Anabaenopsis elenkinii CCIBt3563 chromosome	blastn	76	69.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Anabaenopsis	Anabaenopsis elenkinii
12548364	12548364	PRJNA339266_P_NODE_7230_length_163_cov_2.277778_g7200_i0	PRJNA339266	7230	163	2.277778	3.71277814	Nodularia	159191	Bacteria	Bacteria	143	7.839999999999999e-30	NTclustered	gi\|604876398\|gb\|CP007203.2\|	313624	g7200	i0	84	8.52147239263804	150	22	91	2	7	155	298675	298823	Nodularia spumigena CCY9414 genome	blastn	1389	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
13144894	13144894	PRJNA339266_P_NODE_5111_length_185_cov_2.128378_g5081_i0	PRJNA339266	5111	185	2.128378	3.9374993	Nostoc sp. UHCC 0302	3134896	Bacteria	Bacteria	95.3	2.59e-15	NTclustered	gi\|2717038756\|gb\|CP151099.1\|	3134896	g5081	i0	89.333	0.405405405405405	75	8	41	0	1	75	672669	672743	Nostoc sp. UHCC 0302 chromosome, complete genome	blastn	75	95.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0302
13145151	13145151	PRJNA339266_S_NODE_4091_length_224_cov_19.037433_g4080_i0	PRJNA339266	4091	224	19.037433	42.64384992	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	329	8.21e-86	NTclustered	gi\|225696185\|gb\|FJ805852.1\|	259957	g4080	i0	95.192	164.598214285714	208	10	93	0	15	222	1636	1843	Uncultured Chroococcidiopsis sp. clone AR1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36870	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20792872	20792872	PRJNA339266_S_NODE_16497_length_157_cov_58.066667_g16486_i0	PRJNA339266	16497	157	58.066667	91.16466719	Planktothricoides raciborskii	132608	Bacteria	Bacteria	222	9.329999999999999e-54	NTclustered	gi\|2754673971\|gb\|CP159837.1\|	2792601	g16486	i0	95.683	133.891719745223	139	5	89	1	17	155	510154	510291	Planktothricoides raciborskii GIHE-MW2 chromosome, complete genome	blastn	21021	222	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Planktothricoides	Planktothricoides raciborskii
20793016	20793016	PRJNA339266_S_NODE_57_length_673_cov_5.224843_g51_i0	PRJNA339266	57	673	5.224843	35.163193390000004	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1053	0	NTclustered	gi\|225696224\|gb\|FJ805891.1\|	259957	g51	i0	95.195	103.208023774146	666	32	99	0	3	668	2389	3054	Uncultured Chroococcidiopsis sp. clone NA2_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	69459	1053	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
21471568	21471568	PRJNA339266_P_NODE_7337_length_162_cov_1.240000_g7307_i0	PRJNA339266	7337	162	1.24	2.0088	Pleurocapsa	44474	Bacteria	Bacteria	291	2.62e-74	NTclustered	gi\|443428701\|gb\|JX127184.1\|	1211	g7307	i0	99.375	98.7345679012346	160	1	99	0	1	160	446	605	Uncultured cyanobacterium clone 3GB20_K48 16S ribosomal RNA gene, partial sequence	blastn	15995	291	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
22067984	22067984	PRJNA339266_S_NODE_2298_length_260_cov_2.986547_g2287_i0	PRJNA339266	2298	260	2.986547	7.7650222	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	374	4.45e-99	NTclustered	gi\|225696175\|gb\|FJ805842.1\|	259957	g2287	i0	92.664	111.35	259	19	99	0	1	259	2013	1755	Uncultured Chroococcidiopsis sp. clone AU1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	28951	374	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
23343246	23343246	PRJNA339266_P_NODE_6199_length_176_cov_8.748201_g6169_i0	PRJNA339266	6199	176	8.748201	15.39683376	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	89.8	1.13e-13	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g6169	i0	94.737	3.92045454545455	57	3	32	0	46	102	633128	633184	Calothrix sp. PCC 7716 DNA, complete genome	blastn	690	89.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
23343470	23343470	PRJNA339266_S_NODE_219_length_462_cov_51.011765_g208_i0	PRJNA339266	219	462	51.011765	235.6743543	Aliterella chasmolithica	2739056	Bacteria	Bacteria	630	4.5299999999999985e-176	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g208	i0	91.503	121.606060606061	459	37	99	2	1	458	2424	1967	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	56182	630	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica

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