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

20 rows where analysis = "blastn", bioproject = "PRJNA946307" 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
925661	925661	PRJNA946307_P_NODE_11001_length_402_cov_4.070822_g10142_i0	PRJNA946307	11001	402	4.070822	16.36470444	Dissulfurimicrobium hydrothermale	1750598	Bacteria	Bacteria	137	1.03e-27	NTclustered	gi\|2190143862\|gb\|CP085041.1\|	1750598	g10142	i0	82.895	12.271144278607	152	26	38	0	123	274	311534	311685	Dissulfurimicrobium hydrothermale strain Sh68 chromosome, complete genome	blastn	4933	137	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			Dissulfurimicrobium	Dissulfurimicrobium hydrothermale
2201852	2201852	PRJNA946307_P_NODE_16222_length_320_cov_2.453875_g15351_i0	PRJNA946307	16222	320	2.453875	7.8524	uncultured delta proteobacterium	34034	Bacteria	Bacteria	372	2.03e-98	NTclustered	gi\|374854163\|dbj\|AP011765.1\|	34034	g15351	i0	88.562	136.44375	306	35	96	0	1	306	13367	13062	Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12	blastn	43662	372	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
2202015	2202015	PRJNA946307_P_NODE_17202_length_310_cov_2.674330_g16331_i0	PRJNA946307	17202	310	2.67433	8.290423	Bradymonas sediminis	1548548	Bacteria	Bacteria	416	8.91e-112	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g16331	i0	93.448	70.058064516129	290	3	95	3	15	304	95611	95884	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	21718	416	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
2535619	2535619	PRJNA946307_P_NODE_123642_length_173_cov_3.451613_g122768_i0	PRJNA946307	123642	173	3.451613	5.97129049	Bacteria	2	Bacteria	Bacteria	176	8.26e-40	NTclustered	gi\|219811383\|gb\|FJ551597.1\|	34034	g122768	i0	94.737	71.0231213872832	114	4	65	1	15	126	920	1033	Uncultured delta proteobacterium clone LTSP_BACT_P3O04 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	12287	176	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
2536665	2536665	PRJNA946307_P_NODE_84602_length_191_cov_2.316901_g83728_i0	PRJNA946307	84602	191	2.316901	4.42528091	Bacillota	1239	Bacteria	Bacteria	163	7.27e-36	NTclustered	gi\|2190143862\|gb\|CP085041.1\|	1750598	g83728	i0	96.907	1.03141361256544	97	3	51	0	92	188	1870427	1870523	Dissulfurimicrobium hydrothermale strain Sh68 chromosome, complete genome	blastn	197	163	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria			Dissulfurimicrobium	Dissulfurimicrobium hydrothermale
8913208	8913208	PRJNA946307_P_NODE_28727_length_241_cov_10.973958_g27853_i0	PRJNA946307	28727	241	10.973958	26.44723878	Bacteria	2	Bacteria	Bacteria	388	1.46e-103	NTclustered	gi\|148749607\|gb\|EF636480.1\|	34034	g27853	i0	100	86.9004149377593	210	0	87	0	32	241	180	389	Uncultured delta proteobacterium isolate DGGE gel band 9 16S ribosomal RNA gene, partial sequence	blastn	20943	388	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
9855964	9855964	PRJNA946307_P_NODE_82108_length_192_cov_3.307692_g81234_i0	PRJNA946307	82108	192	3.307692	6.35076864	uncultured delta proteobacterium HF0070_10I02	710824	Bacteria	Bacteria	252	1.52e-62	NTclustered	gi\|297181000\|gb\|GU474857.1\|	710824	g81234	i0	93.023	150.359375	172	12	90	0	7	178	6821	6650	Uncultured delta proteobacterium HF0070_10I02 genomic sequence	blastn	28869	252	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium HF0070_10I02
10189371	10189371	PRJNA946307_P_NODE_51648_length_210_cov_3.310559_g50774_i0	PRJNA946307	51648	210	3.310559	6.9521739	Bacteria	2	Bacteria	Bacteria	185	1.74e-42	NTclustered	gi\|892164907\|gb\|KT182521.1\|	34034	g50774	i0	100	59.2142857142857	100	0	89	0	111	210	762	861	Uncultured delta proteobacterium clone MBR Cr 0.4ppm 24 16S ribosomal RNA gene, partial sequence	blastn	12435	185	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
11129164	11129164	PRJNA946307_P_NODE_100329_length_184_cov_1.481481_g99455_i0	PRJNA946307	100329	184	1.481481	2.72592504	Bradymonas sediminis	1548548	Bacteria	Bacteria	303	3.92e-78	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g99455	i0	99.401	0.907608695652174	167	1	91	0	15	181	2294403	2294237	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	167	303	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
12405418	12405418	PRJNA946307_P_NODE_143310_length_166_cov_2.444444_g142436_i0	PRJNA946307	143310	166	2.444444	4.05777704	uncultured delta proteobacterium	34034	Bacteria	Bacteria	259	7.63e-65	NTclustered	gi\|451917356\|gb\|KC451220.1\|	34034	g142436	i0	97.368	61.1927710843374	152	4	92	0	3	154	314	163	Uncultured delta proteobacterium clone RLBp2603 16S ribosomal RNA gene, partial sequence	blastn	10158	259	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
14955777	14955777	PRJNA946307_P_NODE_76492_length_196_cov_4.421769_g75618_i0	PRJNA946307	76492	196	4.421769	8.66666724	Deltaproteobacteria bacterium Smac51	2946587	Bacteria	Bacteria	152	1.6199999999999998e-32	NTclustered	gi\|2242725236\|gb\|CP026657.1\|	2946587	g75618	i0	84.416	280.122448979592	154	24	79	0	41	194	2066818	2066665	Deltaproteobacteria bacterium Smac51 chromosome, complete genome	blastn	54904	152	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium Smac51
19111950	19111950	PRJNA946307_P_NODE_40755_length_212_cov_3.441718_g39881_i0	PRJNA946307	40755	212	3.441718	7.29644216	Bacteria	2	Bacteria	Bacteria	102	1.82e-17	NTclustered	gi\|297181813\|gb\|GU474879.1\|	710831	g39881	i0	86.813	0.905660377358491	91	12	43	0	26	116	14823	14733	Uncultured delta proteobacterium HF0200_19J16 genomic sequence	blastn	192	102	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium HF0200_19J16
20387319	20387319	PRJNA946307_P_NODE_92456_length_187_cov_3.818841_g91582_i0	PRJNA946307	92456	187	3.818841	7.14123267	Bacteria	2	Bacteria	Bacteria	303	4e-78	NTclustered	gi\|927354472\|gb\|KT323006.1\|	34034	g91582	i0	97.727	93.2459893048128	176	4	94	0	1	176	178	3	Uncultured delta proteobacterium clone TGR_WLFZ-826 16S ribosomal RNA gene, partial sequence	blastn	17437	303	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
22603104	22603104	PRJNA946307_P_NODE_129798_length_171_cov_1.532787_g128924_i0	PRJNA946307	129798	171	1.532787	2.62106577	uncultured delta proteobacterium	34034	Bacteria	Bacteria	110	8.38e-20	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g128924	i0	80.405	0.865497076023392	148	25	85	4	5	150	544477	544332	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	148	110	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
22605005	22605005	PRJNA946307_P_NODE_81978_length_192_cov_3.839161_g81104_i0	PRJNA946307	81978	192	3.839161	7.37118912	Bradymonas sediminis	1548548	Bacteria	Bacteria	329	6.82e-86	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g81104	i0	100	143.619791666667	178	0	93	0	2	179	97338	97161	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	27575	329	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
22937858	22937858	PRJNA946307_P_NODE_151398_length_164_cov_2.547826_g150524_i0	PRJNA946307	151398	164	2.547826	4.17843464	Bacteria	2	Bacteria	Bacteria	267	4.49e-67	NTclustered	gi\|511202453\|gb\|KC994684.1\|	34034	g150524	i0	98.052	92.109756097561	154	2	93	1	1	153	282	129	Uncultured delta proteobacterium clone BF 004 16S ribosomal RNA gene, partial sequence	blastn	15106	267	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
22938262	22938262	PRJNA946307_P_NODE_35318_length_221_cov_18.406977_g34444_i0	PRJNA946307	35318	221	18.406977	40.67941917	Bacteria	2	Bacteria	Bacteria	219	1.82e-52	NTclustered	gi\|354462782\|gb\|JN697180.1\|	34034	g34444	i0	98.387	59.1809954751131	124	2	56	0	84	207	428	305	Uncultured delta proteobacterium clone OM75 16S ribosomal RNA gene, partial sequence	blastn	13079	220	0.995454545454545	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
22938278	22938278	PRJNA946307_P_NODE_37078_length_217_cov_3.773810_g36204_i0	PRJNA946307	37078	217	3.77381	8.1891677	root	1	Root_unresolved	Root_unresolved	357	3.63e-94	NTclustered	gi\|306491434\|gb\|GU179675.1\|	34034	g36204	i0	98.515	94.705069124424	202	3	93	0	2	203	775	574	Uncultured delta proteobacterium clone D009012J13 16S ribosomal RNA gene, partial sequence	blastn	20551	359	0.994428969359331	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
24212583	24212583	PRJNA946307_P_NODE_83819_length_191_cov_4.753521_g82945_i0	PRJNA946307	83819	191	4.753521	9.07922511	Bacteria	2	Bacteria	Bacteria	315	1.9e-81	NTclustered	gi\|383932333\|gb\|JN981954.1\|	34034	g82945	i0	98.333	89.1047120418848	180	2	94	1	1	179	313	134	Uncultured delta proteobacterium clone OTU-20_BFBA 16S ribosomal RNA gene, partial sequence	blastn	17019	316	0.996835443037975	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
25153370	25153370	PRJNA946307_P_NODE_40100_length_212_cov_6.668712_g39226_i0	PRJNA946307	40100	212	6.668712	14.13766944	uncultured delta proteobacterium	34034	Bacteria	Bacteria	235	1.72e-57	NTclustered	gi\|451917203\|gb\|KC451067.1\|	34034	g39226	i0	87.94	47.8584905660377	199	24	94	0	13	211	89	287	Uncultured delta proteobacterium clone RLBp211 16S ribosomal RNA gene, partial sequence	blastn	10146	235	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);;