metadata: contig_metadata: 19 rows where bioproject = "PRJEB66218" and tax

19 rows where bioproject = "PRJEB66218" 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_order	tax_family	tax_genus	tax_species
7784469	7784469	PRJEB66218_P_NODE_193667_length_213_cov_1.282895_g191237_i0	PRJEB66218	193667	213	1.282895	2.73256635	uncultured delta proteobacterium HF0010_01J10	710820	Bacteria	Bacteria	224	3.7499999999999997e-54	NTclustered	gi\|297180392\|gb\|GU474842.1\|	710820	g191237	i0	87.565	142.431924882629	193	24	91	0	21	213	12837	12645	Uncultured delta proteobacterium HF0010_01J10 genomic sequence	blastn	30338	224	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium HF0010_01J10
9061621	9061621	PRJEB66218_P_NODE_79668_length_354_cov_1.873720_g77242_i0	PRJEB66218	79668	354	1.87372	6.6329688000000004	Bradymonas sediminis	1548548	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g77242	i0	100	0.0790960451977401	28	0	8	0	301	328	216114	216087	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	28	52.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
11198523	11198523	PRJEB66218_P_NODE_88229_length_332_cov_0.848708_g85802_i0	PRJEB66218	88229	332	0.848708	2.81771056	Haliangium	162027	Bacteria	Bacteria	69.4	3.11e-7	NTclustered	gi\|2874253659\|emb\|OY969087.1\|	34034	g85802	i0	90.385	0.710843373493976	52	5	16	0	166	217	3128904	3128853	MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1	blastn	236	69.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
12884056	12884056	PRJEB66218_P_NODE_107251_length_294_cov_1.107296_g104822_i0	PRJEB66218	107251	294	1.107296	3.25545024	uncultured delta proteobacterium	34034	Bacteria	Bacteria	259	1.5e-64	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g104822	i0	87.611	120.833333333333	226	24	76	4	54	277	82673	82450	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	35525	259	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
13747714	13747714	PRJEB66218_P_NODE_153511_length_239_cov_1.325843_g151082_i0	PRJEB66218	153511	239	1.325843	3.16876477	Thermodesulfobacteriota	200940	Bacteria	Bacteria	425	1.1e-114	NTclustered	gi\|38373449\|gb\|AY455845.1\|	34034	g151082	i0	98.745	99.5020920502092	239	3	100	0	1	239	249	11	Uncultured delta proteobacterium clone AL1 16S ribosomal RNA gene, partial sequence	blastn	23781	425	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
14162969	14162969	PRJEB66218_P_NODE_86912_length_335_cov_1.594891_g84485_i0	PRJEB66218	86912	335	1.594891	5.34288485	uncultured delta proteobacterium DeepAnt-1F12	357894	Bacteria	Bacteria	448	3.4499999999999995e-121	NTclustered	gi\|82617822\|gb\|DQ267495.1\|	357894	g84485	i0	91.9	207.728358208955	321	24	96	2	1	320	3887	4206	Uncultured delta proteobacterium DeepAnt-1F12 fosmid, complete sequence	blastn	69589	448	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium DeepAnt-1F12
21396437	21396437	PRJEB66218_P_NODE_156797_length_236_cov_2.851429_g154367_i0	PRJEB66218	156797	236	2.851429	6.72937244	Bacteria	2	Bacteria	Bacteria	436	4.999999999999999e-118	NTclustered	gi\|383932333\|gb\|JN981954.1\|	34034	g154367	i0	100	95.3262711864407	236	0	100	0	1	236	242	7	Uncultured delta proteobacterium clone OTU-20_BFBA 16S ribosomal RNA gene, partial sequence	blastn	22497	436	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
24357718	24357718	PRJEB66218_P_NODE_179200_length_221_cov_2.062500_g176770_i0	PRJEB66218	179200	221	2.0625	4.558125	uncultured delta proteobacterium	34034	Bacteria	Bacteria	403	4.69e-108	NTclustered	gi\|451917560\|gb\|KC451424.1\|	34034	g176770	i0	99.548	98.9004524886878	221	1	100	0	1	221	3	223	Uncultured delta proteobacterium clone RLBp5442 16S ribosomal RNA gene, partial sequence	blastn	21857	403	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
24358078	24358078	PRJEB66218_P_NODE_200920_length_210_cov_1.677852_g198490_i0	PRJEB66218	200920	210	1.677852	3.5234892	uncultured delta proteobacterium	34034	Bacteria	Bacteria	278	2.79e-70	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g198490	i0	90.476	136.290476190476	210	20	100	0	1	210	13217	13008	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	28621	278	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
25220412	25220412	PRJEB66218_P_NODE_156160_length_237_cov_1.397727_g153731_i0	PRJEB66218	156160	237	1.397727	3.31261299	Myxococcota	2818505	Bacteria	Bacteria	377	3.09e-100	NTclustered	gi\|60266418\|gb\|AY921872.1\|	34034	g153731	i0	95.397	100.405063291139	239	7	100	4	1	237	783	547	Uncultured delta proteobacterium clone AKYH836 16S ribosomal RNA gene, partial sequence	blastn	23796	377	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
27381876	27381876	PRJEB66218_P_NODE_65423_length_402_cov_1.469208_g63000_i0	PRJEB66218	65423	402	1.469208	5.90621616	Lujinxingiaceae bacterium	2946527	Bacteria	Bacteria	152	1.85e-41	NR	MBA2660810.1	2946527	g63000	i0	69.8	0.791044776119403	106	32	79.1	0	320	3	5	110	MBA2660810.1 acetylglutamate kinase [Lujinxingiaceae bacterium]	diamond	318	152	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Lujinxingiaceae		Lujinxingiaceae bacterium
27785267	27785267	PRJEB66218_P_NODE_127084_length_265_cov_2.470588_g124655_i0	PRJEB66218	127084	265	2.470588	6.5470582	Pseudomonadota	1224	Bacteria	Bacteria	94	2.7e-22	NR	PIQ46194.1	1973977	g124655	i0	57.1	1.58490566037736	70	30	79.2	0	2	211	70	139	PIQ46194.1 MAG: hypothetical protein COW04_03485 [Deltaproteobacteria bacterium CG12_big_fil_rev_8_21_14_0_65_43_10]	diamond	420	94	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium CG12_big_fil_rev_8_21_14_0_65_43_10
28479774	28479774	PRJEB66218_P_NODE_89346_length_329_cov_1.578358_g86919_i0	PRJEB66218	89346	329	1.578358	5.19279782	Bacteria	2	Bacteria	Bacteria	76.3	1.2e-13	NR	OGQ06247.1	1797856	g86919	i0	49.1	2.89969604863222	106	52	96.7	2	12	329	134	237	OGQ06247.1 MAG: hypothetical protein A2712_05160 [Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49]	diamond	954	76.3	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49
29300645	29300645	PRJEB66218_P_NODE_42169_length_535_cov_1.373418_g39763_i0	PRJEB66218	42169	535	1.373418	7.3477863	Spirochaetota	203691	Bacteria	Bacteria	113	1.79e-26	NR	OGQ06361.1	1797856	g39763	i0	41	4.82803738317757	178	100	98.7	4	534	7	175	349	OGQ06361.1 MAG: hypothetical protein A2712_05585 [Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49]	diamond	2583	114	0.991228070175439	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49
29395350	29395350	PRJEB66218_P_NODE_123429_length_270_cov_1.775120_g121000_i0	PRJEB66218	123429	270	1.77512	4.792824	Bacteria	2	Bacteria	Bacteria	43.5	0.0267	NR	OGQ06247.1	1797856	g121000	i0	31.9	3.03333333333333	91	55	97.8	2	270	7	208	294	OGQ06247.1 MAG: hypothetical protein A2712_05160 [Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49]	diamond	819	43.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49
30665908	30665908	PRJEB66218_P_NODE_237093_length_203_cov_0.915493_g234662_i0	PRJEB66218	237093	203	0.915493	1.85845079	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	55.5	1.98e-7	NR	MCZ6749535.1	2024889	g234662	i0	45.3	0.945812807881773	64	33	94.6	1	202	11	63	124	MCZ6749535.1 thermonuclease family protein [SAR324 cluster bacterium]	diamond	192	55.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
31297823	31297823	PRJEB66218_P_NODE_108535_length_292_cov_0.991342_g106106_i0	PRJEB66218	108535	292	0.991342	2.89471864	Deltaproteobacteria bacterium DG_8	1703397	Bacteria	Bacteria	62	1.14e-8	NR	KPJ55820.1	1703397	g106106	i0	41.6	0.791095890410959	77	30	79.1	3	62	292	327	388	KPJ55820.1 MAG: hypothetical protein AMJ42_06195, partial [Deltaproteobacteria bacterium DG_8]	diamond	231	62	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium DG_8
32713707	32713707	PRJEB66218_P_NODE_93620_length_319_cov_2.108527_g91192_i0	PRJEB66218	93620	319	2.108527	6.72620113	Bacteria	2	Bacteria	Bacteria	50.1	2.37e-4	NR	OGQ06248.1	1797856	g91192	i0	38.3	1.42006269592476	81	49	75.2	1	251	12	408	488	OGQ06248.1 MAG: hypothetical protein A2712_05165 [Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49]	diamond	453	50.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49
32776587	32776587	PRJEB66218_P_NODE_123720_length_270_cov_1.224880_g121291_i0	PRJEB66218	123720	270	1.22488	3.307176	Bacteria	2	Bacteria	Bacteria	52.4	2.01e-5	NR	OGQ06361.1	1797856	g121291	i0	35.2	2.84444444444444	88	53	93.3	2	16	267	36	123	OGQ06361.1 MAG: hypothetical protein A2712_05585 [Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49]	diamond	768	52.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFCSPHIGHO2_01_FULL_43_49

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