metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA493827" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA493827" 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
471643	471643	PRJNA493827_P_NODE_197001_length_248_cov_2.182857_g194803_i0	PRJNA493827	197001	248	2.182857	5.41348536	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	126	1.2999999999999998e-24	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g194803	i0	96.104	26.4193548387097	77	3	31	0	172	248	155536	155460	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	6552	126	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
4299135	4299135	PRJNA493827_P_NODE_232904_length_241_cov_0.916667_g230706_i0	PRJNA493827	232904	241	0.916667	2.20916747	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	396	8.7e-106	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g230706	i0	96.311	89.8630705394191	244	4	100	4	1	241	801389	801630	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	21657	396	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
6849383	6849383	PRJNA493827_P_NODE_207966_length_246_cov_0.890173_g205768_i0	PRJNA493827	207966	246	0.890173	2.18982558	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	239	1.59e-58	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g205768	i0	84.211	47.8536585365854	247	37	100	2	1	246	161719	161964	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	11772	239	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
6849790	6849790	PRJNA493827_P_NODE_227386_length_242_cov_0.911243_g225188_i0	PRJNA493827	227386	242	0.911243	2.20520806	Gemmatimonas aurantiaca	173480	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|226088597\|dbj\|AP009153.1\|	379066	g225188	i0	100	1	242	0	100	0	1	242	3923489	3923730	Gemmatimonas aurantiaca T-27 DNA, complete genome	blastn	242	448	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
6851894	6851894	PRJNA493827_P_NODE_93566_length_355_cov_0.804965_g91368_i0	PRJNA493827	93566	355	0.804965	2.85762575	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	171	8.89e-38	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g91368	i0	76.638	11.9295774647887	351	57	99	12	6	355	156855	157181	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	4235	171	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8123079	8123079	PRJNA493827_P_NODE_124967_length_306_cov_1.008584_g122769_i0	PRJNA493827	124967	306	1.008584	3.08626704	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	357	5.4e-94	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g122769	i0	90.545	89.2843137254902	275	19	89	7	1	271	1904724	1904453	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	27321	357	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8123275	8123275	PRJNA493827_P_NODE_133987_length_295_cov_1.387387_g131789_i0	PRJNA493827	133987	295	1.387387	4.09279165	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	405	1.82e-108	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g131789	i0	91.304	75.4237288135593	299	22	100	4	1	295	801159	801457	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	22250	405	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8123785	8123785	PRJNA493827_P_NODE_157227_length_273_cov_1.540000_g155029_i0	PRJNA493827	157227	273	1.54	4.2042	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	248	2.98e-61	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g155029	i0	89	34.2307692307692	200	22	73	0	42	241	3685207	3685008	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	9345	248	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
8125375	8125375	PRJNA493827_P_NODE_232467_length_241_cov_0.916667_g230269_i0	PRJNA493827	232467	241	0.916667	2.20916747	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	335	1.9199999999999993e-87	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g230269	i0	91.77	52.4107883817427	243	16	100	4	1	241	172936	172696	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	12631	335	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
9398402	9398402	PRJNA493827_P_NODE_138768_length_290_cov_1.142857_g136570_i0	PRJNA493827	138768	290	1.142857	3.3142853	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	425	1.37e-114	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g136570	i0	93.151	662.534482758621	292	17	100	3	1	290	1103058	1103348	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	192135	425	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
9399443	9399443	PRJNA493827_P_NODE_188028_length_250_cov_1.740113_g185830_i0	PRJNA493827	188028	250	1.740113	4.3502825	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	326	1.21e-84	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g185830	i0	90.323	172.16	248	24	99	0	3	250	1104161	1104408	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	43040	326	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
11308932	11308932	PRJNA493827_P_NODE_48949_length_511_cov_2.413242_g46759_i0	PRJNA493827	48949	511	2.413242	12.33166662	Gemmatimonas	173479	Bacteria	Bacteria	715	0	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g46759	i0	91.977	57.3737769080235	511	39	99	2	2	511	530	21	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	29318	721	0.991678224687933	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
23423037	23423037	PRJNA493827_P_NODE_151859_length_278_cov_1.243902_g149661_i0	PRJNA493827	151859	278	1.243902	3.45804756	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	396	1.03e-105	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g149661	i0	92.701	257.158273381295	274	20	99	0	1	274	1552747	1553020	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	71490	396	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola

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