metadata: contig_metadata: 10 rows where bioproject = "PRJEB7614" and tax_clade = "Cyanobacteriota/Melainabacteria group"

10 rows where bioproject = "PRJEB7614" 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
6516860	6516860	PRJEB7614_P_NODE_3166_length_222_cov_4.528497_g3099_i0	PRJEB7614	3166	222	4.528497	10.05326334	Kamptonema laetevirens	126586	Bacteria	Bacteria	202	1.85e-47	NTclustered	gi\|1566846293\|dbj\|LC455673.1\|	2507915	g3099	i0	95.276	68.536036036036	127	6	57	0	96	222	127	1	Kamptonema laetevirens NIES-31 gene for 23S ribosomal RNA, partial sequence	blastn	15215	202	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Kamptonema	Kamptonema laetevirens
14167068	14167068	PRJEB7614_P_NODE_3212_length_221_cov_3.052083_g3145_i0	PRJEB7614	3212	221	3.052083	6.74510343	uncultured cyanobacterium	1211	Bacteria	Bacteria	95.3	3.21e-15	NTclustered	gi\|2874253781\|emb\|OY969765.1\|	1211	g3145	i0	90.411	3.72398190045249	73	6	33	1	142	214	2239032	2239103	MAG: uncultured cyanobacterium isolate MFD03250.bin.1.145 genome assembly, chromosome: 1	blastn	823	95.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
25661651	25661651	PRJEB7614b_S_NODE_1114_length_209_cov_2.356322_g1112_i0	PRJEB7614	1114	209	2.356322	4.92471298	Aliterella chasmolithica PJ S15	2599943	Bacteria	Bacteria	222	1.32e-53	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g1112	i0	88.235	147.105263157895	187	20	89	2	1	186	2252	2067	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	30745	222	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
25661671	25661671	PRJEB7614e_S_NODE_1770_length_209_cov_3.936782_g1762_i0	PRJEB7614	1770	209	3.936782	8.22787438	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	348	2.09e-91	NTclustered	gi\|225696182\|gb\|FJ805849.1\|	259957	g1762	i0	96.682	113.239234449761	211	4	100	3	1	209	1776	1985	Uncultured Chroococcidiopsis sp. clone AU1_8 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	23667	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25797750	25797750	PRJEB7614e_S_NODE_1115_length_230_cov_4489.517949_g1107_i0	PRJEB7614	1115	230	4489.517949	10325.8912827	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	351	1.81e-92	NTclustered	gi\|225696182\|gb\|FJ805849.1\|	259957	g1107	i0	98.98	115.465217391304	196	2	85	0	35	230	2664	2859	Uncultured Chroococcidiopsis sp. clone AU1_8 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	26557	351	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25933925	25933925	PRJEB7614a_S_NODE_15332_length_413_cov_15.571429_g14188_i0	PRJEB7614	15332	413	15.571429	64.31000177	Aliterella chasmolithica PJ S15	2599943	Bacteria	Bacteria	562	1.48e-155	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g14188	i0	91.304	116.351089588378	414	32	99	4	1	412	1964	2375	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	48053	562	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
26069920	26069920	PRJEB7614a_S_NODE_128085_length_160_cov_1.272000_g126881_i0	PRJEB7614	128085	160	1.272	2.0352	Oscillatoria acuminata PCC 63	118323	Bacteria	Bacteria	250	4.38e-62	NTclustered	gi\|427998918\|gb\|CP003607.1\|	56110	g126881	i0	95.513	111.4	156	7	98	0	5	160	2199364	2199519	Oscillatoria acuminata PCC 6304, complete genome	blastn	17824	250	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria acuminata
26206258	26206258	PRJEB7614e_S_NODE_774_length_260_cov_15823.288889_g766_i0	PRJEB7614	774	260	15823.288889	41140.5511114	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	361	3.469999999999999e-95	NTclustered	gi\|225696217\|gb\|FJ805884.1\|	259957	g766	i0	96.364	114.669230769231	220	7	84	1	6	224	1782	1563	Uncultured Chroococcidiopsis sp. clone NA4_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	29814	361	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
26296607	26296607	PRJEB7614d_S_NODE_566_length_266_cov_1.701299_g528_i0	PRJEB7614	566	266	1.701299	4.52545534	Chroococcidiopsis	54298	Bacteria	Bacteria	486	5.629999999999999e-133	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g528	i0	99.624	118.676691729323	266	1	100	0	1	266	451	186	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	31568	486	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
26342069	26342069	PRJEB7614d_S_NODE_879_length_231_cov_10.285714_g841_i0	PRJEB7614	879	231	10.285714	23.75999934	Aliterella chasmolithica PJ S15	2599943	Bacteria	Bacteria	379	8.339999999999999e-101	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g841	i0	99.519	102.991341991342	208	1	90	0	1	208	2174	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	23791	379	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);;