metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA446034" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA446034" 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
1091926	1091926	PRJNA446034_S_NODE_26881_length_211_cov_6.051724_g26844_i0	PRJNA446034	26881	211	6.051724	12.76913764	Nostocales	1161	Bacteria	Bacteria	272	1.3099999999999999e-68	NTclustered	gi\|2500982325\|gb\|CP124543.1\|	1539056	g26844	i0	90.732	15.436018957346	205	18	97	1	1	205	473682	473885	Halotia branconii CENA392 chromosome, complete genome	blastn	3257	272	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Halotia	Halotia branconii
6194976	6194976	PRJNA446034_S_NODE_35305_length_199_cov_2.351852_g35268_i0	PRJNA446034	35305	199	2.351852	4.68018548	root	1	Root_unresolved	Root_unresolved	270	4.38e-68	NTclustered	gi\|583826816\|emb\|HG917244.1\|	1211	g35268	i0	98.684	113.778894472362	152	2	76	0	48	199	1	152	Uncultured cyanobacterium partial 16S rRNA gene, clone R16	blastn	22642	270	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
6195080	6195080	PRJNA446034_S_NODE_85165_length_161_cov_5.967742_g85128_i0	PRJNA446034	85165	161	5.967742	9.60806462	Chroococcaceae	1890464	Bacteria	Bacteria	89.8	1.02e-13	NTclustered	gi\|428262672\|gb\|CP003646.1\|	1173026	g85128	i0	86.42	1.00621118012422	81	11	50	0	1	81	2584632	2584552	Gloeocapsa sp. PCC 7428, complete genome	blastn	162	89.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
6815976	6815976	PRJNA446034_S_NODE_5286_length_303_cov_7.774436_g5249_i0	PRJNA446034	5286	303	7.774436	23.55654108	Nostoc sp. NIES-2111	1973475	Bacteria	Bacteria	196	1.23e-45	NTclustered	gi\|1210122991\|dbj\|AP018188.1\|	1973475	g5249	i0	79.643	12.9438943894389	280	51	91	5	1	277	17086	17362	Nostoc sp. NIES-2111 plasmid plasmid4 DNA, complete genome	blastn	3922	196	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-2111
9366168	9366168	PRJNA446034_S_NODE_47068_length_186_cov_3.053691_g47031_i0	PRJNA446034	47068	186	3.053691	5.67986526	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	176	9.04e-40	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g47031	i0	87.582	3.41397849462366	153	18	82	1	20	172	1070309	1070158	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	635	176	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
9366369	9366369	PRJNA446034_S_NODE_93228_length_158_cov_2.173554_g93191_i0	PRJNA446034	93228	158	2.173554	3.43421532	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	283	4.2499999999999995e-72	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g93191	i0	99.359	119.867088607595	156	1	99	0	3	158	300	455	Uncultured Chroococcidiopsis sp. clone GKJWQY101AIMXN 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	18939	283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
10642335	10642335	PRJNA446034_S_NODE_94709_length_157_cov_4.308333_g94672_i0	PRJNA446034	94709	157	4.308333	6.76408281	Nostoc sp. NIES-4103	2005458	Bacteria	Bacteria	137	3.48e-28	NTclustered	gi\|1210228378\|dbj\|AP018288.1\|	2005458	g94672	i0	83.221	1.80254777070064	149	25	95	0	1	149	5191305	5191453	Nostoc sp. NIES-4103 DNA, nearly complete genome	blastn	283	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-4103
14466969	14466969	PRJNA446034_S_NODE_612_length_517_cov_20.295833_g585_i0	PRJNA446034	612	517	20.295833	104.92945661	Aliterella chasmolithica	2739056	Bacteria	Bacteria	664	0	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g585	i0	91.511	112.452611218569	483	39	93	2	34	515	1969	2450	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	58138	664	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
15740962	15740962	PRJNA446034_S_NODE_71473_length_168_cov_7.961832_g71436_i0	PRJNA446034	71473	168	7.961832	13.37587776	Nostoc sp. NIES-2111	1973475	Bacteria	Bacteria	231	1.6899999999999998e-56	NTclustered	gi\|1210122991\|dbj\|AP018188.1\|	1973475	g71436	i0	91.667	16.0059523809524	168	12	99	2	1	167	16667	16501	Nostoc sp. NIES-2111 plasmid plasmid4 DNA, complete genome	blastn	2689	231	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-2111
17015635	17015635	PRJNA446034_S_NODE_634_length_512_cov_49.313684_g606_i0	PRJNA446034	634	512	49.313684	252.48606208	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	728	0	NTclustered	gi\|225696258\|gb\|FJ805925.1\|	259957	g606	i0	93.483	105.62109375	491	30	96	2	20	508	2111	1621	Uncultured Chroococcidiopsis sp. clone AS3_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	54078	728	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
17669649	17669649	PRJNA446034_S_NODE_73834_length_167_cov_3.476923_g73797_i0	PRJNA446034	73834	167	3.476923	5.80646141	Oscillatoriales	1150	Bacteria	Bacteria	265	1.65e-66	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g73797	i0	95.21	4.32335329341317	167	8	100	0	1	167	4901471	4901637	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	722	265	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
22114884	22114884	PRJNA446034_S_NODE_67138_length_171_cov_3.059701_g67101_i0	PRJNA446034	67138	171	3.059701	5.23208871	Nostoc sp. UHCC 0302	3134896	Bacteria	Bacteria	165	1.76e-36	NTclustered	gi\|2717038756\|gb\|CP151099.1\|	3134896	g67101	i0	84.524	0.982456140350877	168	24	98	2	1	167	7203236	7203402	Nostoc sp. UHCC 0302 chromosome, complete genome	blastn	168	165	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0302
23390489	23390489	PRJNA446034_S_NODE_57939_length_177_cov_4.021429_g57902_i0	PRJNA446034	57939	177	4.021429	7.11792933	Cyanobacteria bacterium K4m	2830641	Bacteria	Bacteria	287	3.77e-73	NTclustered	gi\|2029258269\|gb\|MZ020199.1\|	2830641	g57902	i0	96.532	148.830508474576	173	6	98	0	2	174	1408	1236	Cyanobacteria bacterium K4m 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	26343	287	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium K4m

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