metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA526367" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA526367" 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
4322704	4322704	PRJNA526367_P_NODE_23704_length_324_cov_2.123636_g23495_i0	PRJNA526367	23704	324	2.123636	6.88058064	Pseudogemmatithrix spongiicola	3062599	Bacteria	Bacteria	132	3.8e-26	NTclustered	gi\|2557479348\|gb\|CP130613.1\|	3062599	g23495	i0	98.649	19.4413580246914	74	1	23	0	27	100	2157487	2157560	Pseudogemmatithrix spongiicola strain 318 chromosome, complete genome	blastn	6299	132	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Pseudogemmatithrix	Pseudogemmatithrix spongiicola
6873859	6873859	PRJNA526367_P_NODE_49806_length_167_cov_6.152542_g49596_i0	PRJNA526367	49806	167	6.152542	10.27474514	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	180	6.16e-41	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g49596	i0	87.421	0.952095808383233	159	16	94	3	8	164	4680175	4680331	Gemmatimonas phototrophica strain AP64, complete genome	blastn	159	180	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
13867322	13867322	PRJNA526367_P_NODE_22431_length_324_cov_2.232727_g22222_i0	PRJNA526367	22431	324	2.232727	7.23403548	Gemmatimonas	173479	Bacteria	Bacteria	185	2.88e-42	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g22222	i0	100	68.0246913580247	100	0	60	0	1	100	2480	2381	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	22040	185	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
13867540	13867540	PRJNA526367_P_NODE_35891_length_190_cov_5.354610_g35681_i0	PRJNA526367	35891	190	5.35461	10.173759	Gemmatimonas	173479	Bacteria	Bacteria	217	5.469999999999999e-52	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g35681	i0	88.764	8.74210526315789	178	18	93	2	1	177	1319	1495	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	1661	217	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
14524720	14524720	PRJNA526367_P_NODE_22272_length_324_cov_2.247273_g22063_i0	PRJNA526367	22272	324	2.247273	7.28116452	Gemmatirosa kalamazoonensis	861299	Bacteria	Bacteria	117	1.06e-21	NTclustered	gi\|575456455\|gb\|CP007128.1\|	861299	g22063	i0	89.362	0.867283950617284	94	8	29	2	227	319	3045172	3045264	Gemmatirosa kalamazoonesis strain KBS708, complete genome	blastn	281	117	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa kalamazoonensis
15798727	15798727	PRJNA526367_P_NODE_43533_length_177_cov_2.085938_g43323_i0	PRJNA526367	43533	177	2.085938	3.69211026	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	230	6.439999999999999e-56	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g43323	i0	90.751	11.9717514124294	173	15	97	1	6	177	6466279	6466107	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	2119	230	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16416436	16416436	PRJNA526367_P_NODE_34353_length_207_cov_5.911392_g34143_i0	PRJNA526367	34353	207	5.911392	12.23658144	Gemmatimonas	173479	Bacteria	Bacteria	147	8.08e-31	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g34143	i0	79.902	4.71497584541063	204	38	98	3	1	202	400	198	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	976	147	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
18965203	18965203	PRJNA526367_P_NODE_29855_length_324_cov_1.483636_g29646_i0	PRJNA526367	29855	324	1.483636	4.80698064	Gemmatimonas	173479	Bacteria	Bacteria	165	3.75e-36	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g29646	i0	96.939	8	98	3	30	0	227	324	389	486	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	2592	165	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca

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