metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJEB48218" and tax

10 rows where analysis = "blastn", bioproject = "PRJEB48218" 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
62621	62621	PRJEB48218_S_NODE_26181_length_168_cov_2.244604_g25219_i0	PRJEB48218	26181	168	2.244604	3.77093472	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	198	1.7099999999999997e-46	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g25219	i0	96.639	213.583333333333	119	4	71	0	50	168	2908804	2908922	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	35882	198	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3888633	3888633	PRJEB48218_S_NODE_24524_length_176_cov_37.367347_g23562_i0	PRJEB48218	24524	176	37.367347	65.76653072	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	206	1.08e-48	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g23562	i0	93.478	20.5454545454545	138	9	78	0	16	153	138	1	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	3616	206	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6440687	6440687	PRJEB48218_S_NODE_24646_length_176_cov_1.816327_g23684_i0	PRJEB48218	24646	176	1.816327	3.19673552	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	111	2.42e-20	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g23684	i0	78.531	2.03409090909091	177	32	99	5	1	174	3943436	3943263	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	358	111	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8989582	8989582	PRJEB48218_S_NODE_19388_length_214_cov_2.005405_g18426_i0	PRJEB48218	19388	214	2.005405	4.2915667	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	174	3.86e-39	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g18426	i0	81.659	8.36448598130841	229	24	100	13	1	214	3176838	3177063	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	1790	174	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
10265183	10265183	PRJEB48218_S_NODE_11989_length_258_cov_5.179039_g11027_i0	PRJEB48218	11989	258	5.179039	13.36192062	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	316	7.539999999999998e-82	NTclustered	gi\|217038899\|gb\|EU810989.1\|	171953	g11027	i0	91.453	121.031007751938	234	15	90	5	24	255	1	231	Uncultured Acidobacteria bacterium clone 01QD9 23S ribosomal RNA gene, partial sequence	blastn	31226	316	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
11540700	11540700	PRJEB48218_S_NODE_20570_length_204_cov_10.057143_g19608_i0	PRJEB48218	20570	204	10.057143	20.51657172	Candidatus Solibacter usitatus	332163	Bacteria	Bacteria	339	1.22e-88	NTclustered	gi\|470468228\|ref\|NR_076103.1\|	332163	g19608	i0	96.569	101.323529411765	204	7	100	0	1	204	738	941	Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence	blastn	20670	339	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter usitatus
16639616	16639616	PRJEB48218_S_NODE_7834_length_340_cov_11759.463023_g6872_i0	PRJEB48218	7834	340	11759.463023	39982.1742782	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	357	6.08e-94	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g6872	i0	95.133	240.808823529412	226	11	66	0	115	340	3301038	3300813	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	81875	357	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
17913958	17913958	PRJEB48218_S_NODE_16535_length_230_cov_30.825871_g15573_i0	PRJEB48218	16535	230	30.825871	70.8995033	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	233	6.83e-57	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g15573	i0	87.019	254.869565217391	208	26	90	1	24	230	3298163	3298370	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	58620	233	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
23014798	23014798	PRJEB48218_S_NODE_7939_length_337_cov_3.159091_g6977_i0	PRJEB48218	7939	337	3.159091	10.64613667	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	339	2.1799999999999997e-88	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g6977	i0	87	171.908011869436	300	39	89	0	38	337	634712	635011	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	57933	339	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
24288244	24288244	PRJEB48218_S_NODE_18980_length_217_cov_2.122340_g18018_i0	PRJEB48218	18980	217	2.12234	4.6054778	Mesoterricola sediminis	2927980	Bacteria	Bacteria	128	3.1e-25	NTclustered	gi\|2490895851\|dbj\|AP027081.1\|	2927980	g18018	i0	81.212	1.50691244239631	165	25	75	6	56	217	3370766	3370927	Mesoterricola sediminis W786 DNA, complete genome	blastn	327	128	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Mesoterricola	Mesoterricola sediminis

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