metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA942359" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA942359" and tax_phylum = "Thermodesulfobacteriota"

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
1258769	1258769	PRJNA942359_P_NODE_17541_length_246_cov_0.901734_g17426_i0	PRJNA942359	17541	246	0.901734	2.21826564	Desulfomicrobium	898	Bacteria	Bacteria	405	1.48e-108	NTclustered	gi\|470484403\|ref\|NR_076646.1\|	899	g17426	i0	96.341	120.390243902439	246	9	100	0	1	246	1419	1664	Desulfomicrobium baculatum strain INMI strain X 23S ribosomal RNA gene, complete sequence	blastn	29616	405	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium baculatum
2198238	2198238	PRJNA942359_P_NODE_14762_length_250_cov_0.881356_g14647_i0	PRJNA942359	14762	250	0.881356	2.20339	Thiovibrio sp. Mzg5	2715680	Bacteria	Bacteria	296	9.47e-76	NTclustered	gi\|2883226761\|dbj\|AP022872.1\|	2715680	g14647	i0	90.308	0.908	227	20	91	2	8	234	309425	309649	Desulfobulbaceae bacterium Mzg5 DNA, complete genome	blastn	227	296	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Thiovibrionaceae	Thiovibrio	Thiovibrio sp. Mzg5
6026100	6026100	PRJNA942359_P_NODE_16085_length_248_cov_0.891429_g15970_i0	PRJNA942359	16085	248	0.891429	2.21074392	Thiovibrio sp. Mzg5	2715680	Bacteria	Bacteria	357	4.24e-94	NTclustered	gi\|2883226761\|dbj\|AP022872.1\|	2715680	g15970	i0	92.713	15.3346774193548	247	18	99	0	2	248	2637439	2637685	Desulfobulbaceae bacterium Mzg5 DNA, complete genome	blastn	3803	357	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Thiovibrionaceae	Thiovibrio	Thiovibrio sp. Mzg5
7301157	7301157	PRJNA942359_P_NODE_3586_length_422_cov_2.389685_g3471_i0	PRJNA942359	3586	422	2.389685	10.0844707	uncultured Mailhella sp.	1981031	Bacteria	Bacteria	647	0	NTclustered	gi\|2729058701\|emb\|OZ007001.1\|	1981031	g3471	i0	94.326	202.876777251185	423	23	100	1	1	422	1717830	1718252	MAG: uncultured Mailhella sp. isolate metabat2_pooled_hifiasm.920 MAG genome assembly, chromosome: 1	blastn	85614	647	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Mailhella	uncultured Mailhella sp.
20049515	20049515	PRJNA942359_P_NODE_13696_length_252_cov_0.871508_g13581_i0	PRJNA942359	13696	252	0.871508	2.19620016	Thiovibrio sp. Mzg5	2715680	Bacteria	Bacteria	322	1.58e-83	NTclustered	gi\|2883226761\|dbj\|AP022872.1\|	2715680	g13581	i0	89.723	1.21031746031746	253	24	100	2	1	252	680833	681084	Desulfobulbaceae bacterium Mzg5 DNA, complete genome	blastn	305	322	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Thiovibrionaceae	Thiovibrio	Thiovibrio sp. Mzg5

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