metadata: contig_metadata: 11 rows where bioproject = "PRJNA382558" and tax_clade = "Cyanobacteriota/Melainabacteria group"

11 rows where bioproject = "PRJNA382558" 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
2351088	2351088	PRJNA382558_S_NODE_15762_length_151_cov_3.622807_g15758_i0	PRJNA382558	15762	151	3.622807	5.47043857	Cyanophyceae	3028117	Bacteria	Bacteria	220	3.19e-53	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g15758	i0	93.333	133.88079470198701	150	9	99	1	2	151	795199	795347	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	20216	220	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
3626441	3626441	PRJNA382558_S_NODE_2503_length_253_cov_10.703704_g2499_i0	PRJNA382558	2503	253	10.703704	27.08037112	Cyanophyceae	3028117	Bacteria	Bacteria	329	9.469999999999998e-86	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g2499	i0	90.438	272.490118577075	251	23	100	1	1	250	792826	793076	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	68940	329	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
3626459	3626459	PRJNA382558_S_NODE_7623_length_187_cov_6.526667_g7619_i0	PRJNA382558	7623	187	6.526667	12.20486729	Cyanophyceae	3028117	Bacteria	Bacteria	252	1.47e-62	NTclustered	gi\|984535223\|dbj\|AP017367.1\|	1080068	g7619	i0	91.053	187.935828877005	190	11	99	6	1	185	1873435	1873247	Leptolyngbya sp. O-77 DNA, complete genome	blastn	35144	252	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. O-77
8058079	8058079	PRJNA382558_S_NODE_12107_length_163_cov_5.547619_g12103_i0	PRJNA382558	12107	163	5.547619	9.04261897	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	257	2.68e-64	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g12103	i0	95.122	156.503067484663	164	6	100	2	1	163	1824	1662	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	25510	257	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
14433550	14433550	PRJNA382558_S_NODE_11852_length_164_cov_6.204724_g11848_i0	PRJNA382558	11852	164	6.204724	10.17574736	Brasilonema sennae	1397703	Bacteria	Bacteria	279	5.77e-71	NTclustered	gi\|1702166658\|gb\|CP030118.1\|	415709	g11848	i0	97.546	234.34756097561	163	4	99	0	2	164	1168555	1168717	Brasilonema sennae CENA114 chromosome	blastn	38433	279	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Brasilonema	Brasilonema sennae
17653307	17653307	PRJNA382558_S_NODE_7314_length_189_cov_10.256579_g7310_i0	PRJNA382558	7314	189	10.256579	19.38493431	Nostocales	1161	Bacteria	Bacteria	305	1.13e-78	NTclustered	gi\|46409894\|gb\|AY584519.1\|	63737	g7310	i0	95.767	209.417989417989	189	8	100	0	1	189	732	544	Nostoc punctiforme PCC 73102 23S ribosomal RNA gene, partial sequence	blastn	39580	307	0.993485342019544	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
19530752	19530752	PRJNA382558_S_NODE_3036_length_242_cov_6.429268_g3032_i0	PRJNA382558	3036	242	6.429268	15.55882856	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	357	4.13e-94	NTclustered	gi\|225696175\|gb\|FJ805842.1\|	259957	g3032	i0	93.416	193.045454545455	243	12	99	4	1	240	2046	2287	Uncultured Chroococcidiopsis sp. clone AU1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	46717	357	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22081304	22081304	PRJNA382558_S_NODE_13838_length_156_cov_10.739496_g13834_i0	PRJNA382558	13838	156	10.739496	16.75361376	Gloeocapsa sp. 20201027-1	2802214	Bacteria	Bacteria	233	4.2799999999999995e-57	NTclustered	gi\|1953559107\|gb\|MW449597.1\|	2802214	g13834	i0	94.737	151.032051282051	152	5	97	1	1	152	293	441	Gloeocapsa sp. 20201027-1 23S ribosomal RNA gene, partial sequence	blastn	23561	233	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. 20201027-1
24631313	24631313	PRJNA382558_S_NODE_4100_length_223_cov_6.295699_g4096_i0	PRJNA382558	4100	223	6.295699	14.03940877	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	261	3.02e-65	NTclustered	gi\|225696259\|gb\|FJ805926.1\|	259957	g4096	i0	88.732	121.345291479821	213	24	96	0	11	223	3244	3456	Uncultured Chroococcidiopsis sp. clone AS3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27060	261	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
32256859	32256859	PRJNA382558_S_NODE_12118_length_163_cov_5.325397_g12114_i0	PRJNA382558	12118	163	5.325397	8.68039711	Nostoc sp. CMAA16	1180	Bacteria	Bacteria	106	6.7599999999999985e-28	NR	WP_236145141.1	2055159	g12114	i0	94.4	0.993865030674847	54	3	99.4	0	2	163	18	71	WP_236145141.1 VOC family protein [Nostoc sp. CMAA1605]	diamond	162	106	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CMAA1605
32478194	32478194	PRJNA382558_S_NODE_2919_length_244_cov_7.913043_g2915_i0	PRJNA382558	2919	244	7.913043	19.30782492	Nostoc sp. CMAA16	1180	Bacteria	Bacteria	113	5.25e-30	NR	WP_236145141.1	2055159	g2915	i0	88.1	1.45081967213115	59	7	72.5	0	242	66	80	138	WP_236145141.1 VOC family protein [Nostoc sp. CMAA1605]	diamond	354	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CMAA1605

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