metadata: contig_metadata: 11 rows where bioproject = "PRJNA532380", tax_kingdom = "Metazoa" and tax

11 rows where bioproject = "PRJNA532380", tax_kingdom = "Metazoa" 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
6881876	6881876	PRJNA532380_P_NODE_5366_length_429_cov_4.107895_g5041_i0	PRJNA532380	5366	429	4.107895	17.62286955	Dysidea avara	196820	Porifera	other_Eukaryota	178	3.249999999999999e-55	NR	XP_065890751.1	196820	g5041	i0	78.7	0.755244755244755	108	23	75.5	0	417	94	1	108	XP_065890751.1 peptidyl-prolyl cis-trans isomerase FKBP1A-like [Dysidea avara]	diamond	324	178	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Dictyoceratida	Dysideidae	Dysidea	Dysidea avara
19630009	19630009	PRJNA532380_P_NODE_29056_length_167_cov_0.881356_g28731_i0	PRJNA532380	29056	167	0.881356	1.47186452	Corticium candelabrum	121492	Porifera	other_Eukaryota	145	2.25e-30	NTclustered	gi\|2664255179\|ref\|XM_062664534.1\|	121492	g28731	i0	82.424	2.97005988023952	165	29	99	0	1	165	649	485	PREDICTED: Corticium candelabrum 33 kDa inner dynein arm light chain, axonemal-like (LOC134195506), transcript variant X2, mRNA	blastn	496	145	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
23456352	23456352	PRJNA532380_P_NODE_399_length_1518_cov_8.735875_g329_i0	PRJNA532380	399	1518	8.735875	132.6105825	Opisthokonta	33154	Porifera	other_Eukaryota	551	6.159999999999999e-191	NR	AQM52339.1	121494	g329	i0	58.6	26.201581027668	457	175	89.9	5	21	1385	1	445	AQM52339.1 elongation factor 1 alpha, partial [Oscarella lobularis]	diamond	39774	556	0.991007194244604	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Oscarellidae	Oscarella	Oscarella lobularis
27140455	27140455	PRJNA532380_P_NODE_14982_length_233_cov_1.978261_g14657_i0	PRJNA532380	14982	233	1.978261	4.60934813	Geodia barretti	519541	Porifera	other_Eukaryota	134	7.299999999999999e-36	NR	CAI8012076.1	519541	g14657	i0	77.9	5.92274678111588	77	17	99.1	0	232	2	194	270	CAI8012076.1 Pyruvate dehydrogenase E1 component subunit alpha, somatic form, mitochondrial [Geodia barretti]	diamond	1380	134	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
27187326	27187326	PRJNA532380_P_NODE_28002_length_168_cov_1.428571_g27677_i0	PRJNA532380	28002	168	1.428571	2.39999928	Metazoa	33208	Porifera	other_Eukaryota	65.9	9.62e-11	NR	XP_062520393.1	121492	g27677	i0	55.4	8.91071428571429	56	25	100	0	168	1	266	321	XP_062520393.1 dihydrolipoyl dehydrogenase, mitochondrial-like [Corticium candelabrum]	diamond	1497	66.2	0.995468277945619	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
27993694	27993694	PRJNA532380_P_NODE_27485_length_169_cov_0.866667_g27160_i0	PRJNA532380	27485	169	0.866667	1.46466723	Sycon ciliatum	27933	Porifera	other_Eukaryota	82.4	1.36e-16	NR	XP_065176480.1	27933	g27160	i0	64.2	0.940828402366864	53	19	94.1	0	167	9	84	136	XP_065176480.1 T-complex protein 1 subunit zeta-like [Sycon ciliatum]	diamond	159	82.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Calcarea	Leucosolenida	Sycettidae	Sycon	Sycon ciliatum
28404032	28404032	PRJNA532380_P_NODE_18886_length_207_cov_1.626582_g18561_i0	PRJNA532380	18886	207	1.626582	3.36702474	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	55.5	7.12e-7	NR	XP_019851213.1	400682	g18561	i0	41.2	0.985507246376812	68	34	89.9	1	190	5	12	79	XP_019851213.1 PREDICTED: probable citrate synthase 2, mitochondrial [Amphimedon queenslandica]	diamond	204	55.5	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica
29587037	29587037	PRJNA532380_P_NODE_22110_length_191_cov_1.098592_g21785_i0	PRJNA532380	22110	191	1.098592	2.09831072	root	1	Root_unresolved	Root_unresolved	50.4	3.56e-5	NR	XP_062515092.1	121492	g21785	i0	41.7	1.90052356020942	60	35	94.2	0	3	182	332	391	XP_062515092.1 puromycin-sensitive aminopeptidase-like [Corticium candelabrum]	diamond	363	50.8	0.992125984251969	Eukaryota	Opisthokonta	Metazoa	Porifera	Homoscleromorpha	Homosclerophorida	Plakinidae	Corticium	Corticium candelabrum
30077417	30077417	PRJNA532380_P_NODE_21992_length_191_cov_1.577465_g21667_i0	PRJNA532380	21992	191	1.577465	3.01295815	Geodia barretti	519541	Porifera	other_Eukaryota	110	1.52e-28	NR	CAI8033038.1	519541	g21667	i0	91.2	5.3717277486911	57	5	89.5	0	189	19	158	214	CAI8033038.1 Ubiquitin-conjugating enzyme E2-17 kDa [Geodia barretti]	diamond	1026	110	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia barretti
30408981	30408981	PRJNA532380_P_NODE_33973_length_153_cov_2.500000_g33648_i0	PRJNA532380	33973	153	2.5	3.825	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	62.4	5.74e-10	NR	Q8WQ53.1	6047	g33648	i0	60.4	1.90196078431373	48	19	94.1	0	149	6	119	166	Q8WQ53.1 RecName: Full=Ras-related protein Rab-21 [Geodia cydonium]	diamond	291	62.4	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Tetractinellida	Geodiidae	Geodia	Geodia cydonium
30614588	30614588	PRJNA532380_P_NODE_15393_length_230_cov_1.436464_g15068_i0	PRJNA532380	15393	230	1.436464	3.3038672	Amphimedon queenslandica	400682	Porifera	other_Eukaryota	50.1	7.83e-5	NR	XP_019860123.1	400682	g15068	i0	47.5	0.521739130434783	40	21	52.2	0	25	144	264	303	XP_019860123.1 PREDICTED: uncharacterized protein LOC109588391 [Amphimedon queenslandica]	diamond	120	50.1	1	Eukaryota	Opisthokonta	Metazoa	Porifera	Demospongiae	Haplosclerida	Niphatidae	Amphimedon	Amphimedon queenslandica

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