metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA556992" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA556992" 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
529938	529938	PRJNA556992_P_NODE_53861_length_498_cov_10.720000_g51698_i0	PRJNA556992	53861	498	10.72	53.3856	uncultured delta proteobacterium	34034	Bacteria	Bacteria	749	0	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g51698	i0	93.8	172.654618473896	500	27	100	4	1	498	14177	14674	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	85982	749	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
3085769	3085769	PRJNA556992_P_NODE_927083_length_238_cov_2.696970_g924893_i0	PRJNA556992	927083	238	2.69697	6.4187886	uncultured delta proteobacterium	34034	Bacteria	Bacteria	346	8.76e-91	NTclustered	gi\|451917299\|gb\|KC451163.1\|	34034	g924893	i0	93.22	78.1050420168067	236	15	99	1	1	236	294	60	Uncultured delta proteobacterium clone RLBp1714 16S ribosomal RNA gene, partial sequence	blastn	18589	346	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
3678117	3678117	PRJNA556992_P_NODE_60223_length_478_cov_4.822222_g58055_i0	PRJNA556992	60223	478	4.822222	23.05022116	Bacteria	2	Bacteria	Bacteria	701	0	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g58055	i0	93.096	144.962343096234	478	33	100	0	1	478	14674	14197	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	69292	701	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
4359531	4359531	PRJNA556992_P_NODE_724904_length_250_cov_0.870056_g722715_i0	PRJNA556992	724904	250	0.870056	2.17514	Deltaproteobacteria bacterium Smac51	2946587	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2242725236\|gb\|CP026657.1\|	2946587	g722715	i0	92.308	0.156	39	2	15	1	118	155	2579772	2579810	Deltaproteobacteria bacterium Smac51 chromosome, complete genome	blastn	39	54.7	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium Smac51
5634666	5634666	PRJNA556992_P_NODE_60265_length_478_cov_3.488889_g58097_i0	PRJNA556992	60265	478	3.488889	16.67688942	uncultured delta proteobacterium HF0010_01J10	710820	Bacteria	Bacteria	507	8.26e-139	NTclustered	gi\|297180392\|gb\|GU474842.1\|	710820	g58097	i0	86.042	157.617154811715	480	58	99	7	2	478	14395	14868	Uncultured delta proteobacterium HF0010_01J10 genomic sequence	blastn	75341	507	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium HF0010_01J10
5637360	5637360	PRJNA556992_P_NODE_823145_length_245_cov_0.895349_g820955_i0	PRJNA556992	823145	245	0.895349	2.19360505	uncultured delta proteobacterium	34034	Bacteria	Bacteria	296	9.249999999999999e-76	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g820955	i0	88.618	171.044897959184	246	25	100	3	1	245	82318	82561	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	41906	296	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
6902235	6902235	PRJNA556992_P_NODE_133726_length_371_cov_1.718121_g131539_i0	PRJNA556992	133726	371	1.718121	6.37422891	uncultured delta proteobacterium DeepAnt-1F12	357894	Bacteria	Bacteria	459	1.7799999999999998e-124	NTclustered	gi\|82617822\|gb\|DQ267495.1\|	357894	g131539	i0	88.947	210.948787061995	380	30	99	5	1	369	4446	4068	Uncultured delta proteobacterium DeepAnt-1F12 fosmid, complete sequence	blastn	78262	459	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium DeepAnt-1F12
6905289	6905289	PRJNA556992_P_NODE_3326_length_1700_cov_4.314690_g2691_i0	PRJNA556992	3326	1700	4.31469	73.34973	uncultured delta proteobacterium	34034	Bacteria	Bacteria	1897	0	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g2691	i0	86.934	135.452941176471	1722	185	100	35	1	1700	13852	12149	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	230270	1897	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
6905647	6905647	PRJNA556992_P_NODE_358126_length_281_cov_1.908654_g355937_i0	PRJNA556992	358126	281	1.908654	5.36331774	uncultured delta proteobacterium	34034	Bacteria	Bacteria	351	2.28e-92	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g355937	i0	89.855	145.562277580071	276	24	97	3	1	273	13351	13625	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	40903	351	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
10738950	10738950	PRJNA556992_P_NODE_927529_length_238_cov_2.581818_g925339_i0	PRJNA556992	927529	238	2.581818	6.14472684	Bradymonas sediminis	1548548	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g925339	i0	100	0.117647058823529	28	0	12	0	3	30	3927131	3927104	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	28	52.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
12006539	12006539	PRJNA556992_P_NODE_354950_length_281_cov_3.812500_g352761_i0	PRJNA556992	354950	281	3.8125	10.713125	uncultured delta proteobacterium HF0010_01J10	710820	Bacteria	Bacteria	326	1.38e-84	NTclustered	gi\|297180392\|gb\|GU474842.1\|	710820	g352761	i0	87.544	218.056939501779	281	35	100	0	1	281	12617	12897	Uncultured delta proteobacterium HF0010_01J10 genomic sequence	blastn	61274	326	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium HF0010_01J10
12007717	12007717	PRJNA556992_P_NODE_44570_length_536_cov_1.948164_g42415_i0	PRJNA556992	44570	536	1.948164	10.44215904	uncultured delta proteobacterium HF0010_01J10	710820	Bacteria	Bacteria	686	0	NTclustered	gi\|297180392\|gb\|GU474842.1\|	710820	g42415	i0	89.944	166.011194029851	537	47	99	6	2	536	13854	14385	Uncultured delta proteobacterium HF0010_01J10 genomic sequence	blastn	88982	686	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium HF0010_01J10
15830956	15830956	PRJNA556992_P_NODE_391653_length_277_cov_2.995098_g389464_i0	PRJNA556992	391653	277	2.995098	8.29642146	uncultured delta proteobacterium	34034	Bacteria	Bacteria	60.2	1.52e-4	NTclustered	gi\|2874253674\|emb\|OY969108.1\|	34034	g389464	i0	97.143	7.09025270758123	35	1	13	0	85	119	1519823	1519857	MAG: uncultured delta proteobacterium isolate MFD01828.bin.c.1 genome assembly, chromosome: 1	blastn	1964	60.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
15833362	15833362	PRJNA556992_P_NODE_58873_length_482_cov_3.841076_g56705_i0	PRJNA556992	58873	482	3.841076	18.51398632	uncultured delta proteobacterium HF0010_01J10	710820	Bacteria	Bacteria	654	0	NTclustered	gi\|297180392\|gb\|GU474842.1\|	710820	g56705	i0	91.268	216.348547717842	481	41	99	1	3	482	13774	14254	Uncultured delta proteobacterium HF0010_01J10 genomic sequence	blastn	104280	654	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium HF0010_01J10
15836468	15836468	PRJNA556992_P_NODE_837853_length_244_cov_0.900585_g835663_i0	PRJNA556992	837853	244	0.900585	2.1974274	uncultured delta proteobacterium	34034	Bacteria	Bacteria	309	1.1800000000000002e-79	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g835663	i0	89.474	147.745901639344	247	22	100	3	1	244	83034	83279	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	36050	309	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
18381985	18381985	PRJNA556992_P_NODE_5535_length_1375_cov_4.344854_g2691_i1	PRJNA556992	5535	1375	4.344854	59.7417425	uncultured delta proteobacterium	34034	Bacteria	Bacteria	1642	0	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g2691	i1	88.295	139.901090909091	1384	144	100	15	1	1375	12149	13523	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	192364	1642	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);;