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

10 rows where analysis = "blastn", bioproject = "PRJNA846086" 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
832940	832940	PRJNA846086_P_NODE_761_length_422_cov_3.000000_g695_i0	PRJNA846086	761	422	3	12.66	cyanobacterium NIES-36	2510787	Bacteria	Bacteria	525	1.9899999999999995e-144	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g695	i0	89.125	208.869668246445	423	44	100	2	1	422	471	50	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	88143	525	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
2108289	2108289	PRJNA846086_P_NODE_1102_length_351_cov_1.205036_g1036_i0	PRJNA846086	1102	351	1.205036	4.22967636	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	610	4.359999999999999e-170	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g1036	i0	98.011	272.185185185185	352	5	100	2	1	351	1858584	1858934	Calothrix sp. PCC 7716 DNA, complete genome	blastn	95537	610	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
2108364	2108364	PRJNA846086_P_NODE_5782_length_227_cov_2.720779_g5716_i0	PRJNA846086	5782	227	2.720779	6.17616833	Plectolyngbya terrestris	3016457	Bacteria	Bacteria	364	2.289999999999999e-96	NTclustered	gi\|2106138546\|gb\|OK382086.1\|	2880694	g5716	i0	95.595	182.713656387665	227	10	100	0	1	227	2279	2053	Plectolyngbya terrestris FBCC-A1479 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	41476	364	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Plectolyngbya	Plectolyngbya terrestris
3383667	3383667	PRJNA846086_P_NODE_363_length_626_cov_2.933092_g299_i0	PRJNA846086	363	626	2.933092	18.36115592	Oculatella lusitanica	2928764	Bacteria	Bacteria	937	0	NTclustered	gi\|1793889078\|gb\|MN061918.1\|	2692086	g299	i0	93.79	202.605431309904	628	32	100	7	1	626	3292	2670	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	126831	937	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella lusitanica
3383691	3383691	PRJNA846086_P_NODE_4983_length_243_cov_0.905882_g4917_i0	PRJNA846086	4983	243	0.905882	2.20129326	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	405	1.46e-108	NTclustered	gi\|2245124533\|gb\|CP097480.1\|	2653189	g4917	i0	96.708	2	243	8	100	0	1	243	3706680	3706922	Chroococcidiopsis sp. CCNUC1 chromosome, complete genome	blastn	486	405	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
7210995	7210995	PRJNA846086_P_NODE_3866_length_248_cov_0.880000_g3800_i0	PRJNA846086	3866	248	0.88	2.1824	Cyanobacterium sp. uoEpiScrs1	2976343	Bacteria	Bacteria	148	2.7799999999999998e-31	NTclustered	gi\|2362845870\|emb\|OX373462.1\|	2976343	g3800	i0	77.778	161.907258064516	243	52	98	2	6	248	812624	812864	Cyanobacterium sp. uoEpiScrs1 isolate 25016 genome assembly, chromosome: 1	blastn	40153	148	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Cyanobacterium	Cyanobacterium sp. uoEpiScrs1
9760936	9760936	PRJNA846086_P_NODE_468_length_551_cov_1.209205_g402_i0	PRJNA846086	468	551	1.209205	6.66271955	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	870	0	NTclustered	gi\|225696224\|gb\|FJ805891.1\|	259957	g402	i0	95.281	107.208711433757	551	23	100	2	1	551	2857	2310	Uncultured Chroococcidiopsis sp. clone NA2_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	59072	870	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
18684183	18684183	PRJNA846086_P_NODE_995_length_368_cov_1.484746_g929_i0	PRJNA846086	995	368	1.484746	5.46386528	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	625	1.6399999999999998e-174	NTclustered	gi\|453199516\|gb\|JQ997496.1\|	259957	g929	i0	97.283	148.415760869565	368	10	100	0	1	368	124	491	Uncultured Chroococcidiopsis sp. clone GKJWQY101ANW47 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	54617	625	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19959245	19959245	PRJNA846086_P_NODE_1376_length_321_cov_1.641129_g1310_i0	PRJNA846086	1376	321	1.641129	5.26802409	Aliterella chasmolithica	2739056	Bacteria	Bacteria	422	1.99e-113	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g1310	i0	90.402	121.423676012461	323	27	100	4	1	321	2354	2034	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	38977	422	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
19959247	19959247	PRJNA846086_P_NODE_1516_length_308_cov_2.336170_g1450_i0	PRJNA846086	1516	308	2.33617	7.1954036	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	529	1.0899999999999996e-145	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g1450	i0	97.727	239.87987012987	308	6	100	1	1	308	1857540	1857846	Calothrix sp. PCC 7716 DNA, complete genome	blastn	73883	529	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716

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