metadata: contig_metadata: 7 rows where bioproject = "PRJNA1063685" and tax

7 rows where bioproject = "PRJNA1063685" and tax_clade = "delta/epsilon subdivisions"

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_class	tax_order	tax_family	tax_genus	tax_species
16756406	16756406	PRJNA1063685_S_NODE_27394_length_448_cov_4.234667_g26853_i0	PRJNA1063685	27394	448	4.234667	18.97130816	uncultured delta proteobacterium DeepAnt-1F12	357894	Bacteria	Bacteria	457	7.87e-124	NTclustered	gi\|82617822\|gb\|DQ267495.1\|	357894	g26853	i0	85.078	205.482142857143	449	65	99	2	1	447	4850	5298	Uncultured delta proteobacterium DeepAnt-1F12 fosmid, complete sequence	blastn	92056	457	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium DeepAnt-1F12
16756523	16756523	PRJNA1063685_S_NODE_40514_length_365_cov_7.390411_g39971_i0	PRJNA1063685	40514	365	7.390411	26.97500015	Microvenator marinus	2600177	Bacteria	Bacteria	396	1.39e-105	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g39971	i0	86.612	203.690410958904	366	39	100	9	1	365	703639	703995	Microvenator marinus strain V1718 chromosome, complete genome	blastn	74347	396	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
18031048	18031048	PRJNA1063685_S_NODE_1415_length_1006_cov_163.532690_g1136_i0	PRJNA1063685	1415	1006	163.53269	1645.1388614	Microvenator marinus	2600177	Bacteria	Bacteria	616	2.879999999999999e-171	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g1136	i0	79.215	227.86282306163	943	153	91	36	92	1006	2065363	2064436	Microvenator marinus strain V1718 chromosome, complete genome	blastn	229230	616	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
20138167	20138167	PRJNA1063685_S_NODE_12636_length_591_cov_7.335907_g12118_i0	PRJNA1063685	12636	591	7.335907	43.35521037	Bacteria	2	Bacteria	Bacteria	342	3.0999999999999993e-89	NTclustered	gi\|281313264\|gb\|GU214165.1\|	34034	g12118	i0	77.899	73.663282571912	552	120	93	2	18	568	945	395	Uncultured delta proteobacterium clone IAFpp8v11 16S ribosomal RNA gene, partial sequence	blastn	43535	342	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
21856300	21856300	PRJNA1063685_S_NODE_21278_length_497_cov_13.141509_g20739_i0	PRJNA1063685	21278	497	13.141509	65.31329973	Microvenator marinus	2600177	Bacteria	Bacteria	619	1.06e-172	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g20739	i0	89.135	147.997987927565	497	54	100	0	1	497	4171572	4172068	Microvenator marinus strain V1718 chromosome, complete genome	blastn	73555	619	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
24405436	24405436	PRJNA1063685_S_NODE_25020_length_466_cov_3.155216_g24480_i0	PRJNA1063685	25020	466	3.155216	14.70330656	uncultured delta proteobacterium	34034	Bacteria	Bacteria	472	2.9299999999999996e-128	NTclustered	gi\|2874253659\|emb\|OY969087.1\|	34034	g24480	i0	88.491	76.1287553648069	391	43	84	2	4	393	2867043	2867432	MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1	blastn	35476	472	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
32375112	32375112	PRJNA1063685_S_NODE_22519_length_486_cov_5.360775_g21979_i0	PRJNA1063685	22519	486	5.360775	26.0533665	Bradymonas sediminis	1548548	Bacteria	Bacteria	46.2	0.00318	NR	WP_133621882.1	1548548	g21979	i0	31.7	0.506172839506173	82	52	50.6	3	63	308	11	88	WP_133621882.1 hypothetical protein [Bradymonas sediminis]	diamond	246	46.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis

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