metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA429937" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA429937" and tax_phylum = "Gemmatimonadota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
427310	427310	PRJNA429937_P_NODE_72421_length_393_cov_4.403846_g50605_i0	PRJNA429937	72421	393	4.403846	17.30711478	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	396	1.51e-105	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g50605	i0	85.309	101.913486005089	388	52	98	5	1	385	752134	752519	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	40052	396	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
2976293	2976293	PRJNA429937_P_NODE_110343_length_273_cov_4.766393_g87721_i0	PRJNA429937	110343	273	4.766393	13.01225289	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	278	3.8e-70	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g87721	i0	85.199	57.8608058608059	277	34	100	7	1	273	1101650	1101923	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	15796	278	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
2977144	2977144	PRJNA429937_P_NODE_31083_length_652_cov_7.662921_g18959_i0	PRJNA429937	31083	652	7.662921	49.96224492	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	486	1.5e-132	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g18959	i0	86.667	59.3726993865031	450	46	69	12	28	474	3042943	3042505	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	38711	486	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
6805143	6805143	PRJNA429937_P_NODE_77926_length_373_cov_3.101744_g55653_i0	PRJNA429937	77926	373	3.101744	11.56950512	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	87.9	9.73e-13	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g55653	i0	93.333	0.160857908847185	60	3	16	1	56	115	3507559	3507501	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	60	87.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
6805284	6805284	PRJNA429937_P_NODE_86486_length_345_cov_2.205696_g63938_i0	PRJNA429937	86486	345	2.205696	7.6096512	uncultured Gemmatimonadaceae bacterium	246130	Bacteria	Bacteria	113	1.48e-20	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g63938	i0	84.167	28.1188405797101	120	15	34	4	223	340	3082163	3082046	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	9701	113	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
8079045	8079045	PRJNA429937_P_NODE_120207_length_248_cov_1.684932_g97581_i0	PRJNA429937	120207	248	1.684932	4.17863136	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	91.6	4.75e-14	NTclustered	gi\|2108314823\|gb\|CP070670.1\|	2026742	g97581	i0	94.828	12.9798387096774	58	3	23	0	86	143	1009394	1009451	MAG: Gemmatimonadetes bacterium isolate bin741 chromosome	blastn	3219	91.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
8079357	8079357	PRJNA429937_P_NODE_154587_length_165_cov_1.823529_g131960_i0	PRJNA429937	154587	165	1.823529	3.00882285	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	172	1.02e-38	NTclustered	gi\|2874254163\|emb\|OY970395.1\|	412054	g131960	i0	85.542	91.4727272727273	166	22	100	2	1	165	3369770	3369934	MAG: uncultured Gemmatimonadales bacterium isolate MFD05684.bin.c.1 genome assembly, chromosome: 1	blastn	15093	172	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
10015471	10015471	PRJNA429937_P_NODE_150468_length_180_cov_2.993377_g127841_i0	PRJNA429937	150468	180	2.993377	5.3880786	FCB group	1783270	Bacteria	Bacteria	207	3.08e-49	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g127841	i0	88.757	90.9777777777778	169	19	94	0	7	175	1445991	1445823	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	16376	207	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
10630389	10630389	PRJNA429937_P_NODE_33289_length_629_cov_2.918333_g20506_i0	PRJNA429937	33289	629	2.918333	18.35631457	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	87.9	1.71e-12	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g20506	i0	93.333	0.095389507154213	60	3	10	1	56	115	3507559	3507501	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	60	87.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
12566488	12566488	PRJNA429937_P_NODE_63170_length_432_cov_3.503722_g32814_i6	PRJNA429937	63170	432	3.503722	15.13607904	Pseudomonadati	3379134	Bacteria	Bacteria	62.1	6.93e-5	NTclustered	gi\|575461033\|gb\|CP007129.1\|	861299	g32814	i6	95	1.33101851851852	40	1	9	1	4	42	984589	984550	Gemmatirosa kalamazoonesis strain KBS708 plasmid 1, complete sequence	blastn	575	62.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
13181273	13181273	PRJNA429937_P_NODE_8911_length_1201_cov_7.524744_g5247_i0	PRJNA429937	8911	1201	7.524744	90.37217544	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	885	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g5247	i0	89.437	107.751873438801	710	63	91	12	94	795	3043861	3043156	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	129410	885	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
15728543	15728543	PRJNA429937_P_NODE_13653_length_991_cov_5.138254_g5247_i1	PRJNA429937	13653	991	5.138254	50.92009714	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	785	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g5247	i1	89.711	118.562058526741	622	55	62	9	282	898	3043244	3043861	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	117495	785	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
16390228	16390228	PRJNA429937_P_NODE_74433_length_385_cov_10.946629_g52415_i0	PRJNA429937	74433	385	10.946629	42.14452165	Gemmatirosa	1706036	Bacteria	Bacteria	401	3.169999999999999e-107	NTclustered	gi\|2874253995\|emb\|OY970320.1\|	246130	g52415	i0	86.154	98.8051948051948	390	32	100	13	1	385	232053	231681	MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1	blastn	38040	403	0.995037220843672	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		uncultured Gemmatimonadaceae bacterium
18277303	18277303	PRJNA429937_P_NODE_113475_length_265_cov_3.470339_g90852_i0	PRJNA429937	113475	265	3.470339	9.19639835	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	58.4	5.21e-4	NTclustered	gi\|2108151088\|gb\|CP070722.1\|	2026742	g90852	i0	94.595	0.139622641509434	37	2	14	0	185	221	383548	383584	MAG: Gemmatimonadetes bacterium isolate bin464 chromosome	blastn	37	58.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
18278135	18278135	PRJNA429937_P_NODE_32615_length_635_cov_7.599010_g20027_i0	PRJNA429937	32615	635	7.59901	48.2537135	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	486	1.4599999999999997e-132	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g20027	i0	86.667	60.9527559055118	450	46	70	12	28	474	3042943	3042505	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	38705	486	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
24652654	24652654	PRJNA429937_P_NODE_26580_length_710_cov_6.317181_g5247_i5	PRJNA429937	26580	710	6.317181	44.8519851	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	808	0	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g5247	i5	90.338	161.825352112676	621	53	87	7	94	710	3043861	3043244	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	114896	808	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
24652918	24652918	PRJNA429937_P_NODE_37220_length_592_cov_6.822380_g5247_i6	PRJNA429937	37220	592	6.82238	40.3884896	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	503	1.3399999999999996e-137	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g5247	i6	88.571	62.6570945945946	420	41	80	7	177	592	3043861	3043445	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	37093	503	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
24653650	24653650	PRJNA429937_P_NODE_75780_length_380_cov_11.393162_g53643_i0	PRJNA429937	75780	380	11.393162	43.2940156	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	398	4.0399999999999992e-106	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g53643	i0	86.34	85.5315789473684	388	26	100	16	1	380	3042727	3043095	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	32502	398	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis

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