metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1233465" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1233465" 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
25551488	25551488	PRJNA1233465f_S_NODE_106889_length_232_cov_2.103825_g104609_i0	PRJNA1233465	106889	232	2.103825	4.880874	uncultured delta proteobacterium	34034	Bacteria	Bacteria	69.4	2.06e-7	NTclustered	gi\|310755693\|gb\|HQ213583.1\|	34034	g104609	i0	95.455	30.2456896551724	44	0	18	2	191	232	506	463	Uncultured delta proteobacterium clone 4_H06 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	7017	69.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
25622384	25622384	PRJNA1233465e_S_NODE_66689_length_228_cov_1.413408_g65379_i0	PRJNA1233465	66689	228	1.413408	3.22257024	delta/epsilon subdivisions	68525	Bacteria	Bacteria	65.8	2.61e-6	NTclustered	gi\|478214010\|gb\|JX473220.1\|	34034	g65379	i0	100	15.5570175438596	35	0	15	0	194	228	730	696	Uncultured delta proteobacterium clone URO246.D08 16S ribosomal RNA gene, partial sequence	blastn	3547	65.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
25673765	25673765	PRJNA1233465b_S_NODE_216682_length_202_cov_1.869281_g214997_i0	PRJNA1233465	216682	202	1.869281	3.77594762	Persicimonas caeni	2292766	Bacteria	Bacteria	115	2.2100000000000003e-21	NTclustered	gi\|1695542189\|gb\|CP041186.1\|	2292766	g214997	i0	91.566	2.02475247524752	83	7	41	0	101	183	6672802	6672720	Persicimonas caeni strain YN101 chromosome	blastn	409	115	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
25759491	25759491	PRJNA1233465f_S_NODE_172562_length_189_cov_1.400000_g170282_i0	PRJNA1233465	172562	189	1.4	2.646	Bacteria	2	Bacteria	Bacteria	67.6	5.79e-7	NTclustered	gi\|310755693\|gb\|HQ213583.1\|	34034	g170282	i0	100	28.973544973545	36	0	19	0	154	189	496	461	Uncultured delta proteobacterium clone 4_H06 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	5476	67.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
26030902	26030902	PRJNA1233465e_S_NODE_85764_length_205_cov_1.589744_g84454_i0	PRJNA1233465	85764	205	1.589744	3.2589752	Bacteria	2	Bacteria	Bacteria	65.8	2.3e-6	NTclustered	gi\|310755693\|gb\|HQ213583.1\|	34034	g84454	i0	100	25.819512195122	35	0	17	0	171	205	496	462	Uncultured delta proteobacterium clone 4_H06 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	5293	65.8	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
26031388	26031388	PRJNA1233465f_S_NODE_161580_length_194_cov_2.075862_g159300_i0	PRJNA1233465	161580	194	2.075862	4.02717228	root	1	Root_unresolved	Root_unresolved	80.5	7.68e-11	NTclustered	gi\|33188051\|gb\|AY330669.1\|	34034	g159300	i0	94.34	29.7474226804124	53	1	27	1	142	194	372	322	Uncultured delta proteobacterium clone A8 16S ribosomal RNA gene, partial sequence	blastn	5771	80.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
26032435	26032435	PRJNA1233465f_S_NODE_87732_length_252_cov_53.354680_g85452_i0	PRJNA1233465	87732	252	53.35468	134.4537936	Bacteria	2	Bacteria	Bacteria	104	6.22e-18	NTclustered	gi\|2874253659\|emb\|OY969087.1\|	34034	g85452	i0	96.774	31.8849206349206	62	2	25	0	191	252	1499359	1499298	MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1	blastn	8035	104	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
26165820	26165820	PRJNA1233465d_S_NODE_41981_length_261_cov_513.655660_g40870_i0	PRJNA1233465	41981	261	513.65566	1340.6412726	Bacteria	2	Bacteria	Bacteria	124	4.969999999999999e-24	NTclustered	gi\|283483223\|emb\|AM404374.1\|	34034	g40870	i0	95.062	37.6436781609195	81	1	30	2	184	261	1429	1349	Uncultured delta proteobacterium partial 16S rRNA gene, clone GoM_SMBush4593_Bac49	blastn	9825	124	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
26302946	26302946	PRJNA1233465f_S_NODE_104710_length_234_cov_2.605405_g102430_i0	PRJNA1233465	104710	234	2.605405	6.0966477	root	1	Root_unresolved	Root_unresolved	56.5	0.002	NTclustered	gi\|2237346561\|emb\|OW761899.1\|	34034	g102430	i0	100	12.6794871794872	30	0	13	0	186	215	17	46	uncultured delta proteobacterium DNA containing 16S-23S intergenic spacer region, clone 43	blastn	2967	56.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
26514163	26514163	PRJNA1233465f_S_NODE_95600_length_243_cov_65.608247_g93320_i0	PRJNA1233465	95600	243	65.608247	159.42804021	uncultured delta proteobacterium	34034	Bacteria	Bacteria	104	5.96e-18	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g93320	i0	92	35.6954732510288	75	4	31	1	169	243	84555	84627	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	8674	104	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);;