metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA849172" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA849172" 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
834604	834604	PRJNA849172_P_NODE_119661_length_232_cov_3.421384_g119301_i0	PRJNA849172	119661	232	3.421384	7.93761088	uncultured Gemmatimonadetes bacterium Rifle_16ft_4_minimus_37772	1665097	Bacteria	Bacteria	246	8.869999999999999e-61	NTclustered	gi\|874575674\|gb\|KT007003.1\|	1665097	g119301	i0	85.897	9.86637931034483	234	29	100	4	1	232	43619	43850	Uncultured Gemmatimonadetes bacterium Rifle_16ft_4_minimus_37772 genomic sequence	blastn	2289	246	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					uncultured Gemmatimonadetes bacterium Rifle_16ft_4_minimus_37772
2110868	2110868	PRJNA849172_P_NODE_148002_length_199_cov_4.698413_g147642_i0	PRJNA849172	148002	199	4.698413	9.34984187	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	185	1.6299999999999994e-42	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g147642	i0	92.366	227.386934673367	131	8	65	2	64	193	1904483	1904612	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	45250	185	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
3386040	3386040	PRJNA849172_P_NODE_144403_length_202_cov_13.465116_g144043_i0	PRJNA849172	144403	202	13.465116	27.19953432	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	291	3.42e-74	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g144043	i0	92.611	128.39603960396	203	14	100	1	1	202	1555002	1554800	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	25936	291	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
3387454	3387454	PRJNA849172_P_NODE_56843_length_285_cov_2.202830_g56483_i0	PRJNA849172	56843	285	2.20283	6.2780655	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	243	1.4600000000000004e-59	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g56483	i0	84.19	99.8140350877193	253	36	97	4	23	273	5295804	5296054	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	28447	243	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
3388608	3388608	PRJNA849172_P_NODE_96203_length_248_cov_2.217143_g95843_i0	PRJNA849172	96203	248	2.217143	5.49851464	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	183	7.62e-42	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g95843	i0	83.168	117.116935483871	202	32	100	2	48	248	338770	338570	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	29045	183	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
9762490	9762490	PRJNA849172_P_NODE_114148_length_237_cov_2.750000_g113788_i0	PRJNA849172	114148	237	2.75	6.5175	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	255	1.51e-63	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g113788	i0	87.5	4.66666666666667	224	25	94	3	13	235	2299102	2299323	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	1106	255	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
12315914	12315914	PRJNA849172_P_NODE_5730_length_920_cov_14.962220_g5438_i0	PRJNA849172	5730	920	14.96222	137.652424	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	776	0	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g5438	i0	82.392	85.7239130434783	903	148	97	9	6	901	5001330	5002228	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	78866	776	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
12711721	12711721	PRJNA849172_P_NODE_139250_length_208_cov_6.733333_g138890_i0	PRJNA849172	139250	208	6.733333	14.00533264	FCB group	1783270	Bacteria	Bacteria	183	6.19e-42	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g138890	i0	86.047	68.9086538461538	172	23	83	1	24	195	3220980	3220810	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	14333	183	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
13587888	13587888	PRJNA849172_P_NODE_105931_length_243_cov_2.205882_g105571_i0	PRJNA849172	105931	243	2.205882	5.36029326	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	180	9.63e-41	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g105571	i0	85.799	21.2674897119342	169	24	70	0	75	243	6852778	6852610	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	5168	180	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
14862535	14862535	PRJNA849172_P_NODE_119132_length_232_cov_6.138365_g118772_i0	PRJNA849172	119132	232	6.138365	14.2410068	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	178	3.2799999999999993e-40	NTclustered	gi\|575461033\|gb\|CP007129.1\|	861299	g118772	i0	84.324	0.918103448275862	185	25	79	4	12	194	272921	272739	Gemmatirosa kalamazoonesis strain KBS708 plasmid 1, complete sequence	blastn	213	178	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
14863961	14863961	PRJNA849172_P_NODE_32872_length_358_cov_3.936842_g32513_i0	PRJNA849172	32872	358	3.936842	14.09389436	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	243	1.8700000000000001e-59	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g32513	i0	79.282	1.29608938547486	362	64	100	7	1	358	8364923	8364569	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	464	243	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
17412779	17412779	PRJNA849172_P_NODE_118574_length_233_cov_2.925000_g118214_i0	PRJNA849172	118574	233	2.925	6.81525	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	243	1.1500000000000001e-59	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g118214	i0	86.222	1.93562231759657	225	30	97	1	2	226	5141187	5140964	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	451	243	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
17413065	17413065	PRJNA849172_P_NODE_128554_length_223_cov_33.266667_g128194_i0	PRJNA849172	128554	223	33.266667	74.18466741	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	272	1.3999999999999996e-68	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g128194	i0	88.938	224.618834080717	226	18	100	7	1	223	1904761	1904540	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	50090	272	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
17413344	17413344	PRJNA849172_P_NODE_138794_length_209_cov_4.588235_g138434_i0	PRJNA849172	138794	209	4.588235	9.58941115	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	202	1.7199999999999998e-47	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g138434	i0	84.286	2.35406698564593	210	30	100	3	1	209	4115667	4115460	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	492	202	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
17415724	17415724	PRJNA849172_P_NODE_81934_length_258_cov_1.686486_g81574_i0	PRJNA849172	81934	258	1.686486	4.35113388	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	259	1.29e-64	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g81574	i0	85.214	1.95736434108527	257	32	99	6	2	255	3724349	3724602	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	505	259	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19960567	19960567	PRJNA849172_P_NODE_102136_length_245_cov_1.802326_g101776_i0	PRJNA849172	102136	245	1.802326	4.4156987	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	287	5.57e-73	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g101776	i0	92.157	73.9918367346939	204	14	83	2	43	245	3167220	3167018	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	18128	287	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19960667	19960667	PRJNA849172_P_NODE_106056_length_243_cov_1.835294_g105696_i0	PRJNA849172	106056	243	1.835294	4.45976442	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	191	4.45e-44	NTclustered	gi\|2874254163\|emb\|OY970395.1\|	412054	g105696	i0	81.172	5.57201646090535	239	43	98	2	2	239	3906622	3906385	MAG: uncultured Gemmatimonadales bacterium isolate MFD05684.bin.c.1 genome assembly, chromosome: 1	blastn	1354	191	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19963428	19963428	PRJNA849172_P_NODE_65276_length_275_cov_1.282178_g64916_i0	PRJNA849172	65276	275	1.282178	3.5259895	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	217	8.47e-52	NTclustered	gi\|2893358411\|emb\|OZ220702.1\|	2910168	g64916	i0	81.55	2.85090909090909	271	43	97	7	8	275	2161136	2160870	MAG: Longimicrobiales bacterium isolate 5c038fdb-8e0b-4cbd-9550-43be1afc0bbf genome assembly, chromosome: 1	blastn	784	217	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
21238467	21238467	PRJNA849172_P_NODE_45617_length_309_cov_2.915254_g45257_i0	PRJNA849172	45617	309	2.915254	9.00813486	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	213	1.25e-50	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g45257	i0	78.571	4.09708737864078	308	57	99	6	4	309	3848704	3848404	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	1266	213	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
21239511	21239511	PRJNA849172_P_NODE_80797_length_259_cov_1.768817_g80437_i0	PRJNA849172	80797	259	1.768817	4.58123603	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	124	4.9299999999999996e-24	NTclustered	gi\|575462059\|gb\|CP007130.1\|	861299	g80437	i0	85.246	0.471042471042471	122	16	47	2	129	249	547535	547415	Gemmatirosa kalamazoonesis strain KBS708 plasmid 2, complete sequence	blastn	122	124	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
25060420	25060420	PRJNA849172_P_NODE_10520_length_660_cov_6.991482_g10168_i0	PRJNA849172	10520	660	6.991482	46.1437812	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	411	9.409999999999998e-110	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g10168	i0	78.228	3.89545454545455	666	127	99	15	3	660	2877105	2877760	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	2571	411	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
25062751	25062751	PRJNA849172_P_NODE_50300_length_295_cov_5.563063_g49940_i0	PRJNA849172	50300	295	5.563063	16.41103585	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	462	1.07e-125	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g49940	i0	97.77	119.257627118644	269	5	91	1	1	268	341131	341399	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	35181	462	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium

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