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

5 rows where analysis = "blastn", bioproject = "PRJNA454503" 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
8095422	8095422	PRJNA454503_P_NODE_32147_length_236_cov_2.611429_g31818_i0	PRJNA454503	32147	236	2.6114289999999998	6.16297244	Albertania skiophila	2109500	Bacteria	Bacteria	342	1.12e-89	NTclustered	gi\|1356054890\|gb\|MH030274.1\|	2109501	g31818	i0	92.797	207.016949152542	236	17	100	0	1	236	2187	1952	Albertania skiophila str. SA373 Zammit 2014 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	48856	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Albertania	Albertania skiophila
10646877	10646877	PRJNA454503_P_NODE_90549_length_172_cov_4.513514_g90220_i0	PRJNA454503	90549	172	4.513514	7.76324408	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	292	7.81e-75	NTclustered	gi\|225696240\|gb\|FJ805907.1\|	259957	g90220	i0	97.647	162.273255813953	170	4	99	0	1	170	3227	3396	Uncultured Chroococcidiopsis sp. clone NA3_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27911	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
17019275	17019275	PRJNA454503_P_NODE_10394_length_347_cov_4.146853_g10065_i0	PRJNA454503	10394	347	4.146853	14.38957991	Oculatella lusitanica	2928764	Bacteria	Bacteria	479	1.2699999999999996e-130	NTclustered	gi\|1793889078\|gb\|MN061918.1\|	2692086	g10065	i0	91.667	157.518731988473	348	25	100	2	1	347	3522	3178	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	54659	479	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella lusitanica
17671316	17671316	PRJNA454503_P_NODE_41814_length_225_cov_0.865854_g41485_i0	PRJNA454503	41814	225	0.865854	1.9481715	root	1	Root_unresolved	Root_unresolved	416	6.159999999999998e-112	NTclustered	gi\|326205832\|gb\|HQ827452.1\|	1211	g41485	i0	100	99.6444444444444	225	0	100	0	1	225	386	162	Uncultured cyanobacterium clone ciam16_P2R2F11 16S ribosomal RNA gene, partial sequence	blastn	22420	416	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
22770934	22770934	PRJNA454503_P_NODE_89398_length_191_cov_2.223077_g89069_i0	PRJNA454503	89398	191	2.223077	4.24607707	Oculatella	1240886	Bacteria	Bacteria	294	2.47e-75	NTclustered	gi\|1300933890\|gb\|MG652620.1\|	1963209	g89069	i0	94.709	146.099476439791	189	10	99	0	2	190	2223	2411	Oculatella ucrainica KZ-5-4-1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27905	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella ucrainica

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