metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA641991" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA641991" 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
1894025	1894025	PRJNA641991_S_NODE_9382_length_185_cov_0.823529_g9263_i0	PRJNA641991	9382	185	0.823529	1.52352865	Maribacter sp. R86514	3093854	Bacteria	Bacteria	69.4	1.57e-7	NTclustered	gi\|2845113958\|gb\|CP138999.1\|	3093854	g9263	i0	93.478	3.40540540540541	46	3	25	0	37	82	1039078	1039033	Maribacter sp. R86514 chromosome, complete genome	blastn	630	69.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Maribacter	Maribacter sp. R86514
2433542	2433542	PRJNA641991_S_NODE_12602_length_166_cov_0.871795_g12483_i0	PRJNA641991	12602	166	0.871795	1.4471797	Flavobacterium	237	Bacteria	Bacteria	237	3.58e-58	NTclustered	gi\|2643654678\|gb\|CP136574.1\|	239	g12483	i0	93.168	3.59638554216867	161	11	97	0	1	161	1539044	1539204	MAG: Flavobacterium sp. isolate GU0601_MAG5 chromosome, complete genome	blastn	597	237	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
8271035	8271035	PRJNA641991_S_NODE_14407_length_162_cov_0.902655_g14288_i0	PRJNA641991	14407	162	0.902655	1.4623011	Flavobacterium sp. TR2	2977321	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2304704138\|gb\|CP104307.1\|	2977321	g14288	i0	100	49.7222222222222	162	0	100	0	1	162	151146	150985	Flavobacterium sp. TR2 chromosome, complete genome	blastn	8055	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. TR2
10086915	10086915	PRJNA641991_S_NODE_11288_length_171_cov_1.254098_g11169_i0	PRJNA641991	11288	171	1.254098	2.14450758	Aquirufa	2676247	Bacteria	Bacteria	305	9.96e-79	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g11169	i0	98.83	347.654970760234	171	2	100	0	1	171	360555	360725	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	59449	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
12097159	12097159	PRJNA641991_S_NODE_10030_length_180_cov_1.137405_g9911_i0	PRJNA641991	10030	180	1.137405	2.047329	Spirosoma radiotolerans	1379870	Bacteria	Bacteria	102	1.49e-17	NTclustered	gi\|808692684\|gb\|CP010429.1\|	1379870	g9911	i0	94.03	20.2666666666667	67	4	37	0	1	67	4385050	4385116	Spirosoma radiotolerans strain DG5A, complete genome	blastn	3648	102	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma radiotolerans
15186864	15186864	PRJNA641991_S_NODE_14412_length_162_cov_0.902655_g14293_i0	PRJNA641991	14412	162	0.902655	1.4623011	Chryseobacterium	59732	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g14293	i0	100	91.2222222222222	162	0	100	0	1	162	3306083	3305922	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	14778	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
15920605	15920605	PRJNA641991_S_NODE_10953_length_173_cov_1.233871_g10834_i0	PRJNA641991	10953	173	1.233871	2.13459683	Flavobacterium ammoniigenes	1751095	Bacteria	Bacteria	315	1.68e-81	NTclustered	gi\|2119750057\|dbj\|AP025184.1\|	1751095	g10834	i0	99.422	98.6820809248555	173	1	100	0	1	173	1118616	1118444	Flavobacterium ammoniigenes GENT5 DNA, complete genome	blastn	17072	315	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium ammoniigenes
17736313	17736313	PRJNA641991_S_NODE_3174_length_296_cov_2.008097_g3055_i0	PRJNA641991	3174	296	2.008097	5.94396712	Flavobacterium	237	Bacteria	Bacteria	444	3.88e-120	NTclustered	gi\|2164473264\|gb\|CP089095.1\|	2895947	g3055	i0	93.919	525.760135135135	296	14	99	4	3	296	979677	979384	Flavobacterium cyclinae strain KSM-R2A25 chromosome, complete genome	blastn	155625	448	0.991071428571429	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cyclinae
19744620	19744620	PRJNA641991_S_NODE_13796_length_163_cov_0.894737_g13677_i0	PRJNA641991	13796	163	0.894737	1.45842131	Flavobacterium cyclinae	2895947	Bacteria	Bacteria	235	1.26e-57	NTclustered	gi\|2164473264\|gb\|CP089095.1\|	2895947	g13677	i0	92.638	11.920245398773	163	12	100	0	1	163	300137	300299	Flavobacterium cyclinae strain KSM-R2A25 chromosome, complete genome	blastn	1943	235	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cyclinae
21020189	21020189	PRJNA641991_S_NODE_5417_length_232_cov_1.617486_g5298_i0	PRJNA641991	5417	232	1.617486	3.75256752	Flavobacterium sp. TR2	2977321	Bacteria	Bacteria	403	4.97e-108	NTclustered	gi\|2304704138\|gb\|CP104307.1\|	2977321	g5298	i0	98.276	6.15086206896552	232	1	100	1	1	232	1320621	1320849	Flavobacterium sp. TR2 chromosome, complete genome	blastn	1427	403	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. TR2

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