metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax

11 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax_phylum = "Chlorobiota"

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
993290	993290	PRJEB64798_P_NODE_225601_length_160_cov_6.099099_g223835_i0	PRJEB64798	225601	160	6.099099	9.7585584	Chlorobiaceae	191412	Bacteria	Bacteria	137	3.56e-28	NTclustered	gi\|470483367\|ref\|NR_076588.1\|	1096	g223835	i0	89.815	116.59375	108	9	67	2	29	135	1330	1436	Chlorobium phaeobacteroides strain BS1 23S ribosomal RNA gene, complete sequence	blastn	18655	137	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium phaeobacteroides
6095971	6095971	PRJEB64798_P_NODE_131945_length_197_cov_7.655405_g130179_i0	PRJEB64798	131945	197	7.655405	15.08114785	Chlorobium	1091	Bacteria	Bacteria	135	1.65e-27	NTclustered	gi\|470483299\|ref\|NR_076584.1\|	1092	g130179	i0	92.708	24.7208121827411	96	3	48	4	51	144	166	259	Chlorobium limicola strain DSM 245 23S ribosomal RNA gene, complete sequence	blastn	4870	135	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium limicola
6096123	6096123	PRJEB64798_P_NODE_162965_length_182_cov_2.488722_g161199_i0	PRJEB64798	162965	182	2.488722	4.52947404	Pseudomonadati	3379134	Bacteria	Bacteria	97.1	7.05e-16	NTclustered	gi\|2746120\|gb\|AF027011.1\|	68983	g161199	i0	89.474	39.7417582417582	76	8	42	0	3	78	393	318	Unidentified green sulfur bacterium OPS77 16S ribosomal RNA gene, partial sequence	blastn	7233	97.1	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					unidentified green sulfur bacterium OPS77
6096449	6096449	PRJEB64798_P_NODE_232225_length_158_cov_2.633028_g230459_i0	PRJEB64798	232225	158	2.633028	4.16018424	Chlorobiaceae	191412	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|174077\|gb\|M62805.1\|CHBRRL	1092	g230459	i0	100	1.45569620253165	29	0	18	0	87	115	371	343	C.limicola large subunit ribosomal RNA	blastn	230	54.7	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium limicola
7780867	7780867	PRJEB64798_P_NODE_242067_length_154_cov_6.533333_g240301_i0	PRJEB64798	242067	154	6.533333	10.06133282	Chlorobiota bacterium	2268192	Bacteria	Bacteria	132	1.58e-26	NTclustered	gi\|1958119998\|gb\|CP065014.1\|	2268192	g240301	i0	88.393	178.220779220779	112	9	71	4	40	149	281367	281258	MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome	blastn	27446	132	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
9055591	9055591	PRJEB64798_P_NODE_232948_length_157_cov_12.462963_g231182_i0	PRJEB64798	232948	157	12.462963	19.56685191	Chlorobiota bacterium	2268192	Bacteria	Bacteria	163	5.74e-36	NTclustered	gi\|1958119998\|gb\|CP065014.1\|	2268192	g231182	i0	90.909	0.770700636942675	121	11	77	0	5	125	3135633	3135513	MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome	blastn	121	163	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
9920887	9920887	PRJEB64798_P_NODE_109808_length_210_cov_6.366460_g108042_i0	PRJEB64798	109808	210	6.36646	13.369566	Pseudomonadati	3379134	Bacteria	Bacteria	180	8.099999999999998e-41	NTclustered	gi\|77403655\|dbj\|AB161089.1\|	156405	g108042	i0	99	61.5619047619048	100	1	94	0	110	209	197	296	Uncultured Chlorobi bacterium gene for 16S ribosomal RNA, partial sequence, clone:3D9	blastn	12928	180	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					uncultured Chlorobiota bacterium
13746791	13746791	PRJEB64798_P_NODE_248651_length_152_cov_4.873786_g246885_i0	PRJEB64798	248651	152	4.873786	7.40815472	Chlorobium	1091	Bacteria	Bacteria	128	2.01e-25	NTclustered	gi\|470483299\|ref\|NR_076584.1\|	1092	g246885	i0	84.058	21.4078947368421	138	16	91	4	8	145	257	126	Chlorobium limicola strain DSM 245 23S ribosomal RNA gene, complete sequence	blastn	3254	128	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium limicola
17570498	17570498	PRJEB64798_P_NODE_106934_length_211_cov_2.660494_g105168_i0	PRJEB64798	106934	211	2.660494	5.61364234	Prosthecochloris	1101	Bacteria	Bacteria	95.3	3.04e-15	NTclustered	gi\|1187407156\|gb\|CP020873.1\|	1974213	g105168	i0	96.491	11.9336492890995	57	2	27	0	44	100	1520159	1520215	Prosthecochloris sp. HL-130-GSB chromosome, complete genome	blastn	2518	95.3	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Prosthecochloris	Prosthecochloris sp. HL-130-GSB
22669773	22669773	PRJEB64798_P_NODE_148478_length_189_cov_4.085714_g146712_i0	PRJEB64798	148478	189	4.085714	7.72199946	Chlorobiaceae	191412	Bacteria	Bacteria	141	3.3600000000000003e-29	NTclustered	gi\|470483299\|ref\|NR_076584.1\|	1092	g146712	i0	83.125	239.164021164021	160	21	83	4	27	183	2874	2718	Chlorobium limicola strain DSM 245 23S ribosomal RNA gene, complete sequence	blastn	45202	141	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium limicola
23080570	23080570	PRJEB64798_P_NODE_25919_length_386_cov_877.807122_g24169_i0	PRJEB64798	25919	386	877.807122	3388.33549092	Chlorobi bacterium canine oral taxon 312	1151615	Bacteria	Bacteria	630	3.7199999999999986e-176	NTclustered	gi\|373279767\|gb\|JN713480.1\|	1151615	g24169	i0	97.312	94.1269430051813	372	8	96	2	16	386	1	371	Chlorobi bacterium canine oral taxon 312 clone 1A063 16S ribosomal RNA gene, partial sequence	blastn	36333	630	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobi bacterium canine oral taxon 312

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