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

8 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax_phylum = "Caldisericota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
291462	291462	PRJNA1148190_P_NODE_16181_length_2203_cov_231.175587_g244_i88	PRJNA1148190	16181	2203	231.175587	5092.79818161	Caldisericum exile	693075	Bacteria	Bacteria	87.9	6.25e-12	NTclustered	gi\|381363297\|dbj\|AP012051.1\|	511051	g244	i88	94.737	0.422151611438947	57	1	3	2	1353	1408	698007	697952	Caldisericum exile AZM16c01 DNA, complete genome	blastn	930	87.9	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia	Caldisericales	Caldisericaceae	Caldisericum	Caldisericum exile
1573212	1573212	PRJNA1148190_P_NODE_6622_length_4541_cov_201.128693_g244_i64	PRJNA1148190	6622	4541	201.128693	9133.25394913	Caldisericum exile	693075	Bacteria	Bacteria	87.9	1.3e-11	NTclustered	gi\|381363297\|dbj\|AP012051.1\|	511051	g244	i64	94.737	0.204800704690597	57	1	1	2	3691	3746	698007	697952	Caldisericum exile AZM16c01 DNA, complete genome	blastn	930	87.9	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia	Caldisericales	Caldisericaceae	Caldisericum	Caldisericum exile
9228225	9228225	PRJNA1148190_P_NODE_7908_length_3949_cov_206.659443_g244_i71	PRJNA1148190	7908	3949	206.659443	8160.98140407	Caldisericum exile	693075	Bacteria	Bacteria	87.9	1.13e-11	NTclustered	gi\|381363297\|dbj\|AP012051.1\|	511051	g244	i71	94.737	0.279564446695366	57	1	1	2	3099	3154	698007	697952	Caldisericum exile AZM16c01 DNA, complete genome	blastn	1104	87.9	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia	Caldisericales	Caldisericaceae	Caldisericum	Caldisericum exile
11769281	11769281	PRJNA1148190_P_NODE_11590_length_2906_cov_230.849629_g244_i83	PRJNA1148190	11590	2906	230.849629	6708.49021874	Caldisericum exile	693075	Bacteria	Bacteria	87.9	8.28e-12	NTclustered	gi\|381363297\|dbj\|AP012051.1\|	511051	g244	i83	94.737	0.320027529249828	57	1	2	2	2056	2111	698007	697952	Caldisericum exile AZM16c01 DNA, complete genome	blastn	930	87.9	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia	Caldisericales	Caldisericaceae	Caldisericum	Caldisericum exile
13054308	13054308	PRJNA1148190_P_NODE_9031_length_3555_cov_211.746123_g244_i75	PRJNA1148190	9031	3555	211.746123	7527.57467265	Caldisericum exile	693075	Bacteria	Bacteria	87.9	1.01e-11	NTclustered	gi\|381363297\|dbj\|AP012051.1\|	511051	g244	i75	94.737	0.261603375527426	57	1	2	2	2705	2760	698007	697952	Caldisericum exile AZM16c01 DNA, complete genome	blastn	930	87.9	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia	Caldisericales	Caldisericaceae	Caldisericum	Caldisericum exile
16867599	16867599	PRJNA1148190_P_NODE_10974_length_3035_cov_216.567184_g244_i78	PRJNA1148190	10974	3035	216.567184	6572.8140344	Caldisericum exile	693075	Bacteria	Bacteria	87.9	8.65e-12	NTclustered	gi\|381363297\|dbj\|AP012051.1\|	511051	g244	i78	94.737	0.306425041186161	57	1	2	2	2185	2240	698007	697952	Caldisericum exile AZM16c01 DNA, complete genome	blastn	930	87.9	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia	Caldisericales	Caldisericaceae	Caldisericum	Caldisericum exile
16869546	16869546	PRJNA1148190_P_NODE_222234_length_360_cov_1.341463_g211064_i0	PRJNA1148190	222234	360	1.341463	4.8292668	Caldisericum exile	693075	Bacteria	Bacteria	84.2	1.21e-11	NTclustered	gi\|381363297\|dbj\|AP012051.1\|	511051	g211064	i0	88.406	3.95277777777778	69	8	19	0	241	309	698189	698257	Caldisericum exile AZM16c01 DNA, complete genome	blastn	1423	84.2	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia	Caldisericales	Caldisericaceae	Caldisericum	Caldisericum exile
21967501	21967501	PRJNA1148190_P_NODE_11838_length_2854_cov_215.361021_g244_i84	PRJNA1148190	11838	2854	215.361021	6146.40353934	Caldisericum exile	693075	Bacteria	Bacteria	87.9	8.13e-12	NTclustered	gi\|381363297\|dbj\|AP012051.1\|	511051	g244	i84	94.737	0.325858444288718	57	1	2	2	2004	2059	698007	697952	Caldisericum exile AZM16c01 DNA, complete genome	blastn	930	87.9	1	Bacteria	Caldisericota/Cryosericota group	Pseudomonadati	Caldisericota	Caldisericia	Caldisericales	Caldisericaceae	Caldisericum	Caldisericum exile

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