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

12 rows where analysis = "blastn", bioproject = "PRJNA473824" and tax_phylum = "Acidobacteriota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
446725	446725	PRJNA473824_P_NODE_20161_length_263_cov_2.539823_g19523_i0	PRJNA473824	20161	263	2.539823	6.67973449	Terriglobus roseus	392734	Bacteria	Bacteria	470	5.59e-128	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g19523	i0	98.859	159.536121673004	263	3	100	0	1	263	928599	928337	Terriglobus roseus DSM 18391, complete genome	blastn	41958	470	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
1721601	1721601	PRJNA473824_P_NODE_29882_length_218_cov_1.508287_g29244_i0	PRJNA473824	29882	218	1.508287	3.28806566	Geothrix sp.	1962974	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2515262989\|gb\|CP126625.1\|	1962974	g29244	i0	96.875	0.146788990825688	32	1	15	0	177	208	1165154	1165123	MAG: Geothrix sp. isolate L227-G1 chromosome, complete genome	blastn	32	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp.
2997747	2997747	PRJNA473824_P_NODE_47763_length_178_cov_3.865248_g47125_i0	PRJNA473824	47763	178	3.865248	6.88014144	Geothrix sp.	1962974	Bacteria	Bacteria	134	5.23e-27	NTclustered	gi\|2515262989\|gb\|CP126625.1\|	1962974	g47125	i0	82.099	4.90449438202247	162	23	89	6	20	178	198372	198530	MAG: Geothrix sp. isolate L227-G1 chromosome, complete genome	blastn	873	134	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp.
4924607	4924607	PRJNA473824_P_NODE_36024_length_201_cov_1.762195_g35386_i0	PRJNA473824	36024	201	1.762195	3.54201195	Edaphobacter	388463	Bacteria	Bacteria	241	3.480000000000001e-59	NTclustered	gi\|112980859\|gb\|DQ829663.1\|	171953	g35386	i0	94.839	234.144278606965	155	6	77	2	48	201	1265	1112	Uncultured Acidobacteria bacterium clone DON10 23S ribosomal RNA gene, partial sequence	blastn	47063	241	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5550875	5550875	PRJNA473824_P_NODE_77885_length_173_cov_3.500000_g77247_i0	PRJNA473824	77885	173	3.5	6.055	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2621704042\|emb\|OY760734.1\|	2910147	g77247	i0	100	0.161849710982659	28	0	16	0	22	49	2936398	2936371	MAG: Vicinamibacterales bacterium isolate 10b48155-431e-4809-9d43-759f23ff96f9 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
6824763	6824763	PRJNA473824_P_NODE_62326_length_173_cov_4.580882_g61688_i0	PRJNA473824	62326	173	4.580882	7.92492586	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	63.9	6.71e-6	NTclustered	gi\|374851660\|dbj\|AP011695.1\|	171953	g61688	i0	93.023	0.855491329479769	43	3	25	0	131	173	15936	15894	Uncultured Acidobacteria bacterium DNA, fosmid clone: JFF017_D01	blastn	148	63.9	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10650992	10650992	PRJNA473824_P_NODE_84989_length_173_cov_3.220588_g84351_i0	PRJNA473824	84989	173	3.220588	5.57161724	Granulicella mallensis	940614	Bacteria	Bacteria	87.9	3.98e-13	NTclustered	gi\|358750971\|gb\|CP003130.1\|	682795	g84351	i0	88.732	3.01156069364162	71	8	41	0	6	76	4313672	4313742	Granulicella mallensis MP5ACTX8 chromosome, complete genome	blastn	521	87.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella mallensis
11925047	11925047	PRJNA473824_P_NODE_143850_length_151_cov_4.587719_g143212_i0	PRJNA473824	143850	151	4.587719	6.92745569	Geothrix sp.	1962974	Bacteria	Bacteria	62.1	2.05e-5	NTclustered	gi\|2515262989\|gb\|CP126625.1\|	1962974	g143212	i0	85	0.649006622516556	60	9	40	0	78	137	2945534	2945475	MAG: Geothrix sp. isolate L227-G1 chromosome, complete genome	blastn	98	62.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp.
13201011	13201011	PRJNA473824_P_NODE_98351_length_173_cov_2.808824_g97713_i0	PRJNA473824	98351	173	2.808824	4.85926552	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	111	2.36e-20	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g97713	i0	93.333	0.433526011560694	75	5	43	0	99	173	3391199	3391125	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	75	111	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23398458	23398458	PRJNA473824_P_NODE_123159_length_167_cov_1.546154_g122521_i0	PRJNA473824	123159	167	1.546154	2.58207718	Terriglobus roseus	392734	Bacteria	Bacteria	276	7.64e-70	NTclustered	gi\|1085637902\|emb\|LT629690.1\|	392734	g122521	i0	96.407	96.8622754491018	167	6	100	0	1	167	4807170	4807004	Terriglobus roseus strain GAS232 genome assembly, chromosome: I	blastn	16176	276	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
23399402	23399402	PRJNA473824_P_NODE_60619_length_173_cov_4.772059_g59981_i0	PRJNA473824	60619	173	4.772059	8.25566207	Tunturiibacter empetritectus	3069691	Bacteria	Bacteria	117	5.08e-22	NTclustered	gi\|2750692779\|gb\|CP132932.1\|	3069691	g59981	i0	97.101	39.3872832369942	69	2	40	0	8	76	2718650	2718582	Tunturiibacter empetritectus strain M8UP23 chromosome	blastn	6814	117	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Tunturiibacter	Tunturiibacter empetritectus
24672928	24672928	PRJNA473824_P_NODE_27900_length_224_cov_7.502674_g27262_i0	PRJNA473824	27900	224	7.502674	16.80598976	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	87.9	5.46e-13	NTclustered	gi\|2814788339\|emb\|OY761475.2\|	2910147	g27262	i0	83	0.446428571428571	100	14	44	3	1	99	6006435	6006532	MAG: Vicinamibacterales bacterium isolate 01def6b1-0c8c-435d-859a-076764f3ef92 genome assembly, chromosome: 1	blastn	100	87.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales 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);;