RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA438111" and tax_kingdom = "Loebvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Loebvirae · 6 ✖

bioproject 1

  • PRJNA438111 · 6 ✖

analysis 1

  • blastn · 6 ✖

tax_clade 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag 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
434585 434585 PRJNA438111_P_NODE_74141_length_162_cov_1.165414_g73516_i0 PRJNA438111 74141 162 1.165414 1.88797068 Inoviridae sp. 2219103 Viruses Viruses 300 4.36e-77   NTclustered gi|2057891989|tpg|BK051014.1| 2219103 g73516 i0 100 1 162 0 100 0 1 162 7336 7175 MAG TPA_asm: Inoviridae sp. isolate ctfkp1, partial genome blastn 162 300 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
1709178 1709178 PRJNA438111_P_NODE_5002_length_441_cov_4.140777_g4439_i0 PRJNA438111 5002 441 4.140777 18.26082657 Inoviridae sp. 2219103 Viruses Viruses 750 0   NTclustered gi|2057891989|tpg|BK051014.1| 2219103 g4439 i0 96.421 1.01360544217687 447 10 100 1 1 441 7862 7416 MAG TPA_asm: Inoviridae sp. isolate ctfkp1, partial genome blastn 447 750 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
4261744 4261744 PRJNA438111_P_NODE_81804_length_156_cov_4.417323_g81179_i0 PRJNA438111 81804 156 4.417323 6.89102388 Inoviridae sp. 2219103 Viruses Viruses 272 9.059999999999999e-69   NTclustered gi|2053040871|tpg|BK024249.1| 2219103 g81179 i0 98.077 1.76923076923077 156 3 100 0 1 156 8773 8928 MAG TPA_asm: Inoviridae sp. isolate ct4CW1, partial genome blastn 276 272 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
6812258 6812258 PRJNA438111_P_NODE_65286_length_167_cov_6.746377_g64661_i0 PRJNA438111 65286 167 6.746377 11.26644959 Inoviridae sp. 2219103 Viruses Viruses 211 2.18e-50   NTclustered gi|1433280767|gb|MH552488.1| 2219103 g64661 i0 99.145 6.64071856287425 117 1 70 0 1 117 2184 2068 MAG: Inoviridae sp. isolate ctda6, complete genome blastn 1109 211 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
11913217 11913217 PRJNA438111_P_NODE_63470_length_169_cov_1.535714_g62845_i0 PRJNA438111 63470 169 1.535714 2.59535666 Inoviridae sp. 2219103 Viruses Viruses 313 5.859999999999999e-81   NTclustered gi|2057891989|tpg|BK051014.1| 2219103 g62845 i0 100 1 169 0 100 0 1 169 6903 6735 MAG TPA_asm: Inoviridae sp. isolate ctfkp1, partial genome blastn 169 313 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
24660722 24660722 PRJNA438111_P_NODE_62560_length_169_cov_4.771429_g61935_i0 PRJNA438111 62560 169 4.771429 8.06371501 Inoviridae sp. 2219103 Viruses Viruses 313 5.859999999999999e-81   NTclustered gi|2057891989|tpg|BK051014.1| 2219103 g61935 i0 100 1 169 0 100 0 1 169 12917 12749 MAG TPA_asm: Inoviridae sp. isolate ctfkp1, partial genome blastn 169 313 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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