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

5 rows where analysis = "blastn", bioproject = "PRJNA909412" 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
17468917	17468917	PRJNA909412_P_NODE_1354_length_474_cov_3.135632_g1215_i0	PRJNA909412	1354	474	3.135632	14.86289568	Calothrix sp. PCC 6303	1170562	Bacteria	Bacteria	617	3.63e-172	NTclustered	gi\|485099151\|ref\|NR_102546.1\|	1170562	g1215	i0	90.208	162.721518987342	480	38	100	6	1	474	1744	1268	Calothrix sp. PCC 6303 strain PCC 6303 23S ribosomal RNA, complete sequence	blastn	77130	617	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
17469009	17469009	PRJNA909412_P_NODE_894_length_591_cov_5.266304_g773_i0	PRJNA909412	894	591	5.266304	31.12385664	Macrochaete lichenoides	1844961	Bacteria	Bacteria	1014	0	NTclustered	gi\|1026355709\|gb\|KU559618.1\|	1521517	g773	i0	97.635	285.622673434856	592	13	100	1	1	591	2128	1537	Macrochaete lichenoides SAG 32.92 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	168803	1014	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Macrochaete	Macrochaete lichenoides
21292623	21292623	PRJNA909412_P_NODE_7837_length_189_cov_2.386667_g7696_i0	PRJNA909412	7837	189	2.386667	4.51080063	Chamaesiphon minutus	1173032	Bacteria	Bacteria	139	1.21e-28	NTclustered	gi\|428015215\|gb\|CP003600.1\|	1173020	g7696	i0	88.696	71.0740740740741	115	12	61	1	2	116	4001242	4001129	Chamaesiphon minutus PCC 6605, complete genome	blastn	13433	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
25116732	25116732	PRJNA909412_P_NODE_1860_length_399_cov_3.094444_g1720_i0	PRJNA909412	1860	399	3.094444	12.34683156	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	544	5.17e-150	NTclustered	gi\|225696248\|gb\|FJ805915.1\|	259957	g1720	i0	91.272	201.238095238095	401	31	99	4	2	399	2622	2223	Uncultured Chroococcidiopsis sp. clone A1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	80294	544	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25475816	25475816	PRJNA909412_P_NODE_7540_length_192_cov_3.849673_g7399_i0	PRJNA909412	7540	192	3.849673	7.39137216	root	1	Root_unresolved	Root_unresolved	355	1.13e-93	NTclustered	gi\|588284496\|gb\|KF951520.1\|	1211	g7399	i0	100	100.75	192	0	100	0	1	192	204	13	Uncultured cyanobacterium clone PS41 16S ribosomal RNA gene, partial sequence	blastn	19344	355	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium

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