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

8 rows where analysis = "blastn", bioproject = "PRJNA797475" 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
2057138	2057138	PRJNA797475_P_NODE_10982_length_319_cov_1.252033_g10883_i0	PRJNA797475	10982	319	1.252033	3.99398527	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	496	1.15e-135	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g10883	i0	94.671	104.282131661442	319	17	100	0	1	319	3556405	3556723	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	33266	496	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
7159718	7159718	PRJNA797475_P_NODE_16806_length_274_cov_1.522388_g16707_i0	PRJNA797475	16806	274	1.522388	4.17134312	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	438	1.6499999999999995e-118	NTclustered	gi\|76574293\|gb\|DQ139441.1\|	171953	g16707	i0	95.62	101.737226277372	274	10	100	2	1	274	632	903	Uncultured Acidobacteria bacterium clone CAL1 23S ribosomal RNA gene, partial sequence	blastn	27876	438	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9709616	9709616	PRJNA797475_P_NODE_19828_length_259_cov_0.844086_g19729_i0	PRJNA797475	19828	259	0.844086	2.18618274	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	357	4.46e-94	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g19729	i0	91.506	86.0926640926641	259	22	100	0	1	259	3557300	3557042	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	22298	357	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
13535067	13535067	PRJNA797475_P_NODE_22151_length_250_cov_1.536723_g22052_i0	PRJNA797475	22151	250	1.536723	3.8418075	Candidatus Solibacter usitatus	332163	Bacteria	Bacteria	396	9.079999999999996e-106	NTclustered	gi\|470468228\|ref\|NR_076103.1\|	332163	g22052	i0	95.2	105.588	250	12	100	0	1	250	866	1115	Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence	blastn	26397	396	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter usitatus
14809885	14809885	PRJNA797475_P_NODE_17632_length_270_cov_1.294416_g17533_i0	PRJNA797475	17632	270	1.294416	3.4949232	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	200	8.349999999999999e-47	NTclustered	gi\|2621701418\|emb\|OY760136.1\|	2910147	g17533	i0	80.669	1.9962962962963	269	43	99	7	1	266	1729417	1729679	MAG: Vicinamibacterales bacterium isolate f9e760c9-8bbe-4e76-9a0a-40d6f1fb97b8 genome assembly, chromosome: 1	blastn	539	200	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
14809937	14809937	PRJNA797475_P_NODE_21992_length_251_cov_0.865169_g21893_i0	PRJNA797475	21992	251	0.865169	2.17157419	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	254	5.81e-63	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g21893	i0	84.921	1.54980079681275	252	36	100	2	1	251	2448901	2449151	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	389	254	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
22458656	22458656	PRJNA797475_P_NODE_30998_length_228_cov_3.632258_g30899_i0	PRJNA797475	30998	228	3.632258	8.28154824	Acidobacteriaceae bacterium ZG23-2	2883246	Bacteria	Bacteria	182	2.48e-41	NTclustered	gi\|2221425918\|gb\|CP085323.1\|	2883246	g30899	i0	84.699	6.67982456140351	183	26	80	2	47	228	2351925	2351744	Acidobacteriaceae bacterium ZG23-2 chromosome, complete genome	blastn	1523	182	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium ZG23-2
23734344	23734344	PRJNA797475_P_NODE_7499_length_373_cov_1.780000_g7400_i0	PRJNA797475	7499	373	1.78	6.6394	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	505	2.2699999999999991e-138	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g7400	i0	91.176	296.514745308311	374	30	100	3	1	373	3176334	3175963	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	110600	505	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae 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);;