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

12 rows where analysis = "blastn", bioproject = "PRJNA414225" 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
418971	418971	PRJNA414225_P_NODE_66201_length_165_cov_0.879310_g66114_i0	PRJNA414225	66201	165	0.87931	1.4508615	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	178	2.18e-40	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g66114	i0	86.42	4.89090909090909	162	22	98	0	3	164	1240734	1240895	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	807	178	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
418982	418982	PRJNA414225_P_NODE_70021_length_164_cov_0.904348_g69934_i0	PRJNA414225	70021	164	0.904348	1.48313072	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	159	7.84e-35	NTclustered	gi\|2531976028\|emb\|OY282361.1\|	2910168	g69934	i0	84.81	152.646341463415	158	24	96	0	1	158	903830	903987	MAG: Longimicrobiales bacterium genome assembly, chromosome: 1	blastn	25034	159	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
4245991	4245991	PRJNA414225_P_NODE_4124_length_253_cov_3.220588_g4037_i0	PRJNA414225	4124	253	3.220588	8.14808764	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	206	1.67e-48	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g4037	i0	87.931	12.9367588932806	174	21	69	0	24	197	1903281	1903454	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	3273	206	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
4246066	4246066	PRJNA414225_P_NODE_75724_length_163_cov_2.684211_g75637_i0	PRJNA414225	75724	163	2.684211	4.37526393	uncultured Gemmatimonas sp.	221169	Bacteria	Bacteria	296	5.68e-76	NTclustered	gi\|192805021\|emb\|FM175823.1\|	221169	g75637	i0	100	94.4355828220859	160	0	98	0	4	163	170	11	Uncultured Gemmatimonas sp. partial 16S rRNA gene, clone CL3.D92	blastn	15393	296	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	uncultured Gemmatimonas sp.
8072155	8072155	PRJNA414225_P_NODE_1167_length_381_cov_1.530120_g1081_i0	PRJNA414225	1167	381	1.53012	5.8297572	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	508	1.79e-139	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g1081	i0	90.885	217.076115485564	384	28	100	5	1	381	1594123	1594502	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	82706	508	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8072160	8072160	PRJNA414225_P_NODE_1387_length_353_cov_1.273026_g1300_i0	PRJNA414225	1387	353	1.273026	4.49378178	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	259	1.83e-64	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g1300	i0	86.555	217.875354107649	238	28	93	4	114	350	2605721	2605487	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	76910	259	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8072174	8072174	PRJNA414225_P_NODE_2127_length_301_cov_2.444444_g2040_i0	PRJNA414225	2127	301	2.444444	7.35777644	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	230	1.2099999999999995e-55	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g2040	i0	83.137	292.56146179402	255	39	84	4	12	264	172308	172056	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	88061	230	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
8072175	8072175	PRJNA414225_P_NODE_21927_length_186_cov_1.240876_g21840_i0	PRJNA414225	21927	186	1.240876	2.30802936	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	121	4.3e-23	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g21840	i0	95.946	22.5967741935484	74	3	40	0	5	78	2290477	2290404	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	4203	121	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
14447757	14447757	PRJNA414225_P_NODE_1992_length_309_cov_1.780769_g1905_i0	PRJNA414225	1992	309	1.780769	5.50257621	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	259	1.5800000000000002e-64	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g1905	i0	85.603	329.236245954693	257	26	83	6	8	262	1904097	1904344	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	101734	259	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
14447847	14447847	PRJNA414225_P_NODE_6492_length_230_cov_1.961326_g6405_i0	PRJNA414225	6492	230	1.961326	4.5110498	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	292	1.11e-74	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g6405	i0	89.565	154.739130434783	230	24	100	0	1	230	1592713	1592942	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	35590	292	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
15721618	15721618	PRJNA414225_P_NODE_62593_length_165_cov_1.310345_g62506_i0	PRJNA414225	62593	165	1.310345	2.16206925	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	202	1.29e-47	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g62506	i0	89.157	302.036363636364	166	12	98	6	2	163	1902814	1902977	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	49836	202	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
24645306	24645306	PRJNA414225_P_NODE_2860_length_276_cov_1.964758_g2773_i0	PRJNA414225	2860	276	1.964758	5.42273208	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	171	6.72e-38	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g2773	i0	85.89	326.213768115942	163	20	59	3	114	275	172997	173157	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	90035	171	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);;