metadata: contig_metadata: 8 rows where bioproject = "PRJNA473201" and tax

8 rows where bioproject = "PRJNA473201" 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
443687	443687	PRJNA473201_P_NODE_34241_length_339_cov_1.533835_g33499_i0	PRJNA473201	34241	339	1.533835	5.19970065	Corticium candelabrum	121492	Porifera	other_Eukaryota	146	2.0799999999999994e-42	NR	XP_062513968.1	121492	g33499	i0	73.7	6.50442477876106	99	26	87.6	0	338	42	37	135	XP_062513968.1 large ribosomal subunit protein eL21-like [Corticium candelabrum]	diamond	2205	146	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
18295528	18295528	PRJNA473201_P_NODE_46255_length_300_cov_7.259912_g45513_i0	PRJNA473201	46255	300	7.259912	21.779736	Sympagella nux	76350	Porifera	other_Eukaryota	52.8	0.028	NTclustered	gi\|146221442\|gb\|EF537577.1\|	76350	g45513	i0	94.118	0.113333333333333	34	2	11	0	124	157	15420	15387	Sympagella nux mitochondrion, partial genome	blastn	34	52.8	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Rossellidae	Sympagella	Sympagella nux
27076166	27076166	PRJNA473201_P_NODE_20482_length_436_cov_1.487603_g19740_i0	PRJNA473201	20482	436	1.487603	6.48594908	Dysidea avara	196820	Porifera	other_Eukaryota	117	1.84e-30	NR	XP_065905867.1	196820	g19740	i0	48.1	0.928899082568807	135	58	84.6	1	429	61	27	161	XP_065905867.1 transcription factor BTF3 homolog 4-like isoform X1 [Dysidea avara]	diamond	405	117	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
27202399	27202399	PRJNA473201_P_NODE_72802_length_248_cov_0.880000_g72060_i0	PRJNA473201	72802	248	0.88	2.1824	Dysidea avara	196820	Porifera	other_Eukaryota	62	6.59e-9	NR	XP_065905323.1	196820	g72060	i0	42.7	3.70161290322581	75	39	89.5	2	13	234	1395	1466	XP_065905323.1 hemicentin-1-like [Dysidea avara]	diamond	918	62	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
28529085	28529085	PRJNA473201_P_NODE_58947_length_269_cov_1.214286_g58205_i0	PRJNA473201	58947	269	1.214286	3.26642934	Suberites domuncula	55567	Porifera	other_Eukaryota	116	1.9e-30	NR	Q4KTG9.1	55567	g58205	i0	69.5	0.91449814126394	82	25	91.4	0	248	3	3	84	Q4KTG9.1 RecName: Full=Large ribosomal subunit protein uL22; AltName: Full=60S ribosomal protein L17 [Suberites domuncula]	diamond	246	116	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Suberitidae	Suberites	Suberites domuncula
29712940	29712940	PRJNA473201_P_NODE_61250_length_263_cov_1.152632_g60508_i0	PRJNA473201	61250	263	1.152632	3.03142216	Porifera	6040	Porifera	other_Eukaryota	149	4.02e-41	NR	XP_062518605.1	121492	g60508	i0	79.3	14.8859315589354	87	18	99.2	0	261	1	324	410	XP_062518605.1 actin-related protein 3-A [Corticium candelabrum]	diamond	3915	149	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
30314057	30314057	PRJNA473201_P_NODE_70792_length_249_cov_0.875000_g70050_i0	PRJNA473201	70792	249	0.875	2.17875	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	104	9.33e-26	NR	KAI6647939.1	111878	g70050	i0	73.2	10.3614457831325	71	19	85.5	0	213	1	1	71	KAI6647939.1 60S ribosomal protein L13a [Oopsacas minuta]	diamond	2580	104	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Hexactinellida	Lyssacinosida	Leucopsacidae	Oopsacas	Oopsacas minuta
32857249	32857249	PRJNA473201_P_NODE_66380_length_251_cov_0.865169_g65638_i0	PRJNA473201	66380	251	0.865169	2.17157419	Halichondria panicea	6063	Porifera	other_Eukaryota	45.1	0.00501	NR	XP_064384876.1	6063	g65638	i0	40.5	0.944223107569721	79	42	89.6	3	225	1	47	124	XP_064384876.1 cilia- and flagella-associated protein 107-like [Halichondria panicea]	diamond	237	45.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Suberitida	Halichondriidae	Halichondria	Halichondria panicea

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