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

10 rows where analysis = "blastn", bioproject = "PRJNA782551" 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
763724	763724	PRJNA782551_P_NODE_23681_length_242_cov_0.911243_g23559_i0	PRJNA782551	23681	242	0.911243	2.20520806	Nostoc sp. ATCC 53789	76335	Bacteria	Bacteria	230	9.38e-56	NTclustered	gi\|1796909370\|gb\|CP046703.1\|	76335	g23559	i0	85.268	1.85123966942149	224	31	92	2	20	242	6852831	6853053	Nostoc sp. ATCC 53789 chromosome, complete genome	blastn	448	230	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. ATCC 53789
1212443	1212443	PRJNA782551_P_NODE_18621_length_248_cov_0.880000_g18499_i0	PRJNA782551	18621	248	0.88	2.1824	Chroococcidiopsis	54298	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g18499	i0	99.194	2	248	2	100	0	1	248	5211673	5211920	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	496	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
2039596	2039596	PRJNA782551_P_NODE_17242_length_250_cov_0.870056_g17120_i0	PRJNA782551	17242	250	0.870056	2.17514	Chondrocystis sp. NIES-4102	2005460	Bacteria	Bacteria	379	9.139999999999998e-101	NTclustered	gi\|1210223977\|dbj\|AP018281.1\|	2005460	g17120	i0	94.048	136.496	252	11	100	3	1	250	1935375	1935126	Chondrocystis sp. NIES-4102 DNA, complete genome	blastn	34124	379	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chondrocystis	Chondrocystis sp. NIES-4102
8416843	8416843	PRJNA782551_P_NODE_487_length_1271_cov_9.974958_g409_i0	PRJNA782551	487	1271	9.974958	126.78171618	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	2218	0	NTclustered	gi\|225696219\|gb\|FJ805886.1\|	259957	g409	i0	98.19	103.246262785209	1271	21	99	2	2	1271	2847	1578	Uncultured Chroococcidiopsis sp. clone NA4_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	131226	2218	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12243283	12243283	PRJNA782551_P_NODE_20290_length_246_cov_0.890173_g20168_i0	PRJNA782551	20290	246	0.890173	2.18982558	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g20168	i0	100	14.3373983739837	246	0	100	0	1	246	3296380	3296625	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	3527	455	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
13517529	13517529	PRJNA782551_P_NODE_23771_length_242_cov_0.911243_g23649_i0	PRJNA782551	23771	242	0.911243	2.20520806	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	233	7.25e-57	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g23649	i0	84.848	17.1322314049587	231	35	95	0	7	237	4087726	4087956	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	4146	233	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
16515406	16515406	PRJNA782551_P_NODE_16513_length_250_cov_1.271186_g16391_i0	PRJNA782551	16513	250	1.271186	3.177965	Chroococcidiopsis	54298	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g16391	i0	99.6	2	250	1	100	0	1	250	3514959	3514710	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	500	457	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
18615189	18615189	PRJNA782551_P_NODE_13135_length_270_cov_1.172589_g13013_i0	PRJNA782551	13135	270	1.172589	3.1659903	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	350	7.84e-92	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g13013	i0	90	117.088888888889	270	27	100	0	1	270	3316	3047	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	31614	350	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19890571	19890571	PRJNA782551_P_NODE_23856_length_242_cov_0.911243_g23734_i0	PRJNA782551	23856	242	0.911243	2.20520806	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g23734	i0	99.587	2	242	1	100	0	1	242	5344977	5344736	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	484	442	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
21166257	21166257	PRJNA782551_P_NODE_18757_length_248_cov_0.880000_g18635_i0	PRJNA782551	18757	248	0.88	2.1824	Tolypothrix tenuis	457083	Bacteria	Bacteria	156	1.66e-33	NTclustered	gi\|1210177014\|dbj\|AP018248.1\|	231146	g18635	i0	88.976	19.2217741935484	127	13	51	1	2	128	1280588	1280463	Tolypothrix tenuis PCC 7101 DNA, nearly complete genome	blastn	4767	156	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix tenuis

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