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

5 rows where analysis = "blastn", bioproject = "PRJNA1002816" and tax_clade = "FCB group"

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
152758	152758	PRJNA1002816_P_NODE_10921_length_337_cov_0.882576_g10761_i0	PRJNA1002816	10921	337	0.882576	2.97428112	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	514	3.37e-141	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g10761	i0	94.118	310.727002967359	340	17	100	2	1	337	361028	360689	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	104715	514	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
6531049	6531049	PRJNA1002816_P_NODE_17886_length_250_cov_0.870056_g17726_i0	PRJNA1002816	17886	250	0.870056	2.17514	uncultured Macellibacteroides sp.	1243007	Bacteria	Bacteria	176	1.2899999999999999e-39	NTclustered	gi\|2621704019\|emb\|OY762974.1\|	1243007	g17726	i0	79.675	1.92	246	48	98	2	4	248	1595622	1595378	MAG: uncultured Macellibacteroides sp. isolate 8f74f0af-0976-4f32-9dab-69c3ce622fc1 genome assembly, chromosome: 1	blastn	480	176	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Macellibacteroides	uncultured Macellibacteroides sp.
18852621	18852621	PRJNA1002816_P_NODE_7595_length_410_cov_1.370920_g7435_i0	PRJNA1002816	7595	410	1.37092	5.620772	Aquirufa	2676247	Bacteria	Bacteria	532	1.15e-146	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g7435	i0	91.371	435.639024390244	394	26	96	6	19	410	360118	359731	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	178612	532	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
24378886	24378886	PRJNA1002816_P_NODE_18940_length_247_cov_0.885057_g18780_i0	PRJNA1002816	18940	247	0.885057	2.18609079	Dyadobacter pollutisoli	2910158	Bacteria	Bacteria	326	1.19e-84	NTclustered	gi\|2381182547\|gb\|CP112998.1\|	2910158	g18780	i0	92.544	362.481781376518	228	15	92	2	21	247	3670	3444	Dyadobacter pollutisoli strain U1 chromosome	blastn	89533	326	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter pollutisoli
24378957	24378957	PRJNA1002816_P_NODE_3520_length_606_cov_1.994371_g3362_i0	PRJNA1002816	3520	606	1.994371	12.08588826	Hymenobacter sp. BRD128	2675878	Bacteria	Bacteria	920	0	NTclustered	gi\|1847993467\|gb\|CP053908.1\|	2675878	g3362	i0	94.108	281.42904290429	611	26	100	10	1	606	339346	338741	Hymenobacter sp. BRD128 chromosome, complete genome	blastn	170546	920	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. BRD128

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