metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA928559" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA928559" 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
2177517	2177517	PRJNA928559_P_NODE_120162_length_325_cov_1.238095_g118593_i0	PRJNA928559	120162	325	1.238095	4.02380875	uncultured delta proteobacterium	34034	Bacteria	Bacteria	315	3.5299999999999993e-81	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g118593	i0	84.639	136.750769230769	319	46	98	3	9	325	82677	82360	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	44444	315	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
5081497	5081497	PRJNA928559_P_NODE_68804_length_423_cov_139764.431429_g67235_i0	PRJNA928559	68804	423	139764.431429	591203.54494467	Pseudomonadota	1224	Bacteria	Bacteria	398	4.539999999999998e-106	NTclustered	gi\|202950689\|emb\|FM206054.1\|	34034	g67235	i0	100	52.9929078014184	215	0	51	0	209	423	230	16	Uncultured delta proteobacterium partial 16S rRNA gene, clone GW_1	blastn	22416	398	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
6357276	6357276	PRJNA928559_P_NODE_94985_length_365_cov_98461.352740_g93416_i0	PRJNA928559	94985	365	98461.35274	359383.937501	Pseudomonadota	1224	Bacteria	Bacteria	399	1.07e-106	NTclustered	gi\|202950689\|emb\|FM206054.1\|	34034	g93416	i0	100	60.3616438356164	216	0	59	0	150	365	231	16	Uncultured delta proteobacterium partial 16S rRNA gene, clone GW_1	blastn	22032	399	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
7281059	7281059	PRJNA928559_P_NODE_178666_length_260_cov_1.860963_g177097_i0	PRJNA928559	178666	260	1.860963	4.8385038	uncultured delta proteobacterium	34034	Bacteria	Bacteria	307	4.58e-79	NTclustered	gi\|2874253674\|emb\|OY969108.1\|	34034	g177097	i0	88.327	249.25	257	29	98	1	2	257	1544115	1543859	MAG: uncultured delta proteobacterium isolate MFD01828.bin.c.1 genome assembly, chromosome: 1	blastn	64805	307	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
7631285	7631285	PRJNA928559_P_NODE_68806_length_423_cov_75028.211429_g67237_i0	PRJNA928559	68806	423	75028.211429	317369.33434467	Pseudomonadota	1224	Bacteria	Bacteria	385	3.54e-102	NTclustered	gi\|202950689\|emb\|FM206054.1\|	34034	g67237	i0	100	50.6808510638298	208	0	49	0	1	208	16	223	Uncultured delta proteobacterium partial 16S rRNA gene, clone GW_1	blastn	21438	385	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
8905802	8905802	PRJNA928559_P_NODE_218447_length_236_cov_234.981595_g216878_i0	PRJNA928559	218447	236	234.981595	554.5565642	Bacteria	2	Bacteria	Bacteria	69.4	2.1e-7	NTclustered	gi\|407911330\|gb\|JQ772010.1\|	34034	g216878	i0	100	14.6228813559322	37	0	16	0	2	38	663	627	Uncultured delta proteobacterium clone CS54 16S ribosomal RNA gene, partial sequence	blastn	3451	69.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
10181823	10181823	PRJNA928559_P_NODE_75148_length_407_cov_108226.101796_g73579_i0	PRJNA928559	75148	407	108226.101796	440480.23430972	Pseudomonadota	1224	Bacteria	Bacteria	335	3.459999999999999e-87	NTclustered	gi\|202950689\|emb\|FM206054.1\|	34034	g73579	i0	100	50.2506142506142	181	0	44	0	227	407	7	187	Uncultured delta proteobacterium partial 16S rRNA gene, clone GW_1	blastn	20452	335	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
11456470	11456470	PRJNA928559_P_NODE_137829_length_301_cov_46.885965_g136260_i0	PRJNA928559	137829	301	46.885965	141.12675465	Bacteria	2	Bacteria	Bacteria	484	2.3299999999999996e-132	NTclustered	gi\|315177282\|gb\|HQ532522.1\|	34034	g136260	i0	95.681	104.654485049834	301	13	100	0	1	301	470	170	Uncultured delta proteobacterium clone CR011E8 16S ribosomal RNA gene, partial sequence	blastn	31501	484	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
12382181	12382181	PRJNA928559_P_NODE_179870_length_259_cov_1.784946_g178301_i0	PRJNA928559	179870	259	1.784946	4.62301014	Bradymonas sediminis	1548548	Bacteria	Bacteria	89.8	1.8e-13	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g178301	i0	87.179	0.301158301158301	78	10	30	0	172	249	167761	167684	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	78	89.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
12732254	12732254	PRJNA928559_P_NODE_172650_length_265_cov_3.958333_g171081_i0	PRJNA928559	172650	265	3.958333	10.48958245	Bacteria	2	Bacteria	Bacteria	411	3.47e-110	NTclustered	gi\|523452747\|gb\|KF183167.1\|	34034	g171081	i0	95.686	89.3433962264151	255	11	96	0	1	255	255	1	Uncultured delta proteobacterium clone S3-039 16S ribosomal RNA gene, partial sequence	blastn	23676	411	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
12732530	12732530	PRJNA928559_P_NODE_52790_length_473_cov_7.902500_g51224_i0	PRJNA928559	52790	473	7.9025	37.378825	Bacteria	2	Bacteria	Bacteria	65.8	5.91e-6	NTclustered	gi\|618731234\|emb\|HE803860.1\|	34034	g51224	i0	91.489	0.198731501057082	47	4	10	0	221	267	1346	1300	Uncultured delta proteobacterium partial 16S rRNA gene, isolate 1.2, clone 2	blastn	94	65.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
16555159	16555159	PRJNA928559_P_NODE_129513_length_312_cov_1.644351_g127944_i0	PRJNA928559	129513	312	1.644351	5.13037512	root	1	Root_unresolved	Root_unresolved	111	4.74e-20	NTclustered	gi\|18077335\|emb\|AJ347755.1\|	34034	g127944	i0	90.588	27.2532051282051	85	7	27	1	199	283	1152	1069	Uncultured delta proteobacterium 16S rRNA gene, clone ST-12K6	blastn	8503	111	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
17482914	17482914	PRJNA928559_P_NODE_9954_length_971_cov_5.164811_g8765_i0	PRJNA928559	9954	971	5.164811	50.15031481	uncultured delta proteobacterium DeepAnt-1F12	357894	Bacteria	Bacteria	946	0	NTclustered	gi\|82617822\|gb\|DQ267495.1\|	357894	g8765	i0	84.67	187.880535530381	985	112	99	24	1	961	3929	2960	Uncultured delta proteobacterium DeepAnt-1F12 fosmid, complete sequence	blastn	182432	946	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium DeepAnt-1F12
17830270	17830270	PRJNA928559_P_NODE_152974_length_284_cov_85405.753555_g151405_i0	PRJNA928559	152974	284	85405.753555	242552.3400962	Pseudomonadota	1224	Bacteria	Bacteria	305	1.82e-78	NTclustered	gi\|202950689\|emb\|FM206054.1\|	34034	g151405	i0	100	58.1021126760563	165	0	58	0	120	284	180	16	Uncultured delta proteobacterium partial 16S rRNA gene, clone GW_1	blastn	16501	307	0.993485342019544	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
18756059	18756059	PRJNA928559_P_NODE_83995_length_387_cov_5.063694_g82426_i0	PRJNA928559	83995	387	5.063694	19.59649578	uncultured delta proteobacterium DeepAnt-1F12	357894	Bacteria	Bacteria	394	5.33e-105	NTclustered	gi\|82617822\|gb\|DQ267495.1\|	357894	g82426	i0	85.176	138.498708010336	398	43	99	9	1	384	4183	4578	Uncultured delta proteobacterium DeepAnt-1F12 fosmid, complete sequence	blastn	53599	394	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium DeepAnt-1F12
20379294	20379294	PRJNA928559_P_NODE_210256_length_244_cov_0.912281_g208687_i0	PRJNA928559	210256	244	0.912281	2.22596564	Thermodesulfobacteriota	200940	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|68161332\|gb\|DQ069214.1\|	34034	g208687	i0	99.59	99.983606557377	244	1	100	0	1	244	871	628	Uncultured delta proteobacterium clone MAB1 16S ribosomal RNA gene, partial sequence	blastn	24396	446	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
21304970	21304970	PRJNA928559_P_NODE_173197_length_265_cov_1.625000_g171628_i0	PRJNA928559	173197	265	1.625	4.30625	Bradymonas sediminis	1548548	Bacteria	Bacteria	135	2.3400000000000003e-27	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g171628	i0	78.774	0.8	212	37	78	8	13	220	3664427	3664220	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	212	135	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
21305516	21305516	PRJNA928559_P_NODE_210857_length_243_cov_2.305882_g209288_i0	PRJNA928559	210857	243	2.305882	5.60329326	uncultured delta proteobacterium DeepAnt-1F12	357894	Bacteria	Bacteria	303	5.48e-78	NTclustered	gi\|82617822\|gb\|DQ267495.1\|	357894	g209288	i0	92.453	145.279835390946	212	16	87	0	31	242	4225	4014	Uncultured delta proteobacterium DeepAnt-1F12 fosmid, complete sequence	blastn	35303	303	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium DeepAnt-1F12
22930517	22930517	PRJNA928559_P_NODE_149998_length_287_cov_101368.130841_g148429_i0	PRJNA928559	149998	287	101368.130841	290926.53551367	Pseudomonadota	1224	Bacteria	Bacteria	329	1.09e-85	NTclustered	gi\|202950689\|emb\|FM206054.1\|	34034	g148429	i0	100	62.0209059233449	178	0	62	0	1	178	16	193	Uncultured delta proteobacterium partial 16S rRNA gene, clone GW_1	blastn	17800	329	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
24204208	24204208	PRJNA928559_P_NODE_126779_length_315_cov_105289.454545_g125210_i0	PRJNA928559	126779	315	105289.454545	331661.78181675	Pseudomonadota	1224	Bacteria	Bacteria	366	9.27e-97	NTclustered	gi\|202950689\|emb\|FM206054.1\|	34034	g125210	i0	100	64.1142857142857	198	0	63	0	118	315	213	16	Uncultured delta proteobacterium partial 16S rRNA gene, clone GW_1	blastn	20196	366	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium

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