metadata: contig_metadata: 14 rows where bioproject = "PRJNA453111" and tax

14 rows where bioproject = "PRJNA453111" 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
4921033	4921033	PRJNA453111_P_NODE_9424_length_260_cov_1.133690_g9332_i0	PRJNA453111	9424	260	1.13369	2.947594	root	1	Root_unresolved	Root_unresolved	481	2.55e-131	NTclustered	gi\|1214359213\|gb\|MF424753.1\|	1613	g9332	i0	100	194	260	0	100	0	1	260	878	1137	Limosilactobacillus fermentum strain CAU6386 16S ribosomal RNA gene, partial sequence	blastn	50440	481	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Limosilactobacillus	Limosilactobacillus fermentum
8094537	8094537	PRJNA453111_P_NODE_11727_length_246_cov_0.890173_g11635_i0	PRJNA453111	11727	246	0.890173	2.18982558	Streptomyces sp. NBC_00564	2903663	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2667518664\|gb\|CP107786.1\|	2903663	g11635	i0	100	0.121951219512195	30	0	12	0	30	59	1030285	1030256	Streptomyces sp. NBC_00564 strain NBC 00564 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00564
16395394	16395394	PRJNA453111_P_NODE_12133_length_244_cov_0.900585_g12041_i0	PRJNA453111	12133	244	0.900585	2.1974274	Pseudonocardiaceae	2070	Bacteria	Bacteria	407	4.08e-109	NTclustered	gi\|2667020334\|dbj\|AP029207.1\|	1933	g12041	i0	97.872	259.827868852459	235	5	96	0	1	235	3410	3176	Streptoalloteichus tenebrarius JCM 4838 DNA, complete genome	blastn	63398	407	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Streptoalloteichus	Streptoalloteichus tenebrarius
17670479	17670479	PRJNA453111_P_NODE_4714_length_372_cov_1.314381_g4622_i0	PRJNA453111	4714	372	1.314381	4.88949732	Lachnospiraceae	186803	Bacteria	Bacteria	52.8	0.035	NTclustered	gi\|2813041527\|emb\|OZ186729.1\|	33038	g4622	i0	100	0.526881720430108	28	0	8	0	24	51	2489714	2489687	Mediterraneibacter gnavus isolate LUMC_Rgna_QRD035 genome assembly, chromosome: 1	blastn	196	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Mediterraneibacter	Mediterraneibacter gnavus
22117974	22117974	PRJNA453111_P_NODE_658_length_1009_cov_1.802350_g598_i0	PRJNA453111	658	1009	1.80235	18.1857115	Enterococcus	1350	Bacteria	Bacteria	390	8.249999999999998e-132	NR	WP_413133017.1	37734	g598	i0	56.7	3.00891972249752	337	133	96.3	2	2	973	29	365	WP_413133017.1 pectate lyase family protein [Enterococcus casseliflavus]	diamond	3036	390	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
23393638	23393638	PRJNA453111_P_NODE_3379_length_442_cov_1.691057_g3287_i0	PRJNA453111	3379	442	1.691057	7.47447194	Clostridium perfringens	1502	Bacteria	Bacteria	52.8	0.043	NTclustered	gi\|2100434541\|gb\|CP075946.1\|	1502	g3287	i0	100	0.0633484162895928	28	0	6	0	54	81	34618	34645	Clostridium perfringens strain 955/85 plasmid pCP955-85	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
27123620	27123620	PRJNA453111_P_NODE_10182_length_251_cov_0.814607_g10090_i0	PRJNA453111	10182	251	0.814607	2.04466357	Brevibacterium	1696	Bacteria	Bacteria	43.1	0.0277	NR	WP_332839751.1	946573	g10090	i0	51.4	1.32669322709163	37	17	43	1	236	129	210	246	WP_332839751.1 glycosyltransferase family 2 protein [Brevibacterium yomogidense]	diamond	333	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium yomogidense
27913410	27913410	PRJNA453111_P_NODE_6345_length_321_cov_1.862903_g6253_i0	PRJNA453111	6345	321	1.862903	5.97991863	Enterococcus	1350	Bacteria	Bacteria	124	9.619999999999999e-32	NR	WP_413133017.1	37734	g6253	i0	55.8	1.94392523364486	104	45	97.2	1	3	314	206	308	WP_413133017.1 pectate lyase family protein [Enterococcus casseliflavus]	diamond	624	125	0.992	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus casseliflavus
28402538	28402538	PRJNA453111_P_NODE_8026_length_286_cov_0.995305_g7934_i0	PRJNA453111	8026	286	0.995305	2.8465723	Clostridia bacterium	2044939	Bacteria	Bacteria	44.7	0.0139	NR	QRN85737.1	2044939	g7934	i0	34.8	0.692307692307692	66	37	62.9	1	56	235	235	300	QRN85737.1 InlB B-repeat-containing protein [Clostridia bacterium]	diamond	198	44.7	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
28686971	28686971	PRJNA453111_P_NODE_12687_length_242_cov_1.366864_g12595_i0	PRJNA453111	12687	242	1.366864	3.30781088	Enterococcus mundtii	53346	Bacteria	Bacteria	48.9	2.35e-4	NR	WP_010736445.1	53346	g12595	i0	35.7	3.47107438016529	70	45	86.8	0	213	4	22	91	WP_010736445.1 pectate lyase family protein [Enterococcus mundtii]	diamond	840	48.9	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus mundtii
29002892	29002892	PRJNA453111_P_NODE_12648_length_243_cov_0.894118_g12556_i0	PRJNA453111	12648	243	0.894118	2.17270674	Dactylosporangium fulvum	53359	Bacteria	Bacteria	42.7	0.0363	NR	WP_259862636.1	53359	g12556	i0	40	0.679012345679012	55	28	61.7	1	48	197	443	497	WP_259862636.1 HNH endonuclease signature motif containing protein [Dactylosporangium fulvum]	diamond	165	42.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Dactylosporangium	Dactylosporangium fulvum
29223649	29223649	PRJNA453111_P_NODE_12589_length_243_cov_0.905882_g12497_i0	PRJNA453111	12589	243	0.905882	2.20129326	Actinokineospora auranticolor	155976	Bacteria	Bacteria	42.4	0.0477	NR	PPK65354.1	155976	g12497	i0	31.2	0.950617283950617	77	52	93.8	1	243	16	23	99	PPK65354.1 hypothetical protein CLV40_1146 [Actinokineospora auranticolor]	diamond	231	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Actinokineospora	Actinokineospora auranticolor
29444234	29444234	PRJNA453111_P_NODE_1410_length_694_cov_1.621578_g1322_i0	PRJNA453111	1410	694	1.621578	11.25375132	Melissococcus plutonius	33970	Bacteria	Bacteria	130	7.26e-32	NR	WP_231849637.1	33970	g1322	i0	44.6	1.45244956772334	168	88	70.5	1	493	5	35	202	WP_231849637.1 pectate lyase family protein [Melissococcus plutonius]	diamond	1008	130	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Melissococcus	Melissococcus plutonius
32415787	32415787	PRJNA453111_P_NODE_12899_length_242_cov_0.911243_g12807_i0	PRJNA453111	12899	242	0.911243	2.20520806	Nesterenkonia massiliensis	1232429	Bacteria	Bacteria	147	5.93e-39	NR	WP_044494056.1	1232429	g12807	i0	97.5	0.991735537190083	80	2	99.2	0	242	3	324	403	WP_044494056.1 UvrD-helicase domain-containing protein [Nesterenkonia massiliensis]	diamond	240	147	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia massiliensis

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