metadata: contig_metadata: 10 rows where bioproject = "PRJNA1233465" and tax

10 rows where bioproject = "PRJNA1233465" and tax_kingdom = "Loebvirae"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
25671966	25671966	PRJNA1233465a_S_NODE_92930_length_236_cov_1.090909_g91656_i0	PRJNA1233465	92930	236	1.090909	2.57454524	Inoviridae sp.	2219103	Viruses	Viruses	195	3.3199999999999996e-45	NTclustered	gi\|2906147821\|gb\|PQ646343.1\|	2219103	g91656	i0	84.158	3.36864406779661	202	30	85	2	36	236	3429	3229	MAG: Inoviridae sp. isolate k127_3061565 genomic sequence	blastn	795	195	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae		Inoviridae sp.
25757228	25757228	PRJNA1233465b_S_NODE_82322_length_295_cov_4.951220_g80637_i0	PRJNA1233465	82322	295	4.95122	14.606099	Viruses	10239	Viruses	Viruses	117	9.57e-22	NTclustered	gi\|2906153115\|gb\|PQ646699.1\|	2219103	g80637	i0	80.12	2.57627118644068	166	25	54	8	115	273	7247	7083	MAG: Inoviridae sp. isolate k127_4419695 genomic sequence	blastn	760	117	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae		Inoviridae sp.
26218911	26218911	PRJNA1233465b_S_NODE_254014_length_189_cov_0.992857_g252329_i0	PRJNA1233465	254014	189	0.992857	1.87649973	Inoviridae sp.	2219103	Viruses	Viruses	206	1.1799999999999999e-48	NTclustered	gi\|2906152048\|gb\|PQ646632.1\|	2219103	g252329	i0	86.559	0.984126984126984	186	25	98	0	4	189	5018	4833	MAG: Inoviridae sp. isolate k127_3879901 genomic sequence	blastn	186	206	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae		Inoviridae sp.
26220204	26220204	PRJNA1233465b_S_NODE_362126_length_162_cov_1.955752_g360441_i0	PRJNA1233465	362126	162	1.955752	3.16831824	Inoviridae sp.	2219103	Viruses	Viruses	99	1.71e-16	NTclustered	gi\|2906147821\|gb\|PQ646343.1\|	2219103	g360441	i0	93.846	0.796296296296296	65	4	40	0	1	65	3365	3429	MAG: Inoviridae sp. isolate k127_3061565 genomic sequence	blastn	129	99	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae		Inoviridae sp.
26356267	26356267	PRJNA1233465b_S_NODE_41871_length_374_cov_2.421538_g40186_i0	PRJNA1233465	41871	374	2.421538	9.05655212	Inoviridae sp.	2219103	Viruses	Viruses	106	2.69e-18	NTclustered	gi\|2906147821\|gb\|PQ646343.1\|	2219103	g40186	i0	81.481	0.36096256684492	135	19	35	6	44	175	2935	2804	MAG: Inoviridae sp. isolate k127_3061565 genomic sequence	blastn	135	106	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae		Inoviridae sp.
26356371	26356371	PRJNA1233465b_S_NODE_4831_length_884_cov_10.653892_g3981_i0	PRJNA1233465	4831	884	10.653892	94.18040528	Inoviridae sp.	2219103	Viruses	Viruses	348	1.02e-90	NTclustered	gi\|2906145470\|gb\|PQ646183.1\|	2219103	g3981	i0	82.338	10.027149321267	402	69	45	2	50	450	2611	2211	MAG: Inoviridae sp. isolate k127_2418720 genomic sequence	blastn	8864	348	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae		Inoviridae sp.
26357079	26357079	PRJNA1233465b_S_NODE_9103_length_689_cov_6.417187_g7888_i0	PRJNA1233465	9103	689	6.417187	44.21441843	Inoviridae sp.	2219103	Viruses	Viruses	1013	0	NTclustered	gi\|2056837707\|tpg\|BK044060.1\|	2219103	g7888	i0	94.521	214.759071117562	657	34	95	2	1	656	2221	2876	MAG TPA_asm: Inoviridae sp. isolate ctXjl4, partial genome	blastn	147969	1013	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae		Inoviridae sp.
26486306	26486306	PRJNA1233465a_S_NODE_23608_length_387_cov_2.491124_g22336_i0	PRJNA1233465	23608	387	2.491124	9.64064988	Inoviridae sp.	2219103	Viruses	Viruses	84.2	1.31e-11	NTclustered	gi\|2906147821\|gb\|PQ646343.1\|	2219103	g22336	i0	81.905	0.271317829457364	105	14	26	5	286	387	2804	2906	MAG: Inoviridae sp. isolate k127_3061565 genomic sequence	blastn	105	84.2	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae		Inoviridae sp.
26495556	26495556	PRJNA1233465d_S_NODE_24096_length_333_cov_1.063380_g22985_i0	PRJNA1233465	24096	333	1.06338	3.5410554	Stenotrophomonas phage SMA6	1346893	Viruses	Viruses	442	1.5899999999999995e-119	NTclustered	gi\|1694995567\|ref\|NC_043029.1\|	1346893	g22985	i0	90.881	24.7297297297297	329	30	99	0	3	331	3781	4109	Stenotrophomonas phage phiSMA6 proviral complete genome	blastn	8235	442	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae	Scuticavirus	Scuticavirus SMA6
26513421	26513421	PRJNA1233465f_S_NODE_78808_length_264_cov_2.293023_g76528_i0	PRJNA1233465	78808	264	2.293023	6.05358072	Stenotrophomonas phage SMA6	1346893	Viruses	Viruses	315	2.79e-81	NTclustered	gi\|1694995567\|ref\|NC_043029.1\|	1346893	g76528	i0	89.558	15.7310606060606	249	25	94	1	1	248	4025	3777	Stenotrophomonas phage phiSMA6 proviral complete genome	blastn	4153	315	1	Viruses	Loebvirae	Hofneiviricota	Faserviricetes	Tubulavirales	Inoviridae	Scuticavirus	Scuticavirus SMA6

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