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

15 rows where analysis = "blastn", bioproject = "PRJNA1237347" 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
338612	338612	PRJNA1237347_P_NODE_209601_length_420_cov_2.100865_g203029_i0	PRJNA1237347	209601	420	2.100865	8.823633	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	281	4.74e-71	NTclustered	gi\|2874254163\|emb\|OY970395.1\|	412054	g203029	i0	81.232	1.21904761904762	357	59	84	8	46	398	2800429	2800077	MAG: uncultured Gemmatimonadales bacterium isolate MFD05684.bin.c.1 genome assembly, chromosome: 1	blastn	512	281	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
1618875	1618875	PRJNA1237347_P_NODE_494082_length_248_cov_1.622857_g487509_i0	PRJNA1237347	494082	248	1.622857	4.02468536	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	76.8	1.33e-9	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g487509	i0	97.727	0.55241935483871	44	1	18	0	28	71	993151	993108	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	137	76.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
1618998	1618998	PRJNA1237347_P_NODE_501342_length_247_cov_1.994253_g494769_i0	PRJNA1237347	501342	247	1.994253	4.92580491	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	62.1	3.71e-5	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g494769	i0	92.857	0.615384615384615	42	3	17	0	206	247	2616025	2616066	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	152	62.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
8700540	8700540	PRJNA1237347_P_NODE_16827_length_1934_cov_14.937131_g14632_i0	PRJNA1237347	16827	1934	14.937131	288.88411354	Gemmatimonas	173479	Bacteria	Bacteria	1912	0	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g14632	i0	85.63	149.880558428128	1865	216	95	43	97	1933	2	1842	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	289869	1912	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
9266976	9266976	PRJNA1237347_P_NODE_21948_length_1683_cov_11.121739_g14632_i1	PRJNA1237347	21948	1683	11.121739	187.17886737	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	1899	0	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g14632	i1	87.169	316.765894236482	1699	185	99	30	3	1683	1552290	1553973	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	533117	1899	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
9271583	9271583	PRJNA1237347_P_NODE_452628_length_258_cov_1.621622_g446055_i0	PRJNA1237347	452628	258	1.621622	4.18378476	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	281	2.75e-71	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g446055	i0	88.696	33.0193798449612	230	26	89	0	29	258	1949716	1949945	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	8519	281	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
10543787	10543787	PRJNA1237347_P_NODE_262089_length_364_cov_0.948454_g255516_i0	PRJNA1237347	262089	364	0.948454	3.45237256	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	115	4.34e-21	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g255516	i0	81.379	20.8434065934066	145	23	39	4	3	145	2191888	2192030	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	7587	115	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
13094184	13094184	PRJNA1237347_P_NODE_296671_length_336_cov_1.847909_g290098_i0	PRJNA1237347	296671	336	1.847909	6.20897424	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	211	4.94e-50	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g290098	i0	84.404	56.4761904761905	218	30	64	4	5	220	113206	112991	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	18976	211	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
15644307	15644307	PRJNA1237347_P_NODE_342053_length_308_cov_0.974468_g335480_i0	PRJNA1237347	342053	308	0.974468	3.00136144	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g335480	i0	89.13	0.149350649350649	46	1	15	3	187	231	1758557	1758515	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	46	54.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
15644610	15644610	PRJNA1237347_P_NODE_358313_length_299_cov_1.022124_g351740_i0	PRJNA1237347	358313	299	1.022124	3.05615076	Gaopeijia maritima	3119007	Bacteria	Bacteria	294	4.18e-75	NTclustered	gi\|2716997671\|gb\|CP144380.1\|	3119007	g351740	i0	84.797	139.936454849498	296	41	98	4	5	298	472335	472042	Gaopeijia maritima strain DH-78 chromosome, complete genome	blastn	41841	294	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Gaopeijiales	Gaopeijiaceae	Gaopeijia	Gaopeijia maritima
16918594	16918594	PRJNA1237347_P_NODE_349094_length_304_cov_0.995671_g342521_i0	PRJNA1237347	349094	304	0.995671	3.02683984	Gemmatimonas aurantiaca	173480	Bacteria	Bacteria	270	7.18e-68	NTclustered	gi\|226088597\|dbj\|AP009153.1\|	379066	g342521	i0	83.113	78.2368421052632	302	46	99	4	4	304	3607947	3608244	Gemmatimonas aurantiaca T-27 DNA, complete genome	blastn	23784	270	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
19469290	19469290	PRJNA1237347_P_NODE_438016_length_264_cov_1.376963_g431443_i0	PRJNA1237347	438016	264	1.376963	3.63518232	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	243	1.33e-59	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g431443	i0	83.588	3.46969696969697	262	39	98	4	5	264	7540176	7539917	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	916	243	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19472213	19472213	PRJNA1237347_P_NODE_79456_length_790_cov_1.694561_g73374_i0	PRJNA1237347	79456	790	1.694561	13.3870319	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	1027	0	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g73374	i0	90.176	128.559493670886	794	71	100	7	1	790	1552989	1553779	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	101562	1027	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
20742277	20742277	PRJNA1237347_P_NODE_313657_length_325_cov_1.134921_g307084_i0	PRJNA1237347	313657	325	1.134921	3.68849325	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g307084	i0	94.286	0.215384615384615	35	2	11	0	264	298	2729612	2729578	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	70	54.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
23296757	23296757	PRJNA1237347_P_NODE_500039_length_248_cov_0.880000_g493466_i0	PRJNA1237347	500039	248	0.88	2.1824	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	193	1.27e-44	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g493466	i0	82.87	1.67338709677419	216	36	87	1	1	215	4164226	4164441	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	415	193	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);;