metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA358490" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA358490" 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
398953	398953	PRJNA358490_P_NODE_11161_length_281_cov_1.694215_g10817_i0	PRJNA358490	11161	281	1.694215	4.76074415	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	198	3.14e-46	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g10817	i0	89.308	64.8113879003559	159	15	56	2	124	281	4250063	4249906	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	18212	198	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
5502520	5502520	PRJNA358490_P_NODE_10205_length_322_cov_4.964664_g9863_i0	PRJNA358490	10205	322	4.964664	15.98621808	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	372	2.04e-98	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g9863	i0	89.262	87.6180124223603	298	31	92	1	6	302	317549	317252	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	28213	372	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
5502703	5502703	PRJNA358490_P_NODE_7105_length_479_cov_3.129545_g6773_i0	PRJNA358490	7105	479	3.129545	14.99052055	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	80.5	2.14e-10	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g6773	i0	77.698	13.482254697286	139	25	28	5	320	455	1601513	1601648	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	6458	80.5	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
6176185	6176185	PRJNA358490_P_NODE_12725_length_229_cov_1.489474_g12381_i0	PRJNA358490	12725	229	1.489474	3.41089546	Pseudomonadati	3379134	Bacteria	Bacteria	147	9.11e-31	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g12381	i0	85.211	51.056768558952	142	21	62	0	30	171	1668447	1668306	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	11692	148	0.993243243243243	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8052296	8052296	PRJNA358490_P_NODE_2847_length_850_cov_3.035758_g2652_i0	PRJNA358490	2847	850	3.035758	25.803943	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	496	3.29e-135	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g2652	i0	77.873	1.94823529411765	818	167	98	12	20	830	5012361	5013171	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	1656	496	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10602677	10602677	PRJNA358490_P_NODE_10989_length_288_cov_1.313253_g10647_i0	PRJNA358490	10989	288	1.313253	3.78216864	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	361	3.899999999999999e-95	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g10647	i0	89.236	5.22569444444444	288	31	100	0	1	288	4519762	4520049	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	1505	361	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
10602730	10602730	PRJNA358490_P_NODE_14589_length_189_cov_1.153333_g14245_i0	PRJNA358490	14589	189	1.153333	2.17979937	Luteitalea pratensis	1855912	Bacteria	Bacteria	122	1.2199999999999999e-23	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g14245	i0	85.124	1.23280423280423	121	16	63	2	12	131	6945898	6945779	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	233	122	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
11877808	11877808	PRJNA358490_P_NODE_8150_length_428_cov_2.267352_g7809_i0	PRJNA358490	8150	428	2.267352	9.70426656	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	359	2.17e-94	NTclustered	gi\|2874253862\|emb\|OY969918.1\|	171953	g7809	i0	90.182	113.927570093458	275	27	64	0	154	428	2233487	2233761	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.4 genome assembly, chromosome: 1	blastn	48761	359	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14427742	14427742	PRJNA358490_P_NODE_14212_length_195_cov_2.250000_g13868_i0	PRJNA358490	14212	195	2.25	4.3875	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	237	4.3300000000000005e-58	NTclustered	gi\|76574296\|gb\|DQ139444.1\|	171953	g13868	i0	88.832	239.810256410256	197	16	100	6	1	195	1555	1747	Uncultured Acidobacteria bacterium clone CAL5 23S ribosomal RNA gene, partial sequence	blastn	46763	237	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14427872	14427872	PRJNA358490_P_NODE_6552_length_511_cov_16.366525_g6224_i0	PRJNA358490	6552	511	16.366525	83.63294275	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	734	0	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g6224	i0	93.673	220.769080234834	490	31	96	0	1	490	490	1	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	112813	734	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15701674	15701674	PRJNA358490_P_NODE_15673_length_174_cov_1.074074_g15329_i0	PRJNA358490	15673	174	1.074074	1.86888876	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	143	8.439999999999998e-30	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g15329	i0	82.317	1.10344827586207	164	29	94	0	1	164	3859269	3859432	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	192	143	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22075525	22075525	PRJNA358490_P_NODE_1578_length_1095_cov_2.614583_g1456_i0	PRJNA358490	1578	1095	2.614583	28.62968385	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	433	3.4e-116	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g1456	i0	80.526	22.1305936073059	570	105	52	6	529	1095	997118	997684	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	24233	433	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22075654	22075654	PRJNA358490_P_NODE_8638_length_405_cov_2.781421_g8297_i0	PRJNA358490	8638	405	2.781421	11.26475505	Candidatus Solibacter usitatus	332163	Bacteria	Bacteria	494	5.37e-135	NTclustered	gi\|470468228\|ref\|NR_076103.1\|	332163	g8297	i0	88.725	26.7654320987654	408	40	100	6	1	405	1333	1737	Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence	blastn	10840	494	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter usitatus

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