metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA681822" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA681822" and tax_phylum = "Cyanobacteriota"

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
4484260	4484260	PRJNA681822_P_NODE_479824_length_241_cov_0.916667_g478334_i0	PRJNA681822	479824	241	0.916667	2.20916747	Egbenema sp. FJBBOT/2019	3398834	Bacteria	Bacteria	226	1.2099999999999997e-54	NTclustered	gi\|2917372002\|gb\|CP182236.1\|	3398834	g478334	i0	87.755	3.25726141078838	196	21	80	3	4	196	3630867	3630672	Egbenema sp. FJBBOT/2019 chromosome, complete genome	blastn	785	226	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Egbenema	Egbenema sp. FJBBOT/2019
4999391	4999391	PRJNA681822_P_NODE_468004_length_242_cov_1.562130_g466514_i0	PRJNA681822	468004	242	1.56213	3.7803546	Chroococcidiopsis	54298	Bacteria	Bacteria	337	5.37e-88	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g466514	i0	97.938	5.38429752066116	194	4	83	0	47	240	4764403	4764210	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	1303	337	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
5757935	5757935	PRJNA681822_P_NODE_32165_length_664_cov_2.023689_g30773_i0	PRJNA681822	32165	664	2.023689	13.43729496	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	1003	0	NTclustered	gi\|225696255\|gb\|FJ805922.1\|	259957	g30773	i0	93.985	114.861445783133	665	37	100	3	1	664	2226	2888	Uncultured Chroococcidiopsis sp. clone SA2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	76268	1003	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10855647	10855647	PRJNA681822_P_NODE_118749_length_369_cov_1.820946_g117262_i0	PRJNA681822	118749	369	1.820946	6.71929074	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	512	1.34e-140	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g117262	i0	92.265	264.189701897019	362	27	98	1	5	365	4829602	4829241	Leptolyngbya sp. 7M chromosome	blastn	97486	512	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
10858561	10858561	PRJNA681822_P_NODE_347089_length_261_cov_1.638298_g345600_i0	PRJNA681822	347089	261	1.638298	4.27595778	Tolypothrix tenuis	457083	Bacteria	Bacteria	150	8.2e-32	NTclustered	gi\|1210177014\|dbj\|AP018248.1\|	231146	g345600	i0	81.347	2.94252873563218	193	29	73	7	1	190	3351778	3351590	Tolypothrix tenuis PCC 7101 DNA, nearly complete genome	blastn	768	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix tenuis
12135662	12135662	PRJNA681822_P_NODE_475950_length_241_cov_1.833333_g474460_i0	PRJNA681822	475950	241	1.833333	4.41833253	Nostoc sp. ATCC 29106	82766	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|4033739\|gb\|AF056037.1\|AF056037	82766	g474460	i0	100	9.02489626556017	241	0	100	0	1	241	1140	900	Nostoc ATCC29106 modification methylase M.NspHI (nspHIM) and NspHI restriction endonuclease (nspHIR) genes, complete cds	blastn	2175	446	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. ATCC 29106
13409167	13409167	PRJNA681822_P_NODE_400231_length_249_cov_1.750000_g398742_i0	PRJNA681822	400231	249	1.75	4.3575	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	346	9.229999999999999e-91	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g398742	i0	91.968	195.987951807229	249	17	99	3	2	249	1912	1666	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	48801	346	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13410134	13410134	PRJNA681822_P_NODE_473671_length_242_cov_0.911243_g472181_i0	PRJNA681822	473671	242	0.911243	2.20520806	uncultured cyanobacterium	1211	Bacteria	Bacteria	420	5.19e-113	NTclustered	gi\|386685926\|gb\|JQ612142.1\|	1211	g472181	i0	97.934	99.8719008264463	242	5	100	0	1	242	244	3	Uncultured cyanobacterium clone MSmat.3.13 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	24169	420	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
14683785	14683785	PRJNA681822_P_NODE_355172_length_259_cov_1.403226_g353683_i0	PRJNA681822	355172	259	1.403226	3.63435534	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	457	4.279999999999999e-124	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g353683	i0	98.456	4.92277992277992	259	4	100	0	1	259	1664043	1664301	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	1275	457	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
15954764	15954764	PRJNA681822_P_NODE_146173_length_344_cov_2.383764_g144685_i0	PRJNA681822	146173	344	2.383764	8.20014816	Nostoc sp. ATCC 29106	82766	Bacteria	Bacteria	636	7.059999999999998e-178	NTclustered	gi\|4033739\|gb\|AF056037.1\|AF056037	82766	g144685	i0	100	7.9156976744186	344	0	100	0	1	344	732	389	Nostoc ATCC29106 modification methylase M.NspHI (nspHIM) and NspHI restriction endonuclease (nspHIR) genes, complete cds	blastn	2723	636	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. ATCC 29106
15956178	15956178	PRJNA681822_P_NODE_242293_length_288_cov_1.493023_g240804_i0	PRJNA681822	242293	288	1.493023	4.29990624	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	342	1.4099999999999996e-89	NTclustered	gi\|225696253\|gb\|FJ805920.1\|	259957	g240804	i0	88.502	113.107638888889	287	28	99	5	1	285	2907	3190	Uncultured Chroococcidiopsis sp. clone A1_6 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	32575	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15958971	15958971	PRJNA681822_P_NODE_475193_length_242_cov_0.857988_g473703_i0	PRJNA681822	475193	242	0.857988	2.07633096	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	318	1.95e-82	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g473703	i0	90.574	1.32231404958678	244	17	99	3	2	242	4948193	4947953	Allocoleopsis franciscana PCC 7113, complete genome	blastn	320	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
17233749	17233749	PRJNA681822_P_NODE_438434_length_245_cov_1.790698_g436945_i0	PRJNA681822	438434	245	1.790698	4.3872101	Microcoleus sp. HI-ES	2970922	Bacteria	Bacteria	436	5.229999999999999e-118	NTclustered	gi\|2283787845\|gb\|OP179626.1\|	2970922	g436945	i0	98.776	151.126530612245	245	3	100	0	1	245	287	43	Microcoleus sp. HI-ES 23S ribosomal RNA gene, partial sequence	blastn	37026	436	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. HI-ES
18505808	18505808	PRJNA681822_P_NODE_260775_length_284_cov_1.270142_g259286_i0	PRJNA681822	260775	284	1.270142	3.60720328	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	409	1.3499999999999998e-109	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g259286	i0	97.119	2.95422535211268	243	6	86	1	41	283	1866336	1866577	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	839	409	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
22332257	22332257	PRJNA681822_P_NODE_366958_length_255_cov_2.269231_g365469_i0	PRJNA681822	366958	255	2.269231	5.78653905	Richelia sinica	1357545	Bacteria	Bacteria	226	1.2899999999999997e-54	NTclustered	gi\|2059364121\|gb\|CP021056.1\|	1357546	g365469	i0	82.869	1.94901960784314	251	43	98	0	1	251	4114471	4114721	Richelia sinica FACHB-800 strain FACHB 800 chromosome, complete genome	blastn	497	226	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia sinica
24877518	24877518	PRJNA681822_P_NODE_106340_length_383_cov_2.225806_g104855_i0	PRJNA681822	106340	383	2.225806	8.52483698	cyanobacterium NIES-36	2510787	Bacteria	Bacteria	501	3.02e-137	NTclustered	gi\|1566846291\|dbj\|LC455671.1\|	2510787	g104855	i0	90.339	128.313315926893	383	36	100	1	1	383	516	135	Cyanobacterium NIES-36 gene for 23S ribosomal RNA, partial sequence	blastn	49144	501	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium NIES-36
24883723	24883723	PRJNA681822_S_NODE_160_length_465_cov_6.729358_g135_i0	PRJNA681822	160	465	6.729358	31.2915147	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	749	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g135	i0	95.699	252.866666666667	465	20	100	0	1	465	1858852	1859316	Calothrix sp. PCC 7716 DNA, complete genome	blastn	117583	749	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
24883724	24883724	PRJNA681822_S_NODE_320_length_353_cov_29.867284_g295_i0	PRJNA681822	320	353	29.867284	105.43151252	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	586	7.399999999999997e-163	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g295	i0	96.601	289.195467422096	353	12	100	0	1	353	1856819	1857171	Calothrix sp. PCC 7716 DNA, complete genome	blastn	102086	586	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);;