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

5 rows where analysis = "blastn", bioproject = "PRJNA450632" 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
10643095	10643095	PRJNA450632_P_NODE_15329_length_201_cov_2.692771_g15150_i0	PRJNA450632	15329	201	2.692771	5.41246971	Gloeocapsa sp. PCC 7428	1173026	Bacteria	Bacteria	209	9.8e-50	NTclustered	gi\|485099145\|ref\|NR_102540.1\|	1173026	g15150	i0	85.93	171.81592039801	199	24	98	2	1	197	534	730	Gloeocapsa sp. PCC 7428 strain PCC 7428 23S ribosomal RNA, complete sequence	blastn	34535	209	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
15741898	15741898	PRJNA450632_P_NODE_16213_length_194_cov_1.893082_g16034_i0	PRJNA450632	16213	194	1.893082	3.67257908	Oculatella crustae-formantes	2739055	Bacteria	Bacteria	254	4.28e-63	NTclustered	gi\|1713066357\|gb\|MN243147.1\|	2599945	g16034	i0	91.351	200.572164948454	185	16	95	0	2	186	2154	1970	Oculatella crustae-formantes PJ S28 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	38911	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella crustae-formantes
22115676	22115676	PRJNA450632_P_NODE_11758_length_241_cov_2.165049_g11579_i0	PRJNA450632	11758	241	2.165049	5.21776809	cyanobacterium endosymbiont of Epithemia clementina EcSB	3034674	Bacteria	Bacteria	326	1.16e-84	NTclustered	gi\|2499392380\|gb\|CP123991.1\|	3034674	g11579	i0	91.286	165.730290456432	241	18	100	2	1	241	1610306	1610069	Cyanobacterium endosymbiont of Epithemia clementina EcSB isolate Gazos Creek chromosome, complete genome	blastn	39941	326	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium endosymbiont of Epithemia clementina EcSB
23391531	23391531	PRJNA450632_P_NODE_17659_length_183_cov_2.081081_g17480_i0	PRJNA450632	17659	183	2.081081	3.80837823	uncultured cyanobacterium	1211	Bacteria	Bacteria	272	1.1e-68	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g17480	i0	99.333	120.300546448087	150	1	82	0	1	150	3304	3453	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	22015	272	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
24665574	24665574	PRJNA450632_P_NODE_19400_length_172_cov_1.408759_g19221_i0	PRJNA450632	19400	172	1.408759	2.42306548	uncultured cyanobacterium	1211	Bacteria	Bacteria	268	1.32e-67	NTclustered	gi\|393704077\|gb\|JQ919741.1\|	1211	g19221	i0	94.767	98.5639534883721	172	9	100	0	1	172	148	319	Uncultured cyanobacterium clone GC0AA2ZA02PP1 16S ribosomal RNA gene, partial sequence	blastn	16953	268	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);;