metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJEB673" and tax

15 rows where analysis = "diamond", bioproject = "PRJEB673" and tax_kingdom = "Bacillati"

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
9062184	9062184	PRJEB673_P_NODE_3068_length_569_cov_8.398876_g2755_i0	PRJEB673	3068	569	8.398876	47.78960444	Propionibacteriaceae bacterium	2021380	Bacteria	Bacteria	213	2.47e-67	NR	MCP3885490.1	2021380	g2755	i0	66.9	0.796133567662566	151	48	79.6	1	521	69	3	151	MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium]	diamond	453	213	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae		Propionibacteriaceae bacterium
21811678	21811678	PRJEB673_P_NODE_3278_length_551_cov_6.127907_g2962_i0	PRJEB673	3278	551	6.127907	33.76476757	Propionibacteriaceae bacterium	2021380	Bacteria	Bacteria	215	2.4e-68	NR	MCP3885490.1	2021380	g2962	i0	69.5	0.822141560798548	151	44	82.2	1	503	51	3	151	MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium]	diamond	453	215	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae		Propionibacteriaceae bacterium
26590620	26590620	PRJEB673_P_NODE_781_length_1032_cov_2.976931_g613_i0	PRJEB673	781	1032	2.976931	30.72192792	uncultured Solirubrobacteraceae bacterium	1162706	Bacteria	Bacteria	45.8	0.00758	NR	CAA9514049.1	1162706	g613	i0	54.8	0.122093023255814	42	16	12.2	1	670	795	16	54	CAA9514049.1 MAG: hypothetical protein AVDCRST_MAG53-2895, partial [uncultured Solirubrobacteraceae bacterium]	diamond	126	45.8	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Solirubrobacteraceae		uncultured Solirubrobacteraceae bacterium
27406434	27406434	PRJEB673_P_NODE_12883_length_151_cov_1.034483_g12534_i0	PRJEB673	12883	151	1.034483	1.56206933	FCB group	1783270	Bacteria	Bacteria	49.3	5.23e-5	NR	TAK62485.1	2026734	g12534	i0	63.2	1.60927152317881	38	11	69.5	1	118	14	68	105	TAK62485.1 MAG: CSLREA domain-containing protein [Dehalococcoidia bacterium]	diamond	243	49.3	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
27792369	27792369	PRJEB673_P_NODE_9764_length_188_cov_1.045752_g9415_i0	PRJEB673	9764	188	1.045752	1.96601376	Paenibacillaceae bacterium	2003592	Bacteria	Bacteria	82.8	5.48e-18	NR	RXZ78062.1	2003592	g9415	i0	60.7	0.973404255319149	61	24	97.3	0	183	1	14	74	RXZ78062.1 guanylate kinase [Paenibacillaceae bacterium]	diamond	183	82.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae		Paenibacillaceae bacterium
27855369	27855369	PRJEB673_P_NODE_10085_length_181_cov_1.369863_g9736_i0	PRJEB673	10085	181	1.369863	2.47945203	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	42.4	0.0216	NR	MBQ9411538.1	2485925	g9736	i0	43.1	0.961325966850829	58	28	87.8	3	9	167	292	349	MBQ9411538.1 DUF2029 domain-containing protein [Oscillospiraceae bacterium]	diamond	174	42.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
28006333	28006333	PRJEB673_P_NODE_9845_length_186_cov_1.165563_g9496_i0	PRJEB673	9845	186	1.165563	2.16794718	Bacillati	1783272	Bacteria	Bacteria	97.8	5.97e-22	NR	WP_075735821.1	161895	g9496	i0	72.1	5.91935483870968	61	17	98.4	0	1	183	316	376	WP_075735821.1 aldehyde dehydrogenase family protein [Corynebacterium phocae]	diamond	1101	98.2	0.995926680244399	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium phocae
28423899	28423899	PRJEB673_P_NODE_6126_length_354_cov_1.357367_g5777_i0	PRJEB673	6126	354	1.357367	4.80507918	Propionibacteriaceae bacterium	2021380	Bacteria	Bacteria	81.6	8.22e-17	NR	MCP3885490.1	2021380	g5777	i0	78	0.423728813559322	50	11	42.4	0	156	7	66	115	MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium]	diamond	150	81.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae		Propionibacteriaceae bacterium
28928936	28928936	PRJEB673_P_NODE_9168_length_209_cov_1.080460_g8819_i0	PRJEB673	9168	209	1.08046	2.2581614	Chloroflexota bacterium	2026724	Bacteria	Bacteria	77.4	8.2e-15	NR	MEA3441316.1	2026724	g8819	i0	46.4	2.92822966507177	69	37	99	0	3	209	119	187	MEA3441316.1 NBR1-Ig-like domain-containing protein [Chloroflexota bacterium]	diamond	612	77.4	1	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30848441	30848441	PRJEB673_P_NODE_2714_length_600_cov_3.996460_g2413_i0	PRJEB673	2714	600	3.99646	23.97876	Bacillales	1385	Bacteria	Bacteria	80.1	3.05e-15	NR	WP_115360669.1	1474	g2413	i0	64.9	7.695	57	20	28.5	0	207	377	56	112	WP_115360669.1 nucleoside-diphosphate kinase [Sporosarcina pasteurii]	diamond	4617	80.9	0.990111248454882	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Sporosarcina	Sporosarcina pasteurii
31290711	31290711	PRJEB673_P_NODE_2175_length_662_cov_3.907496_g1902_i0	PRJEB673	2175	662	3.907496	25.86762352	Bacillales	1385	Bacteria	Bacteria	80.1	5.03e-15	NR	WP_115360669.1	1474	g1902	i0	64.9	6.97432024169184	57	20	25.8	0	207	377	56	112	WP_115360669.1 nucleoside-diphosphate kinase [Sporosarcina pasteurii]	diamond	4617	80.9	0.990111248454882	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Sporosarcina	Sporosarcina pasteurii
31417367	31417367	PRJEB673_P_NODE_11356_length_162_cov_1.259843_g11007_i0	PRJEB673	11356	162	1.259843	2.04094566	Candidatus Chlorohelix	3139173	Bacteria	Bacteria	95.5	1e-22	NR	WP_341470264.1	3003348	g11007	i0	81.1	4.90740740740741	53	10	98.1	0	3	161	126	178	WP_341470264.1 DoxX family protein [Candidatus Chlorohelix allophototropha]	diamond	795	95.9	0.995828988529718	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Chloroheliales	Candidatus Chloroheliaceae	Candidatus Chlorohelix	Candidatus Chlorohelix allophototropha
31867235	31867235	PRJEB673_P_NODE_9577_length_193_cov_1.012658_g9228_i0	PRJEB673	9577	193	1.012658	1.95442994	Thermoactinomyces sp. DSM 45892	1882753	Bacteria	Bacteria	99	5.429999999999999e-23	NR	WP_093290279.1	1882753	g9228	i0	85	3.60621761658031	60	8	91.7	1	3	179	267	326	WP_093290279.1 tyrosine-type recombinase/integrase [Thermoactinomyces sp. DSM 45892]	diamond	696	99	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Thermoactinomycetaceae	Thermoactinomyces	Thermoactinomyces sp. DSM 45892
31899036	31899036	PRJEB673_P_NODE_3197_length_557_cov_2.695402_g2881_i0	PRJEB673	3197	557	2.695402	15.01338914	Anaerolineales bacterium	2073117	Bacteria	Bacteria	94.4	5.41e-21	NR	HXQ39119.1	2073117	g2881	i0	49	1.07719928186715	100	49	53.9	1	155	454	32	129	HXQ39119.1 globin family protein [Anaerolineales bacterium]	diamond	600	94.4	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
32310667	32310667	PRJEB673_P_NODE_5819_length_365_cov_1.721212_g5470_i0	PRJEB673	5819	365	1.721212	6.2824238	Frankiaceae bacterium	2654182	Bacteria	Bacteria	86.3	7.62e-17	NR	HEX4017710.1	2654182	g5470	i0	53	1.36438356164384	83	37	67.4	2	25	270	411	492	HEX4017710.1 flavin monoamine oxidase family protein [Frankiaceae bacterium]	diamond	498	86.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Frankiales	Frankiaceae		Frankiaceae 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);;