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

8 rows where analysis = "blastn", bioproject = "PRJEB80557" and tax_phylum = "Thermotogota"

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
3965205	3965205	PRJEB80557_S_NODE_19264_length_216_cov_1.550898_g18868_i0	PRJEB80557	19264	216	1.550898	3.34993968	Fervidobacterium gondwanense	44754	Bacteria	Bacteria	351	1.68e-92	NTclustered	gi\|2793119032\|gb\|CP126501.1\|	44754	g18868	i0	98.492	13.8611111111111	199	3	92	0	1	199	1154363	1154561	Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome	blastn	2994	351	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
4824621	4824621	PRJEB80557_S_NODE_29944_length_177_cov_1.210938_g29548_i0	PRJEB80557	29944	177	1.210938	2.14336026	Fervidobacterium	2422	Bacteria	Bacteria	307	2.89e-79	NTclustered	gi\|2793125101\|gb\|CP126499.1\|	2423	g29548	i0	98.837	2.91525423728814	172	2	97	0	1	172	2069885	2069714	Fervidobacterium islandicum strain H-21 chromosome, complete genome	blastn	516	307	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
8649740	8649740	PRJEB80557_S_NODE_3087_length_461_cov_1.978155_g2692_i0	PRJEB80557	3087	461	1.978155	9.11929455	Bacteria	2	Bacteria	Bacteria	691	0	NTclustered	gi\|2793119032\|gb\|CP126501.1\|	44754	g2692	i0	97.297	62.9240780911063	407	11	88	0	1	407	521673	521267	Fervidobacterium gondwanense strain CBS-13020 chromosome, complete genome	blastn	29008	693	0.997113997113997	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium gondwanense
13749916	13749916	PRJEB80557_S_NODE_17891_length_223_cov_2.229885_g17495_i0	PRJEB80557	17891	223	2.229885	4.97264355	Fervidobacterium	2422	Bacteria	Bacteria	331	2.2700000000000002e-86	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g17495	i0	96.535	31.8654708520179	202	4	90	3	1	200	304758	304958	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	7106	331	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
15024431	15024431	PRJEB80557_S_NODE_23872_length_196_cov_1.408163_g23476_i0	PRJEB80557	23872	196	1.408163	2.75999948	Bacteria	2	Bacteria	Bacteria	357	3.2099999999999996e-94	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g23476	i0	99.49	11	196	1	100	0	1	196	787326	787131	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	2156	357	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans
15024462	15024462	PRJEB80557_S_NODE_3252_length_452_cov_1.637717_g2857_i0	PRJEB80557	3252	452	1.637717	7.40248084	Bacteria	2	Bacteria	Bacteria	739	0	NTclustered	gi\|2216421086\|gb\|CP014334.2\|	2423	g2857	i0	97.279	30.7610619469027	441	2	95	2	22	452	305648	305208	Fervidobacterium islandicum strain AW-1 chromosome, complete genome	blastn	13904	739	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium islandicum
16715974	16715974	PRJEB80557_S_NODE_7554_length_325_cov_1.840580_g7158_i0	PRJEB80557	7554	325	1.84058	5.981885	Defluviitoga tunisiensis	1006576	Bacteria	Bacteria	499	9.07e-137	NTclustered	gi\|762219508\|emb\|LN824141.1\|	1006576	g7158	i0	98.246	21.0461538461538	285	5	88	0	23	307	1218006	1217722	Defluviitoga tunisiensis genome assembly DTL3, chromosome : I	blastn	6840	499	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Defluviitoga	Defluviitoga tunisiensis
20123056	20123056	PRJEB80557_S_NODE_27476_length_184_cov_1.770370_g27080_i0	PRJEB80557	27476	184	1.77037	3.2574808	Bacteria	2	Bacteria	Bacteria	281	1.84e-71	NTclustered	gi\|383108560\|gb\|CP003260.1\|	771875	g27080	i0	98.148	10.3695652173913	162	2	88	1	23	184	782443	782603	Fervidobacterium pennivorans DSM 9078, complete genome	blastn	1908	281	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Thermotogales	Fervidobacteriaceae	Fervidobacterium	Fervidobacterium pennivorans

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