metadata: contig_metadata: 10 rows where bioproject = "PRJNA564013" and tax

10 rows where bioproject = "PRJNA564013" 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
8199539	8199539	PRJNA564013_P_NODE_113787_length_390_cov_7.097264_g110945_i0	PRJNA564013	113787	390	7.097264	27.6793296	Chlorobaculum tepidum	1097	Bacteria	Bacteria	401	3.209999999999999e-107	NTclustered	gi\|21672293\|gb\|AE006470.1\|	194439	g110945	i0	87.644	48.8846153846154	348	39	89	4	23	368	1777255	1777600	Chlorobium tepidum TLS, complete genome	blastn	19065	401	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobaculum	Chlorobaculum tepidum
8200015	8200015	PRJNA564013_P_NODE_1327_length_2446_cov_163.734172_g927_i0	PRJNA564013	1327	2446	163.734172	4004.93784712	Chlorobaculum tepidum	1097	Bacteria	Bacteria	1027	0	NTclustered	gi\|21672293\|gb\|AE006470.1\|	194439	g927	i0	83.438	42.8708094848733	1117	173	45	8	68	1178	1776261	1775151	Chlorobium tepidum TLS, complete genome	blastn	104862	1027	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobaculum	Chlorobaculum tepidum
9480092	9480092	PRJNA564013_P_NODE_347748_length_200_cov_2.841727_g344896_i0	PRJNA564013	347748	200	2.841727	5.683454	Chlorobiota bacterium	2268192	Bacteria	Bacteria	110	1.16e-26	NR	RMF35690.1	2268192	g344896	i0	94.3	0.795	53	3	79.5	0	38	196	32	84	RMF35690.1 MAG: cysteine--tRNA ligase [Chlorobiota bacterium]	diamond	159	110	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
21535110	21535110	PRJNA564013_P_NODE_6377_length_1321_cov_10.879365_g5082_i0	PRJNA564013	6377	1321	10.879365	143.71641165	Pseudomonadati	3379134	Bacteria	Bacteria	542	6.58e-149	NTclustered	gi\|21672293\|gb\|AE006470.1\|	194439	g5082	i0	87.315	45.9894019682059	473	60	36	0	1	473	1781645	1782117	Chlorobium tepidum TLS, complete genome	blastn	60752	542	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobaculum	Chlorobaculum tepidum
28279198	28279198	PRJNA564013_P_NODE_47166_length_572_cov_9.776908_g44419_i0	PRJNA564013	47166	572	9.776908	55.92391376	Chlorobiota bacterium	2268192	Bacteria	Bacteria	273	4.88e-88	NR	RMF35619.1	2268192	g44419	i0	91.4	1.59440559440559	152	13	79.7	0	106	561	1	152	RMF35619.1 MAG: CinA family nicotinamide mononucleotide deamidase-related protein, partial [Chlorobiota bacterium]	diamond	912	273	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
28546025	28546025	PRJNA564013_P_NODE_303767_length_223_cov_2.290123_g300915_i0	PRJNA564013	303767	223	2.290123	5.10697429	Pseudomonadati	3379134	Bacteria	Bacteria	65.9	2.07e-10	NR	MBA4312784.1	2067991	g300915	i0	54.1	1.61434977578475	61	28	82.1	0	2	184	28	88	MBA4312784.1 hypothetical protein [Chlorobiaceae bacterium]	diamond	360	65.9	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae		Chlorobiaceae bacterium
30047470	30047470	PRJNA564013_P_NODE_245751_length_265_cov_2.225490_g242899_i0	PRJNA564013	245751	265	2.22549	5.8975485	Chlorobi bacterium NICIL-2	1662223	Bacteria	Bacteria	107	6.0700000000000006e-27	NR	KXB97019.1	1662223	g242899	i0	90.2	0.690566037735849	61	6	69.1	0	250	68	122	182	KXB97019.1 MAG: hypothetical protein AA908_08735 [Chlorobi bacterium NICIL-2]	diamond	183	107	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobi bacterium NICIL-2
31059066	31059066	PRJNA564013_P_NODE_35335_length_646_cov_26.305983_g32676_i0	PRJNA564013	35335	646	26.305983	169.93665018	Chlorobi bacterium NICIL-2	1662223	Bacteria	Bacteria	308	2.24e-103	NR	KXB97582.1	1662223	g32676	i0	95.5	0.729102167182663	157	7	72.9	0	20	490	74	230	KXB97582.1 MAG: hydrolase [Chlorobi bacterium NICIL-2]	diamond	471	308	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobi bacterium NICIL-2
31262164	31262164	PRJNA564013_P_NODE_330655_length_208_cov_2.571429_g327803_i0	PRJNA564013	330655	208	2.571429	5.34857232	Bacteria	2	Bacteria	Bacteria	65.9	1.58e-10	NR	KXK56177.1	1619898	g327803	i0	86.8	1.09615384615385	38	5	54.8	0	125	12	1	38	KXK56177.1 MAG: MATE family multidrug resistance protein [Chlorobi bacterium OLB7]	diamond	228	65.9	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobi bacterium OLB7
32765795	32765795	PRJNA564013_P_NODE_194120_length_311_cov_41.912000_g191269_i0	PRJNA564013	194120	311	41.912	130.34632	Chloroherpeton thalassium	100716	Bacteria	Bacteria	89.7	1.8899999999999998e-20	NR	WP_012501121.1	100716	g191269	i0	57.7	5.42122186495177	71	30	68.5	0	285	73	63	133	WP_012501121.1 DnaJ domain-containing protein [Chloroherpeton thalassium]	diamond	1686	89.7	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chloroherpetonaceae	Chloroherpeton	Chloroherpeton thalassium

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