metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA611476" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA611476" 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
1864844	1864844	PRJNA611476_P_NODE_109602_length_243_cov_0.905882_g108811_i0	PRJNA611476	109602	243	0.905882	2.20129326	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	244	3.37e-60	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g108811	i0	84.774	1.9917695473251	243	37	100	0	1	243	3305000	3304758	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	484	244	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
3139678	3139678	PRJNA611476_P_NODE_101223_length_245_cov_0.895349_g100432_i0	PRJNA611476	101223	245	0.895349	2.19360505	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	250	7.31e-62	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g100432	i0	86.404	37.8163265306122	228	31	93	0	5	232	2159792	2160019	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	9265	250	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
4417528	4417528	PRJNA611476_P_NODE_77444_length_252_cov_1.290503_g76653_i0	PRJNA611476	77444	252	1.290503	3.25206756	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	339	1.57e-88	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g76653	i0	90.98	182.781746031746	255	17	100	5	1	252	3044213	3043962	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	46061	339	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
10793301	10793301	PRJNA611476_P_NODE_14509_length_516_cov_1.386005_g13719_i0	PRJNA611476	14509	516	1.386005	7.1517858	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	547	5.2899999999999985e-151	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g13719	i0	86.148	22.1666666666667	527	49	100	20	1	516	3485982	3485469	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	11438	547	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
13343367	13343367	PRJNA611476_P_NODE_26811_length_393_cov_1.443750_g26020_i0	PRJNA611476	26811	393	1.44375	5.6739375	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	58.4	8.08e-4	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g26020	i0	100	0.0788804071246819	31	0	8	0	227	257	2318158	2318188	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	31	58.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
13344337	13344337	PRJNA611476_P_NODE_97871_length_246_cov_0.890173_g97080_i0	PRJNA611476	97871	246	0.890173	2.18982558	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	405	1.48e-108	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g97080	i0	96.341	11.4105691056911	246	9	100	0	1	246	1495254	1495009	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	2807	405	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
15892967	15892967	PRJNA611476_P_NODE_80713_length_251_cov_0.865169_g79922_i0	PRJNA611476	80713	251	0.865169	2.17157419	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	315	2.6299999999999998e-81	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g79922	i0	89.098	113.159362549801	266	12	99	5	3	251	1903704	1903969	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	28403	315	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
17167631	17167631	PRJNA611476_P_NODE_64014_length_278_cov_1.126829_g63223_i0	PRJNA611476	64014	278	1.126829	3.13258462	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	267	8.389999999999999e-67	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g63223	i0	84.502	4.42446043165468	271	40	97	2	7	276	1938472	1938741	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	1230	267	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19716654	19716654	PRJNA611476_P_NODE_90536_length_248_cov_0.880000_g89745_i0	PRJNA611476	90536	248	0.88	2.1824	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	298	2.61e-76	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g89745	i0	88.353	99.3467741935484	249	27	100	2	1	248	5456321	5456074	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	24638	298	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19716729	19716729	PRJNA611476_P_NODE_95576_length_247_cov_0.885057_g94785_i0	PRJNA611476	95576	247	0.885057	2.18609079	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	231	2.6699999999999997e-56	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g94785	i0	85.153	19.3117408906883	229	30	92	4	21	247	2589247	2589473	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	4770	231	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
20992162	20992162	PRJNA611476_P_NODE_69677_length_267_cov_1.402062_g68886_i0	PRJNA611476	69677	267	1.402062	3.74350554	Gaopeijia maritima	3119007	Bacteria	Bacteria	135	2.36e-27	NTclustered	gi\|2716997671\|gb\|CP144380.1\|	3119007	g68886	i0	84.783	11.0224719101124	138	17	51	4	25	160	1972795	1972660	Gaopeijia maritima strain DH-78 chromosome, complete genome	blastn	2943	135	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Gaopeijiales	Gaopeijiaceae	Gaopeijia	Gaopeijia maritima
20992361	20992361	PRJNA611476_P_NODE_84957_length_250_cov_0.870056_g84166_i0	PRJNA611476	84957	250	0.870056	2.17514	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	377	3.29e-100	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g84166	i0	94	168.64	250	14	100	1	1	250	422763	423011	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	42160	377	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);;