metadata: contig_metadata: 5 rows where bioproject = "PRJNA661142", tax_clade = "FCB group" and tax

5 rows where bioproject = "PRJNA661142", tax_clade = "FCB group" and tax_phylum = "Rhodothermota"

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
7006710	7006710	PRJNA661142_P_NODE_1586_length_604_cov_36.897297_g1526_i0	PRJNA661142	1586	604	36.897297	222.85967388	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	460	8.389999999999998e-125	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g1526	i0	83.698	12.4900662251656	503	66	82	11	47	541	2475722	2476216	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	7544	460	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
9556640	9556640	PRJNA661142_P_NODE_4468_length_368_cov_12.852665_g4403_i0	PRJNA661142	4468	368	12.852665	47.2978072	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	194	4.3e-58	NR	HEX9952712.1	2838334	g4403	i0	77.9	1.98097826086957	122	27	99.5	0	3	368	195	316	HEX9952712.1 aminotransferase class V-fold PLP-dependent enzyme [Rubricoccaceae bacterium]	diamond	729	194	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
15930964	15930964	PRJNA661142_P_NODE_1233_length_667_cov_6.079288_g1177_i0	PRJNA661142	1233	667	6.079288	40.54885096	Rubrivirga	1434037	Bacteria	Bacteria	266	3.77e-86	NR	WP_095513122.1	1961794	g1177	i0	90.9	1.28185907046477	143	13	64.3	0	640	212	125	267	WP_095513122.1 metallophosphoesterase family protein [Rubrivirga sp. SAORIC476]	diamond	855	266	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. SAORIC476
17206139	17206139	PRJNA661142_P_NODE_2014_length_548_cov_27.004008_g1952_i0	PRJNA661142	2014	548	27.004008	147.98196384	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	345	8.68e-114	NR	HEX9952893.1	2838334	g1952	i0	93.6	0.947080291970803	173	11	94.7	0	546	28	169	341	HEX9952893.1 malate synthase A [Rubricoccaceae bacterium]	diamond	519	345	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
22305435	22305435	PRJNA661142_P_NODE_6918_length_290_cov_8.406639_g6853_i0	PRJNA661142	6918	290	8.406639	24.3792531	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	176	7.61e-53	NR	HEX8298440.1	2838334	g6853	i0	93.8	1.98620689655172	96	6	99.3	0	290	3	69	164	HEX8298440.1 hypothetical protein [Rubricoccaceae bacterium]	diamond	576	176	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium

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