metadata: contig_metadata: 8 rows where bioproject = "PRJNA529241" and tax

8 rows where bioproject = "PRJNA529241" and tax_clade = "delta/epsilon subdivisions"

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_class	tax_genus	tax_species
7494168	7494168	PRJNA529241_P_NODE_448486_length_157_cov_2.233333_g446164_i0	PRJNA529241	448486	157	2.233333	3.50633281	root	1	Root_unresolved	Root_unresolved	285	1.17e-72	NTclustered	gi\|118163120\|gb\|EF072655.1\|	34034	g446164	i0	99.363	99.9808917197452	157	1	100	0	1	157	569	725	Uncultured delta proteobacterium clone GASP-WA2S2_C12 16S ribosomal RNA gene, partial sequence	blastn	15697	285	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
9429733	9429733	PRJNA529241_P_NODE_48628_length_293_cov_2.558594_g46306_i0	PRJNA529241	48628	293	2.558594	7.49668042	uncultured delta proteobacterium	34034	Bacteria	Bacteria	416	8.359999999999998e-112	NTclustered	gi\|451917372\|gb\|KC451236.1\|	34034	g46306	i0	93.841	97.0136518771331	276	17	94	0	1	276	3	278	Uncultured delta proteobacterium clone RLBp2829 16S ribosomal RNA gene, partial sequence	blastn	28425	416	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
11319733	11319733	PRJNA529241_P_NODE_66509_length_257_cov_55.754545_g64187_i0	PRJNA529241	66509	257	55.754545	143.28918065	Pseudomonadota	1224	Bacteria	Bacteria	473	4.2099999999999996e-129	NTclustered	gi\|202950689\|emb\|FM206054.1\|	34034	g64187	i0	100	105.789883268482	256	0	99	0	2	257	259	4	Uncultured delta proteobacterium partial 16S rRNA gene, clone GW_1	blastn	27188	475	0.995789473684211	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium
15803227	15803227	PRJNA529241_P_NODE_396253_length_173_cov_2.139706_g393931_i0	PRJNA529241	396253	173	2.139706	3.70169138	Dissulfurimicrobium hydrothermale	1750598	Bacteria	Bacteria	84.2	5.15e-12	NTclustered	gi\|2190143862\|gb\|CP085041.1\|	1750598	g393931	i0	87.013	1.97109826589595	77	6	43	4	1	75	1867874	1867948	Dissulfurimicrobium hydrothermale strain Sh68 chromosome, complete genome	blastn	341	84.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Dissulfurimicrobium	Dissulfurimicrobium hydrothermale
20241963	20241963	PRJNA529241_P_NODE_32236_length_363_cov_2.263804_g29921_i0	PRJNA529241	32236	363	2.263804	8.21760852	Dissulfurimicrobium	1769732	Bacteria	Bacteria	392	1.7899999999999994e-104	NTclustered	gi\|82617822\|gb\|DQ267495.1\|	357894	g29921	i0	86.464	513.297520661157	362	43	99	6	1	359	5550	5192	Uncultured delta proteobacterium DeepAnt-1F12 fosmid, complete sequence	blastn	186327	394	0.99492385786802	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		uncultured delta proteobacterium DeepAnt-1F12
30488244	30488244	PRJNA529241_P_NODE_368333_length_173_cov_2.683824_g366011_i0	PRJNA529241	368333	173	2.683824	4.64301552	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	58.5	3.85e-8	NR	MBC8260029.1	2024889	g366011	i0	100	2.16763005780347	25	0	43.4	0	98	172	171	195	MBC8260029.1 formate dehydrogenase subunit alpha [SAR324 cluster bacterium]	diamond	375	58.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		SAR324 cluster bacterium
31198084	31198084	PRJNA529241_P_NODE_584095_length_150_cov_3.176991_g581773_i0	PRJNA529241	584095	150	3.176991	4.7654865	Bacteria	2	Bacteria	Bacteria	43.9	0.00236	NR	OIP32281.1	1805126	g581773	i0	62.1	3.68	29	11	58	0	57	143	35	63	OIP32281.1 MAG: rRNA maturation RNase YbeY [Deltaproteobacteria bacterium CG2_30_63_29]	diamond	552	43.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Deltaproteobacteria bacterium CG2_30_63_29
31594770	31594770	PRJNA529241_P_NODE_92536_length_225_cov_1.452128_g90214_i0	PRJNA529241	92536	225	1.452128	3.267288	Olavius algarvensis associated proteobacterium Delta 3	426688	Bacteria	Bacteria	43.5	0.0149	NR	CAB5117701.1	426688	g90214	i0	42.3	0.693333333333333	52	30	69.3	0	203	48	6	57	CAB5117701.1 S-adenosylmethionine decarboxylase proenzyme (EC, eukaryotic [Olavius algarvensis associated proteobacterium Delta 3]	diamond	156	43.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria		Olavius algarvensis associated proteobacterium Delta 3

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