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

5 rows where analysis = "blastn", bioproject = "PRJNA928559" and tax_phylum = "Porifera"

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
902708	902708	PRJNA928559_P_NODE_155941_length_281_cov_3.850962_g154372_i0	PRJNA928559	155941	281	3.850962	10.82120322	Sycon ciliatum	27933	Porifera	other_Eukaryota	63.9	1.2e-5	NTclustered	gi\|2732902156\|ref\|XM_065339021.1\|	27933	g154372	i0	95.122	0.145907473309609	41	1	14	1	198	237	1350	1310	PREDICTED: Sycon ciliatum uncharacterized LOC135826404 (LOC135826404), mRNA	blastn	41	63.9	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
903764	903764	PRJNA928559_P_NODE_226801_length_205_cov_4.318182_g225232_i0	PRJNA928559	226801	205	4.318182	8.8522731	Sycon ciliatum	27933	Porifera	other_Eukaryota	65.8	2.3e-6	NTclustered	gi\|2732923836\|ref\|XM_065328856.1\|	27933	g225232	i0	93.182	0.990243902439024	44	3	21	0	32	75	478	435	PREDICTED: Sycon ciliatum heat shock cognate 71 kDa protein-like (LOC135815540), mRNA	blastn	203	65.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
3454003	3454003	PRJNA928559_P_NODE_186623_length_253_cov_3.666667_g185054_i0	PRJNA928559	186623	253	3.666667	9.27666751	Corticium candelabrum	121492	Porifera	other_Eukaryota	84.2	8.14e-12	NTclustered	gi\|2575805697\|emb\|OY729849.1\|	121492	g185054	i0	82.653	0.786561264822134	98	14	38	3	35	130	1641	1545	Corticium candelabrum genome assembly, organelle: mitochondrion	blastn	199	84.2	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
14930177	14930177	PRJNA928559_P_NODE_126152_length_316_cov_2.958848_g124583_i0	PRJNA928559	126152	316	2.958848	9.34995968	Trikentrion flabelliforme	484460	Porifera	other_Eukaryota	82.4	3.77e-11	NTclustered	gi\|512765273\|gb\|KC869511.1\|	484460	g124583	i0	91.803	14.4620253164557	61	2	19	3	188	246	1911	1970	Trikentrion flabelliforme voucher NCI383 28S ribosomal RNA gene, partial sequence	blastn	4570	82.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Axinellida	Raspailiidae	Trikentrion	Trikentrion flabelliforme
19104253	19104253	PRJNA928559_P_NODE_169755_length_268_cov_1.948718_g168186_i0	PRJNA928559	169755	268	1.948718	5.22256424	Demospongiae	6042	Porifera	other_Eukaryota	121	6.63e-23	NTclustered	gi\|2749500559\|ref\|XR_010696300.1\|	196820	g168186	i0	88.35	39.5932835820896	103	9	38	3	165	267	3526	3625	PREDICTED: Dysidea avara large subunit ribosomal RNA (LOC136246210), rRNA	blastn	10611	121	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara

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