metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA944406" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA944406" 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
924390	924390	PRJNA944406_P_NODE_3061_length_778_cov_2.536170_g2235_i0	PRJNA944406	3061	778	2.53617	19.7314026	uncultured delta proteobacterium HF0070_10I02	710824	Bacteria	Bacteria	658	0	NTclustered	gi\|297181000\|gb\|GU474857.1\|	710824	g2235	i0	82.278	137.188946015424	790	113	99	21	1	775	7056	7833	Uncultured delta proteobacterium HF0070_10I02 genomic sequence	blastn	106733	658	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium HF0070_10I02
3475348	3475348	PRJNA944406_P_NODE_48343_length_265_cov_1.197917_g47384_i0	PRJNA944406	48343	265	1.197917	3.17448005	uncultured delta proteobacterium DeepAnt-1F12	357894	Bacteria	Bacteria	287	6.099999999999999e-73	NTclustered	gi\|82617822\|gb\|DQ267495.1\|	357894	g47384	i0	86.923	196.894339622641	260	29	97	4	1	257	4685	4942	Uncultured delta proteobacterium DeepAnt-1F12 fosmid, complete sequence	blastn	52177	287	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium DeepAnt-1F12
3811596	3811596	PRJNA944406_P_NODE_7503_length_458_cov_4.490909_g6547_i0	PRJNA944406	7503	458	4.490909	20.56836322	Bacteria	2	Bacteria	Bacteria	697	0	NTclustered	gi\|511202455\|gb\|KC994686.1\|	34034	g6547	i0	96.037	87.4126637554585	429	15	93	2	1	428	9	436	Uncultured delta proteobacterium clone BF 006 16S ribosomal RNA gene, partial sequence	blastn	40035	704	0.990056818181818	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
6027682	6027682	PRJNA944406_P_NODE_39285_length_273_cov_1.540000_g38326_i0	PRJNA944406	39285	273	1.54	4.2042	Microvenator marinus	2600177	Bacteria	Bacteria	161	3.99e-35	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g38326	i0	87.234	79.6483516483516	141	18	52	0	133	273	703078	703218	Microvenator marinus strain V1718 chromosome, complete genome	blastn	21744	161	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
6028098	6028098	PRJNA944406_P_NODE_75445_length_248_cov_2.634286_g74486_i0	PRJNA944406	75445	248	2.634286	6.53302928	uncultured delta proteobacterium	34034	Bacteria	Bacteria	60.2	1.34e-4	NTclustered	gi\|2259418016\|emb\|OW933748.1\|	34034	g74486	i0	97.143	0.141129032258065	35	1	14	0	151	185	317	283	uncultured delta proteobacterium DNA containing 16S-23S intergenic spacer region, clone 43	blastn	35	60.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
7637593	7637593	PRJNA944406_P_NODE_56866_length_257_cov_1.255435_g55907_i0	PRJNA944406	56866	257	1.255435	3.22646795	Bacteria	2	Bacteria	Bacteria	470	5.45e-128	NTclustered	gi\|237757531\|gb\|FJ946330.1\|	34034	g55907	i0	99.611	99.9922178988327	257	1	100	0	1	257	188	444	Uncultured delta proteobacterium clone H-34-E 16S ribosomal RNA gene, partial sequence	blastn	25698	470	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
9852447	9852447	PRJNA944406_P_NODE_2968_length_795_cov_2.022161_g2144_i0	PRJNA944406	2968	795	2.022161	16.07617995	uncultured delta proteobacterium	34034	Bacteria	Bacteria	765	0	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g2144	i0	84.105	109.568553459119	799	119	100	6	1	795	13061	13855	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	87107	765	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
12403550	12403550	PRJNA944406_P_NODE_30270_length_282_cov_1.119617_g29311_i0	PRJNA944406	30270	282	1.119617	3.15731994	uncultured delta proteobacterium	34034	Bacteria	Bacteria	472	1.6799999999999998e-128	NTclustered	gi\|110813894\|gb\|DQ676326.1\|	34034	g29311	i0	96.82	96.436170212766	283	7	100	2	1	282	565	284	Uncultured delta proteobacterium clone MVS-27 16S ribosomal RNA gene, partial sequence	blastn	27195	472	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
12403584	12403584	PRJNA944406_P_NODE_32950_length_279_cov_1.495146_g31991_i0	PRJNA944406	32950	279	1.495146	4.17145734	uncultured delta proteobacterium	34034	Bacteria	Bacteria	154	6.850000000000001e-33	NTclustered	gi\|2874254016\|emb\|OY970341.1\|	34034	g31991	i0	94.059	218.26523297491	101	6	36	0	50	150	592693	592593	MAG: uncultured delta proteobacterium isolate MFD01231.bin.c.2 genome assembly, chromosome: 1	blastn	60896	154	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
12404059	12404059	PRJNA944406_P_NODE_7850_length_448_cov_1.402667_g6893_i0	PRJNA944406	7850	448	1.402667	6.28394816	uncultured delta proteobacterium DeepAnt-32C6	357895	Bacteria	Bacteria	656	0	NTclustered	gi\|82617838\|gb\|DQ267496.1\|	357895	g6893	i0	93.439	200.872767857143	442	29	99	0	1	442	3696	3255	Uncultured delta proteobacterium DeepAnt-32C6 fosmid, complete sequence	blastn	89991	656	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium DeepAnt-32C6
12738748	12738748	PRJNA944406_P_NODE_18810_length_303_cov_1.339130_g17851_i0	PRJNA944406	18810	303	1.33913	4.0575639	Bacteria	2	Bacteria	Bacteria	521	1.7899999999999994e-143	NTclustered	gi\|339646371\|gb\|JN038760.1\|	34034	g17851	i0	97.69	98.3267326732673	303	7	100	0	1	303	306	4	Uncultured delta proteobacterium clone MP-R91 16S ribosomal RNA gene, partial sequence	blastn	29793	521	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
13678298	13678298	PRJNA944406_P_NODE_4831_length_594_cov_1.856046_g3895_i0	PRJNA944406	4831	594	1.856046	11.02491324	uncultured delta proteobacterium	34034	Bacteria	Bacteria	549	1.7099999999999994e-151	NTclustered	gi\|2874253888\|emb\|OY970063.1\|	34034	g3895	i0	84.283	207.592592592593	579	74	96	14	1	571	628849	628280	MAG: uncultured delta proteobacterium isolate MFD10007.bin.1.119 genome assembly, chromosome: 1	blastn	123310	549	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
16227191	16227191	PRJNA944406_P_NODE_16653_length_317_cov_1.262295_g15694_i0	PRJNA944406	16653	317	1.262295	4.00147515	uncultured delta proteobacterium	34034	Bacteria	Bacteria	520	6.769999999999999e-143	NTclustered	gi\|375153257\|gb\|JN634103.1\|	34034	g15694	i0	96.795	99.9116719242902	312	8	98	2	7	317	508	198	Uncultured delta proteobacterium clone HM170 16S ribosomal RNA gene, partial sequence	blastn	31672	520	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
17502655	17502655	PRJNA944406_P_NODE_32894_length_279_cov_1.495146_g31935_i0	PRJNA944406	32894	279	1.495146	4.17145734	uncultured delta proteobacterium	34034	Bacteria	Bacteria	261	3.92e-65	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g31935	i0	83.746	306.716845878136	283	38	100	7	1	279	83423	83701	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	85574	261	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
21326295	21326295	PRJNA944406_P_NODE_110557_length_239_cov_3.030120_g109598_i0	PRJNA944406	110557	239	3.03012	7.2419868	uncultured delta proteobacterium	34034	Bacteria	Bacteria	62.1	3.57e-5	NTclustered	gi\|2874254016\|emb\|OY970341.1\|	34034	g109598	i0	97.222	1.11297071129707	36	1	15	0	140	175	3607041	3607006	MAG: uncultured delta proteobacterium isolate MFD01231.bin.c.2 genome assembly, chromosome: 1	blastn	266	62.1	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);;