metadata: contig_metadata: 16 rows where bioproject = "PRJNA704949" and tax

16 rows where bioproject = "PRJNA704949" 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
14721350	14721350	PRJNA704949_P_NODE_1803672_length_177_cov_1.625000_g1788333_i0	PRJNA704949	1803672	177	1.625	2.87625	Chlorobaculum tepidum	1097	Bacteria	Bacteria	104	4.07e-18	NTclustered	gi\|21672293\|gb\|AE006470.1\|	194439	g1788333	i0	79.605	32.0621468926554	152	26	85	4	25	175	528078	527931	Chlorobium tepidum TLS, complete genome	blastn	5675	104	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobaculum	Chlorobaculum tepidum
20313052	20313052	PRJNA704949_P_NODE_1506336_length_200_cov_1.735099_g1490998_i0	PRJNA704949	1506336	200	1.735099	3.470198	Bacteria	2	Bacteria	Bacteria	97.1	7.91e-16	NTclustered	gi\|635213055\|tpe\|LK004451.1\|	194439	g1490998	i0	100	32.605	52	0	26	0	149	200	1	52	TPA: Chlorobium tepidum TLS tRNA-Arg-ACG-1-1 gene	blastn	6521	97.1	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobaculum	Chlorobaculum tepidum
21589802	21589802	PRJNA704949_P_NODE_185797_length_604_cov_3.041441_g171825_i0	PRJNA704949	185797	604	3.041441	18.37030364	FCB group	1783270	Bacteria	Bacteria	54.7	0.017	NTclustered	gi\|194310671\|gb\|CP001108.1\|	290512	g171825	i0	100	0.394039735099338	29	0	5	0	222	250	1584210	1584238	Prosthecochloris aestuarii DSM 271 chromosome, complete genome	blastn	238	54.7	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Prosthecochloris	Prosthecochloris aestuarii
22367331	22367331	PRJNA704949_P_NODE_1504538_length_200_cov_2.311258_g1489200_i0	PRJNA704949	1504538	200	2.311258	4.622516	Bacteria	2	Bacteria	Bacteria	99.8	4.3e-23	NR	WP_082678574.1	1092	g1489200	i0	81.4	6.99	59	11	88.5	0	3	179	280	338	WP_082678574.1 PDDEXK nuclease domain-containing protein [Chlorobium limicola]	diamond	1398	100	0.998	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium limicola
27778127	27778127	PRJNA704949_P_NODE_1486004_length_202_cov_1.424837_g1470666_i0	PRJNA704949	1486004	202	1.424837	2.87817074	Chlorobiaceae bacterium	2067991	Bacteria	Bacteria	114	9.71e-28	NR	MBA4313027.1	2067991	g1470666	i0	79.7	1.91584158415842	64	13	95	0	194	3	563	626	MBA4313027.1 restriction endonuclease subunit M [Chlorobiaceae bacterium]	diamond	387	114	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae		Chlorobiaceae bacterium
28188549	28188549	PRJNA704949_P_NODE_655026_length_334_cov_1.771930_g639700_i0	PRJNA704949	655026	334	1.77193	5.9182462	Chlorobiota bacterium	2268192	Bacteria	Bacteria	75.9	2.67e-13	NR	NOZ35666.1	2268192	g639700	i0	50.6	1.3562874251497	79	39	71	0	334	98	415	493	NOZ35666.1 T9SS type A sorting domain-containing protein [Chlorobiota bacterium]	diamond	453	75.9	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
28599262	28599262	PRJNA704949_P_NODE_2106547_length_164_cov_0.904348_g2091208_i0	PRJNA704949	2106547	164	0.904348	1.48313072	Chlorobiota bacterium	2268192	Bacteria	Bacteria	77	2.98e-15	NR	MCE2503239.1	2268192	g2091208	i0	71.7	0.969512195121951	53	15	97	0	159	1	105	157	MCE2503239.1 RNB domain-containing ribonuclease [Chlorobiota bacterium]	diamond	159	77	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
29767360	29767360	PRJNA704949_P_NODE_689371_length_325_cov_1.018116_g674043_i0	PRJNA704949	689371	325	1.018116	3.308877	Chlorobaculum sp.	2053530	Bacteria	Bacteria	68.2	1.2e-10	NR	NTV67629.1	2053530	g674043	i0	61	0.544615384615385	59	22	54.5	1	223	47	187	244	NTV67629.1 SIR2 family protein [Chlorobaculum sp.]	diamond	177	68.2	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobaculum	Chlorobaculum sp.
29798482	29798482	PRJNA704949_P_NODE_1130951_length_241_cov_1.505208_g1115615_i0	PRJNA704949	1130951	241	1.505208	3.62755128	Chlorobiota bacterium	2268192	Bacteria	Bacteria	60.1	1.56e-8	NR	MDB5033755.1	2268192	g1115615	i0	46.8	0.771784232365145	62	33	77.2	0	240	55	180	241	MDB5033755.1 hypothetical protein [Chlorobiota bacterium]	diamond	186	60.1	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
30273346	30273346	PRJNA704949_P_NODE_922632_length_273_cov_2.321429_g907298_i0	PRJNA704949	922632	273	2.321429	6.33750117	Chloroherpeton thalassium	100716	Bacteria	Bacteria	66.6	2.16e-10	NR	WP_083766264.1	100716	g907298	i0	44.3	0.967032967032967	88	38	96.7	1	264	1	9	85	WP_083766264.1 T9SS type A sorting domain-containing protein [Chloroherpeton thalassium]	diamond	264	66.6	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chloroherpetonaceae	Chloroherpeton	Chloroherpeton thalassium
30441670	30441670	PRJNA704949_P_NODE_1481613_length_202_cov_2.699346_g1466275_i0	PRJNA704949	1481613	202	2.699346	5.45267892	Pseudomonadati	3379134	Bacteria	Bacteria	87.4	2.29e-18	NR	WP_011744657.1	1096	g1466275	i0	69.7	6.86138613861386	66	20	98	0	200	3	95	160	WP_011744657.1 efflux RND transporter periplasmic adaptor subunit [Chlorobium phaeobacteroides]	diamond	1386	88.2	0.99092970521542	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium phaeobacteroides
30620091	30620091	PRJNA704949_P_NODE_1552133_length_196_cov_2.034014_g1536794_i0	PRJNA704949	1552133	196	2.034014	3.98666744	Chlorobaculum parvum	274539	Bacteria	Bacteria	46.2	9.88e-4	NR	WP_012502157.1	274539	g1536794	i0	46.7	1.56122448979592	60	21	75	3	195	49	163	222	WP_012502157.1 HAD family hydrolase [Chlorobaculum parvum]	diamond	306	46.2	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobaculum	Chlorobaculum parvum
30715066	30715066	PRJNA704949_P_NODE_2124574_length_163_cov_1.368421_g2109235_i0	PRJNA704949	2124574	163	1.368421	2.23052623	Chlorobiota bacterium	2268192	Bacteria	Bacteria	60.5	7e-9	NR	MBL7989346.1	2268192	g2109235	i0	54.9	0.938650306748466	51	23	93.9	0	1	153	346	396	MBL7989346.1 alpha/beta fold hydrolase [Chlorobiota bacterium]	diamond	153	60.5	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
31199463	31199463	PRJNA704949_P_NODE_675235_length_328_cov_2.720430_g659907_i0	PRJNA704949	675235	328	2.72043	8.9230104	Bacteria	2	Bacteria	Bacteria	48.1	0.00119	NR	WP_011357542.1	1100	g659907	i0	35.8	1.41768292682927	67	42	61.3	1	315	115	307	372	WP_011357542.1 AAA family ATPase [Pelodictyon luteolum]	diamond	465	48.5	0.991752577319588	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Pelodictyon	Pelodictyon luteolum
31358135	31358135	PRJNA704949_P_NODE_625916_length_342_cov_2.965870_g610591_i0	PRJNA704949	625916	342	2.96587	10.1432754	Pseudomonadati	3379134	Bacteria	Bacteria	49.3	1.65e-4	NR	WP_139456170.1	115852	g610591	i0	66.7	2.29824561403509	30	10	26.3	0	17	106	110	139	WP_139456170.1 universal stress protein [Chlorobaculum thiosulfatiphilum]	diamond	786	49.7	0.991951710261569	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobaculum	Chlorobaculum thiosulfatiphilum
31484700	31484700	PRJNA704949_P_NODE_186756_length_603_cov_2.041516_g172774_i0	PRJNA704949	186756	603	2.041516	12.31034148	Pseudomonadati	3379134	Bacteria	Bacteria	310	5.87e-100	NR	WP_011745243.1	1096	g172774	i0	73.4	5.92537313432836	199	53	99	0	598	2	24	222	WP_011745243.1 restriction endonuclease subunit S [Chlorobium phaeobacteroides]	diamond	3573	310	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium phaeobacteroides

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